April 1, 2016 at 9:38 am
We're having a problem with one SQL2008 SP2 server (running on Windows 2008 SP2)/
Periodically, at unpredictable times, the SQL server will simply stop communication with all applications. No errors in SQL logs, or Windows logs.
The server itself is reachable by RDP, attempting to restart SQL service first times out, then we can start the service on the next attempt. Once the restart is complete, it comes up as normal.
Any thoughts as to where I should look?
...
-- FORTRAN manual for Xerox Computers --
April 1, 2016 at 10:08 am
Look at the tempdb log file size and growth amount, particularly if it is a % (which you should change to a fixed amount: never use %, no matter what any MS examples show). You might also check msdb, although that is far less likely to cause a problem.
Check the obvious too: make sure no dbs specify auto_close or auto_shrink.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply