andrew_transparent
asked on
Server 2008 x64 becomes unresponsive in the morning
Server info:
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.?
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.?
Scheduled job hanging up possibly?
ASKER
I've double-checked and confirmed that there are no scheduled jobs running at those times when it becomes unresponsive.
Could be a long-running one that's hanging. Anything starting after-hours that's not completing?
ASKER
no tasks are still running and hung up.
yes, there are tasks running after hours, but are completing properly.
yes, there are tasks running after hours, but are completing properly.
Is SQL in a clustered environment? Can you do anything with the server itself? The next time it happens can you terminate the sql service remotely and see if that "wakes it up"?
Anything in the eventvwr under application or system?
Anything in the eventvwr under application or system?
ASKER
We can't RDC or move the mouse on the server.
It doesn't respond to any actions we try to do..
i found another issue here and they resolved it by disabling the "Offloading" feature of all network cards, i did that last week and thought it had fixed it, but it just froze again this morning and had to power it down manually.
i'll check the logs again.
It doesn't respond to any actions we try to do..
i found another issue here and they resolved it by disabling the "Offloading" feature of all network cards, i did that last week and thought it had fixed it, but it just froze again this morning and had to power it down manually.
i'll check the logs again.
Any luck with the logs?
ASKER
nope nothing in the logs..
we ran the dell extended diagnostics and got no errors.
we checked the bios and noticed that its only set to use 4GB of its 8GB memory.
we have since changed that to use it fully and performance is better than before.
*fingers crossed* and hopefully it doesnt freeze up again.
we ran the dell extended diagnostics and got no errors.
we checked the bios and noticed that its only set to use 4GB of its 8GB memory.
we have since changed that to use it fully and performance is better than before.
*fingers crossed* and hopefully it doesnt freeze up again.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i meant, it froze again and we had to hard reboot the server once again.
might be a hardware issue. Do you have physical access to the server? Would also recommend a RAM test (software).
http://pcsupport.about.com/od/toolsofthetrade/tp/memorytest.htm
http://pcsupport.about.com/od/toolsofthetrade/tp/memorytest.htm
ASKER
we have contacted microroft for this weird issue.