Array
(
)

Congelamento SQL Server 2008 R2

Augusto Almeida
   - 30 ago 2012

Bom dia a todos,
Estou com servidor SQL 2008 R2 com SP2 (10.50.4000) apresentando congelamentos intermitentes. Funciona sem apresentar problemas durante um período porém em algum momento ele começa a rejeitar conexoes.
Ao procurar LOG´s não encontrei muitos registros de que denunciem o problema. apenas que toda vez o primeiro LOG é da DLL
'dbghelp.dll' version '4.0.5'
Agradeço qualquer ajuda.

---------------------------
Message
Using 'dbghelp.dll' version '4.0.5'
---------------------------
Message
**Dump thread - spid = 0, EC = 0x0000000000000000
---------------------------
Message
***Stack Dump being sent to E:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0003.txt
-------------------------- Conteudo do Arquivo SQLDump0003.txt
Current time is 11:01:21 08/29/12.
=====================================================================
BugCheck Dump
=====================================================================
This file is generated by Microsoft SQL Server
version 10.50.4000.0
upon detection of fatal unexpected error. Please return this file,
the query or program that produced the bugcheck, the database and
the error log, and any other pertinent information with a Service Request.

Computer type is Intel(R) Xeon(R) CPU E5-2650 0 @ 2.00GHz.
Bios Version is IBM - 0
32 X64 level 8664, 1 Mhz processor (s).
Windows NT 6.1 Build 7601 CSD Service Pack 1.
Memory
MemoryLoad = 84%
Total Physical = 131048 MB
Available Physical = 20754 MB
Total Page File = 328678 MB
Available Page File = 215795 MB
Total Virtual = 8388607 MB
Available Virtual = 8254659 MB
**Dump thread - spid = 0, EC = 0x0000000000000000
***Stack Dump being sent to E:\MSSQL10_50.MSSQLSERVER\MSSQL\LOG\SQLDump0003.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 08/29/12 11:01:21 spid 6772
*
* Deadlocked Schedulers
*
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
_________________
-----------------