Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
nitin1353
Constraint Violating Yak Guru
381 Posts |
 Posted - 2005-02-16 : 19:19:20
|
| hii have a problem with sqlserver.it is timing out very frequently.is thee any method we need to be get informed automatically when the SQL Server is about to time out.Plz helpRegardsNitin |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-16 : 19:22:22
|
| You need to examine your query to make sure it is efficient, make sure you are properly indexed, review your database design, check fragmentation on the indexes, check hardware performance, etc...If none of that leads you to a solution, then increase your timeout in your application to more than 30 seconds, which is the default. So IOW, SQL Server isn't the one timing you out. SQL Server will actually let you run queries indefinitely. It's the application that is timing out.Tara |
 |
|
|
|
|
|
Sqlserver tineout