Solved

SQL 2012 Server hangs Windows, forces me to reboot

Posted on 2016-09-25
4
44 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
  • 2
4 Comments
 
LVL 33

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 47

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 47

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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

773 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