Solved

SQL 2012 Server hangs Windows, forces me to reboot

Posted on 2016-09-25
4
45 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 48

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 48

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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

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…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

840 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