Server 2008 x64 becomes unresponsive in the morning
Posted on 2011-03-17
Lets call it SQL1
Server 2008 Standard x64
8GB RAM, 2 x Xeon Processors
Mainly used as a SQL Database server.
C:\ is local
D:\ is iSCSI volumes on SAN1 (which holds all the database for SQL 2008)
This server has been becoming unresponsive in the morning (at least once a week) and we have to manually shut it down to get it back and running.
Users are unable to access the server via SQL Server Management Studio when the server becomes unresponsive, but the weird thing is that they also have mapped drives to a share on the same server (SAN1) where the iSCSI volume is stored and they are able to access it. So I'm pretty sure its not the SAN1 causing all these..
When they go to the server (SQL1) and check the monitor, its just frozen and unable to do anything.
I dont see much errors in the event viewer that might be causing this..
Any ideas what to check or what could be causing this.?