question

askmlx121 avatar image
askmlx121 asked

Server Timed out..........

hi SQL Expert community, Welcome in concern, We are using windows server 2003.Disk space is 320 GB. But now we have face daily Time out error message came ......... So how can we sort out this? which are causes? who is major responsible for this?
sql-server-2005performanceserver
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Blackhawk-17 avatar image Blackhawk-17 commented ·
Where are you seeing the errors... and is the Client pointing to the right server?
1 Like 1 ·
askmlx121 avatar image askmlx121 commented ·
any one help.........me...........
0 Likes 0 ·
Tim avatar image
Tim answered
Are just certain queries timing out? Any error messages in your Windows Event logs, SQL Server Logs, when is the last time statistics were updated, indexes optimized, server restarted? Has the work load increased, any changes been made to the environment, version of SQL Server you are running, number of processors, cores, memory, 32bit or 64bit? Give us as much information as you can.
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

askmlx121 avatar image askmlx121 commented ·
hi tim, no error messages in Windows event logs and Sql server logs last time statistics updated: 20 saturday 2012 server restarted: 3 months before has the work load increased: no version of SQL Server: 2005 number of processors: 2 xeon processors memory: 4 GB memory bit: 64 bit server: windows server 2003 r2 service pack 2 tell me the reason and sort out method?
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
what are your SQL Server Setting regarding remote query timeout and connectino timeout
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

askmlx121 avatar image askmlx121 commented ·
hi ramesh thanking you very much..... remote query time out is 600 Sec execution time out is 0 Sec... connection time out is 20 sec
0 Likes 0 ·
Grant Fritchey avatar image
Grant Fritchey answered
As configured, SQL Server will run local queries forever. Any timeout is coming from your client application. You need to modify connection settings there to extend the timeout time. But, if you are getting queries that are exceeding the timeout setting on the client app, you may need to tune those queries to make them run faster. Start with collecting query metrics. If you're using 2005 or less, you'll have to use trace events. If you're using 2008 or better you should use extended events. From there, you can identify which queries are running long. Then you figure out why. It could be something such as a bad or missing index but is more likely to be a coding issue. For details on how to do this, I'd suggest getting a copy of my book. There's a 2008 version that works with 2005 or a 2012 version. This link is to the [2012 version][1]. [1]: http://www.amazon.com/Server-2012-Query-Performance-Tuning/dp/1430242035/ref=sr_1_2?ie=UTF8&qid=1350990122&sr=8-2&keywords=query+tuning
5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Nope. Sorry, those books on tuning are not free.
3 Likes 3 ·
Fatherjack avatar image Fatherjack ♦♦ commented ·
While they aren't free, those books are indeed good value. The time and effort invested in them is immense and they are worth every penny you pay.
2 Likes 2 ·
askmlx121 avatar image askmlx121 commented ·
hi i want free ebooks........if available means....give me the link......plz
0 Likes 0 ·
sp_lock avatar image sp_lock commented ·
You could try @Grants book from Redgate. These are free http://www.red-gate.com/community/books/
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Thank you very much. But, that book doesn't show how to gather query metrics. It just shows how to interpret execution plans. BTW, there'll be an update out for it soon (also free).
0 Likes 0 ·
ramesh 1 avatar image
ramesh 1 answered
do you have queries which run more than 20 sec
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.