Solved

Server 2008 x64 becomes unresponsive in the morning

Posted on 2011-03-17
12
825 Views
Last Modified: 2012-08-13
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.?
0
Comment
Question by:andrew_transparent
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 5
12 Comments
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 35158038
Scheduled job hanging up possibly?
0
 
LVL 1

Author Comment

by:andrew_transparent
ID: 35158156
I've double-checked and confirmed that there are no scheduled jobs running at those times when it becomes unresponsive.
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 35158554
Could be a long-running one that's hanging.  Anything starting after-hours that's not completing?
0
Connect further...control easier

With the ATEN CE624, you can now enjoy a high-quality visual experience powered by HDBaseT technology and the convenience of a single Cat6 cable to transmit uncompressed video with zero latency and multi-streaming for dual-view applications where remote access is required.

 
LVL 1

Author Comment

by:andrew_transparent
ID: 35158790
no tasks are still running and hung up.
yes, there are tasks running after hours, but are completing properly.
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 35164808
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?

0
 
LVL 1

Author Comment

by:andrew_transparent
ID: 35208193
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.
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 35258475
Any luck with the logs?
0
 
LVL 1

Author Comment

by:andrew_transparent
ID: 35259973
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.
0
 
LVL 1

Accepted Solution

by:
andrew_transparent earned 0 total points
ID: 35319428
so it just restarted again this afternoon.
contacting microsoft right now, see what they can find.. :(
0
 
LVL 1

Author Comment

by:andrew_transparent
ID: 35319431
i meant, it froze again and we had to hard reboot the server once again.
0
 
LVL 40

Expert Comment

by:Kyle Abrahams
ID: 35324310
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

0
 
LVL 1

Author Closing Comment

by:andrew_transparent
ID: 35503388
we have contacted microroft for this weird issue.
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question