We have Microsoft SQL Server 2005 - 9.00.4207.00 (X64) Enterprise Edition (64-bit) on Windows server 2003 (Build 3790: Service Pack 2) .
Periodically (~ once per 15 min) some db-clients have error messages when open connection (over SQL Native Client ) like:
Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
All timeouts more or equal 15 sec. Less then 15 sec is not acceptable by business rules. Performance counters (cpu,memory,disk etc.) on server does not show bottleneck. Only one sql counter - logins/sec show trouble. When problem exists then this counter
= 0. Also dramatically decrease many other counters - sql batch requests/sec, transactions/sec, cpu load and some ones. SQL Server "sleep" few seconds (4 - 5) and then accessible again.
View Complete Post