Solved

SQL 2012 Server hangs Windows, forces me to reboot

Posted on 2016-09-25
4
60 Views
Last Modified: 2016-10-31
I'm not sure what's been going on with the DBA and the SQL server, but I'm wondering if anyone could help me analyze SQL dump file around the time the server that SQL 2012 is on (Windows Server 2012) became unresponsive.
I'll note that "Priority Boost" was enabled at the time, but I believe it's been enabled for about a month and only recently saw these issues.

This is the contents of the dump file, as I analyzed from WinDbg:

0:005> kc 100
 # Call Site
00 ntdll!NtWaitForSingleObject
*** WARNING: Unable to verify timestamp for sqlservr.exe
01 KERNELBASE!WaitForSingleObjectEx
02 sqlservr!CDmpDump::DumpInternal
*** WARNING: Unable to verify timestamp for sqllang.dll
03 sqlservr!CDmpDump::Dump
04 sqllang!SQLDumperLibraryInvoke
05 sqllang!CImageHelper::DoMiniDump
06 sqllang!stackTrace
*** WARNING: Unable to verify timestamp for sqldk.dll
07 sqlservr!SQL_SOSDeadlockSchedulersCallback
08 sqldk!SOS_OS::ExecuteDeadlockSchedulerCallbacks
09 sqldk!SchedulerMonitor::CheckSchedulers
0a sqldk!SchedulerMonitor::Run
0b sqldk!SchedulerMonitor::EntryPoint
0c sqldk!SOS_Task::Param::Execute
0d sqldk!SOS_Scheduler::RunTask
0e sqldk!SOS_Scheduler::ProcessTasks
0f sqldk!SchedulerManager::WorkerEntryPoint
10 sqldk!SystemThread::RunWorker
11 sqldk!SystemThreadDispatcher::ProcessWorker
12 sqldk!SchedulerManager::ThreadEntryPoint
13 kernel32!BaseThreadInitThunk
14 ntdll!RtlUserThreadStart
0
Comment
Question by:garryshape
[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
  • 2
4 Comments
 
LVL 34

Accepted Solution

by:
ste5an earned 250 total points
ID: 41814915
Take a look at SQL Server error logs. Use also a SQL profiler trace when this happens. Seems like your running into blocking (deadlocks) permantently.
0
 
LVL 51

Assisted Solution

by:Vitor Montalvão
Vitor Montalvão earned 250 total points
ID: 41823435
What's the behavior of the SQL Server instance? It stops and shut down? It stop and restart? It hangs but after a while it is responsive again?
Windows Event Log and SQL Server Logs are also good to check for more detailed error messages.
0
 
LVL 51

Expert Comment

by:Vitor Montalvão
ID: 41843677
Garry, a feedback will be appreciated.
Cheers.
0
 

Author Comment

by:garryshape
ID: 41853013
These helped, but issue was to turn off performance boost
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

615 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