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?
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.
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]. :