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?
Where are you seeing the errors... and is the Client pointing to the right server?
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.
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?
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
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.
You could try @Grants book from Redgate. These are free
http://www.red-gate.com/community/books/
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).
do you have queries which run more than 20 sec
14 People are following this question.
