Добро пожаловать в форум, Guest  >>   Войти | Регистрация | Поиск | Правила | В избранное | Подписаться
Все форумы / Microsoft SQL Server Новый топик    Ответить
 SQL Server Stack Dump  [new]
Eduard Minasyan
Member

Откуда:
Сообщений: 119
Доброго всем дня,

У меня SQL Server 2005 х64 SP4, в последнее время почти раз в сутки сервер умирает и кроме рестарта ничего сделать нельзя.
Помогите пожалуйста, что можно сделать?
Вот что в логе.
=====================================================================
BugCheck Dump
=====================================================================

This file is generated by Microsoft SQL Server
version 9.00.5000.00
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 AT/AT COMPATIBLE.
Bios Version is _ASUS_ - 1072009
BIOS Date: 10/16/12 14:30:55 Ver: 08.04
Current time is 16:06:14 02/16/13.
4 Unknown CPU 9., 3 Mhz processor (s).
Windows NT 6.1 Build 7601 CSD Service Pack 1.

Memory
MemoryLoad = 75%
Total Physical = 7991 MB
Available Physical = 1931 MB
Total Page File = 15981 MB
Available Page File = 10005 MB
Total Virtual = 8388607 MB
Available Virtual = 8380261 MB
**Dump thread - spid = 69, PSS = 0x000000016BF6DE80, EC = 0x000000016BF6DE90
*
* User initiated stack dump. This is not a server exception dump.
*
***Stack Dump being sent to C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLDump2694.txt
* *******************************************************************************
*
* BEGIN STACK DUMP:
* 02/16/13 16:06:14 spid 69
*
* ex_raise2: Exception raised, major=52, minor=42, state=1, severity=22
*
* Input Buffer 255 bytes -
* ÿÿ cL 2 ff ff 0a 00 00 00 00 00 63 4c 00 00 00 09 04 00 01 32
* L E X E C s e 4c 00 00 00 45 00 58 00 45 00 43 00 20 00 73 00 65 00
* l _ C O N T R A C 6c 00 5f 00 43 00 4f 00 4e 00 54 00 52 00 41 00 43 00
* T @ P 1 , @ P 54 00 20 00 40 00 50 00 31 00 2c 00 20 00 40 00 50 00
* 2 , @ P 3 , @ 32 00 2c 00 20 00 40 00 50 00 33 00 2c 00 20 00 40 00
* P 4 cf 50 00 34 00 0d 00 0a 00 00 00 63 66 00 00 00 09 04 00
* 2f @ P 1 s m 01 32 66 00 00 00 40 00 50 00 31 00 20 00 73 00 6d 00
* a l l i n t , @ P 61 00 6c 00 6c 00 69 00 6e 00 74 00 2c 00 40 00 50 00
* 2 d a t e t i m 32 00 20 00 64 00 61 00 74 00 65 00 74 00 69 00 6d 00
* e , @ P 3 s m a 65 00 2c 00 40 00 50 00 33 00 20 00 73 00 6d 00 61 00
* l l i n t , @ P 4 6c 00 6c 00 69 00 6e 00 74 00 2c 00 40 00 50 00 34 00
* d a t e t i m e 20 00 64 00 61 00 74 00 65 00 74 00 69 00 6d 00 65 00
* & o g¡ 00 00 26 02 02 04 00 00 00 6f 08 08 67 a1 00 00 00 00
* & o g¡ 00 00 00 00 26 02 02 01 00 00 00 6f 08 08 67 a1 00 00
* 00 00 00 00
*
*
* MODULE BASE END SIZE
* sqlservr 0000000001000000 0000000003651FFF 02652000
* ntdll 0000000077960000 0000000077B08FFF 001a9000
* kernel32 0000000077280000 000000007739EFFF 0011f000
* KERNELBASE 000007FEFDF90000 000007FEFDFFAFFF 0006b000
* MSVCR80 00000000735D0000 0000000073698FFF 000c9000
* msvcrt 000007FEFE270000 000007FEFE30EFFF 0009f000
* MSVCP80 00000000734C0000 00000000735C8FFF 00109000
* ADVAPI32 000007FEFF650000 000007FEFF72AFFF 000db000
* sechost 000007FEFF3E0000 000007FEFF3FEFFF 0001f000
* RPCRT4 000007FEFF0A0000 000007FEFF1CCFFF 0012d000
* sqlos 00000000344D0000 00000000344D6FFF 00007000
* Secur32 000007FEFDBC0000 000007FEFDBCAFFF 0000b000
* SSPICLI 000007FEFDC10000 000007FEFDC34FFF 00025000
* USERENV 000007FEFD100000 000007FEFD11DFFF 0001e000
* profapi 000007FEFDDC0000 000007FEFDDCEFFF 0000f000
* WINMM 000007FEFAAA0000 000007FEFAADAFFF 0003b000
* USER32 0000000077700000 00000000777F9FFF 000fa000
* GDI32 000007FEFF420000 000007FEFF486FFF 00067000
* LPK 000007FEFF400000 000007FEFF40DFFF 0000e000
* USP10 000007FEFF730000 000007FEFF7F8FFF 000c9000
* opends60 00000000333E0000 00000000333E7FFF 00008000
* NETAPI32 000007FEFB2F0000 000007FEFB305FFF 00016000
* netutils 000007FEFB5A0000 000007FEFB5ABFFF 0000c000
* srvcli 000007FEFD9B0000 000007FEFD9D2FFF 00023000
* wkscli 000007FEFB2D0000 000007FEFB2E4FFF 00015000
* LOGONCLI 000007FEFD450000 000007FEFD47FFFF 00030000
* DSROLE 000007FEFC610000 000007FEFC61BFFF 0000c000
* IMM32 000007FEFF1D0000 000007FEFF1FDFFF 0002e000
* MSCTF 000007FEFF800000 000007FEFF908FFF 00109000
* psapi 0000000077B30000 0000000077B36FFF 00007000
* instapi 0000000048060000 000000004806CFFF 0000d000
* cscapi 000007FEFA910000 000007FEFA91EFFF 0000f000
* sqlevn70 000000004F610000 000000004F7B8FFF 001a9000
* ntmarta 000007FEFCEE0000 000007FEFCF0CFFF 0002d000
* WLDAP32 000007FEFF910000 000007FEFF961FFF 00052000
* CRYPTSP 000007FEFD740000 000007FEFD756FFF 00017000
* rsaenh 000007FEFD310000 000007FEFD356FFF 00047000
* CRYPTBASE 000007FEFDCB0000 000007FEFDCBEFFF 0000f000
* BROWCLI 000007FEF8C00000 000007FEF8C11FFF 00012000
* SAMCLI 000007FEFAC90000 000007FEFACA3FFF 00014000
* AUTHZ 000007FEFD820000 000007FEFD84EFFF 0002f000
* MSCOREE 000007FEFA9B0000 000007FEFAA1EFFF 0006f000
* mscoreei 000007FEFA920000 000007FEFA9AFFFF 00090000
* ole32 000007FEFF9E0000 000007FEFFBE2FFF 00203000
* credssp 000007FEFD420000 000007FEFD429FFF 0000a000
* msv1_0 000007FEFD680000 000007FEFD6D0FFF 00051000
* cryptdll 000007FEFD8D0000 000007FEFD8E3FFF 00014000
* kerberos 000007FEFD590000 000007FEFD643FFF 000b4000
* MSASN1 000007FEFDE60000 000007FEFDE6EFFF 0000f000
* schannel 000007FEFD360000 000007FEFD3B5FFF 00056000
* CRYPT32 000007FEFE020000 000007FEFE189FFF 0016a000
* COMRES 0000000070E20000 0000000070F5DFFF 0013e000
* XOLEHLP 000007FEF8080000 000007FEF8093FFF 00014000
* VERSION 000007FEFCF10000 000007FEFCF1BFFF 0000c000
* MSDTCPRX 000007FEF7FC0000 000007FEF807BFFF 000bc000
* MTXCLU 000007FEF7F60000 000007FEF7FBFFFF 00060000
* WS2_32 000007FEFF970000 000007FEFF9BCFFF 0004d000
* NSI 000007FEFF410000 000007FEFF417FFF 00008000
* CLUSAPI 000007FEF7F10000 000007FEF7F5FFFF 00050000
* RESUTILS 000007FEF7EF0000 000007FEF7F08FFF 00019000
* bcrypt 000007FEFD7A0000 000007FEFD7C1FFF 00022000
* ktmw32 000007FEFBDB0000 000007FEFBDB9FFF 0000a000
* mswsock 000007FEFD530000 000007FEFD584FFF 00055000
* DNSAPI 000007FEFD3C0000 000007FEFD41AFFF 0005b000
* IPHLPAPI 000007FEFB550000 000007FEFB576FFF 00027000
* WINNSI 000007FEFB680000 000007FEFB68AFFF 0000b000
* fwpuclnt 000007FEFB5D0000 000007FEFB622FFF 00053000
* rasadhlp 000007FEF7EE0000 000007FEF7EE7FFF 00008000
* wship6 000007FEFD730000 000007FEFD736FFF 00007000
* RpcRtRemote 000007FEFDDA0000 000007FEFDDB3FFF 00014000
* security 0000000071A50000 0000000071A52FFF 00003000
* SHELL32 000007FEFE310000 000007FEFF097FFF 00d88000
* SHLWAPI 000007FEFF530000 000007FEFF5A0FFF 00071000
* msfte 0000000049980000 0000000049D30FFF 003b1000
* OLEAUT32 000007FEFE190000 000007FEFE266FFF 000d7000
* dbghelp 00000000713E0000 000000007153CFFF 0015d000
* WINTRUST 000007FEFDF50000 000007FEFDF88FFF 00039000
* ncrypt 000007FEFD7D0000 000007FEFD81CFFF 0004d000
* wshtcpip 000007FEFCFE0000 000007FEFCFE6FFF 00007000
* ntdsapi 000007FEF5C80000 000007FEF5CA6FFF 00027000
* CLBCatQ 000007FEFF490000 000007FEFF528FFF 00099000
* sqlncli 00000000337A0000 0000000033A63FFF 002c4000
* COMCTL32 000007FEF5BE0000 000007FEF5C7FFFF 000a0000
* comdlg32 000007FEFF5B0000 000007FEFF646FFF 00097000
* SQLNCLIR 0000000035000000 0000000035032FFF 00033000
* netbios 000007FEF5BD0000 000007FEF5BD9FFF 0000a000
* msftepxy 0000000003FA0000 0000000003FC0FFF 00021000
* bcryptprimitives 000007FEFD270000 000007FEFD2BBFFF 0004c000
* xpsqlbot 000000004A7C0000 000000004A7C7FFF 00008000
* xpstar90 0000000053C30000 0000000053CB7FFF 00088000
* SQLSCM90 0000000053AD0000 0000000053ADBFFF 0000c000
* ODBC32 000007FEF5470000 000007FEF5520FFF 000b1000
* BatchParser90 00000000520C0000 00000000520ECFFF 0002d000
* ATL80 000000007C630000 000000007C64DFFF 0001e000
* odbcint 00000000712C0000 00000000712F7FFF 00038000
* xpstar90 000000000B7D0000 000000000B7F5FFF 00026000
* xplog70 0000000034730000 000000003473FFFF 00010000
* xplog70 000000000B810000 000000000B812FFF 00003000
* SAMLIB 000007FEFAC70000 000007FEFAC8CFFF 0001d000
* apphelp 000007FEFDC50000 000007FEFDCA6FFF 00057000
*
* P1Home: 0000000000000230:
* P2Home: 00000000003E0000: 0000000000000000 01008E3ACA90F50F 00000000FFEEFFEE 0000000003E80018 00000000
003E0128 00000000003E0000
* P3Home: 0000008E00000000:
* P4Home: 0000000200000201:
* P5Home: 0000008E00000000:
* P6Home: 0000000000000000:
* ContextFlags: 000000000010004F:
* MxCsr: 0000000000001FA0:
* SegCs: 0000000000000033:
* SegDs: 000000000000002B:
* SegEs: 000000000000002B:
* SegFs: 0000000000000053:
* SegGs: 000000000000002B:
* SegSs: 000000000000002B:
* EFlags: 0000000000000206:
* Rax: 000000006792D91E:
* Rcx: 00000000103BA2D0: 0000000000000230 00000000003E0000 0000008E00000000 0000000200000201 0000008E
00000000 0000000000000000
* Rdx: 0000000000000000:
* Rbx: 0000000000000000:
* Rsp: 00000000103BA8E0: 0000000000000000 00000000103BAB90 000000016BF6DE80 0000000000000080 00000000
000042AC 0000000000000000
* Rbp: 00000000FFFFFFFF: 0022000004010100 2700010004155E01 8B00010004159000 C800220000005500 00000100
04155F1E 0021D00000B5C700
* Rsi: 00000000103BAB90: 0000000003EE4660 00000000010F8F40 00000000FFFFFFFE 00000000017BCA7A 00000000
A3FCBE00 00000000000000FB
* Rdi: 000000016BF6DE80: 000000016BF6CB00 0000000000000000 000000016BF6DE80 0000000000000000 00000000
00000004 000000016BF6DEA8
* R8: 0000000000000000:
* R9: 0000000000000000:
* R10: 0000000000000000:
* R11: 00000000103BB0D0: 0000000000000230 00000000003E0000 0000008E00000000 0000000200000201 0000008E
00000000 0000000000000000
* R12: 00000000FFFFFFFF: 0022000004010100 2700010004155E01 8B00010004159000 C800220000005500 00000100
04155F1E 0021D00000B5C700
* R13: 000000016BF6DE90: 000000016BF6DE80 0000000000000000 0000000000000004 000000016BF6DEA8 00000001
6BF6DEA8 000000016BF6DEB8
* R14: 00000000103BC0A0: 0072005F00780065 0065007300690061 00450020003A0032 0070006500630078 006E006F
00690074 0069006100720020
* R15: 0000000000000001:
* Rip: 000007FEFDF99E5D: C3000000C8C48148 9090909090909090 08245C8948909090 D98B4820EC834857 00002AE8
FA8B098B 2301840FC0854800
* *******************************************************************************
* -------------------------------------------------------------------------------
* Short Stack Dump
000007FEFDF99E5D Module(KERNELBASE+0000000000009E5D)
0000000001F6CF6E Module(sqlservr+0000000000F6CF6E)
0000000001F6F469 Module(sqlservr+0000000000F6F469)
0000000001F6F97A Module(sqlservr+0000000000F6F97A)
0000000001AF239B Module(sqlservr+0000000000AF239B)
0000000001820C52 Module(sqlservr+0000000000820C52)
00000000023064D9 Module(sqlservr+00000000013064D9)
0000000001A49531 Module(sqlservr+0000000000A49531)
00000000015E68CD Module(sqlservr+00000000005E68CD)
00000000015C81B8 Module(sqlservr+00000000005C81B8)
00000000015BFB84 Module(sqlservr+00000000005BFB84)
0000000001623193 Module(sqlservr+0000000000623193)
0000000001628B60 Module(sqlservr+0000000000628B60)
0000000001628BF6 Module(sqlservr+0000000000628BF6)
0000000001609202 Module(sqlservr+0000000000609202)
00000000015F08ED Module(sqlservr+00000000005F08ED)
0000000001609545 Module(sqlservr+0000000000609545)
0000000001661680 Module(sqlservr+0000000000661680)
00000000018574D8 Module(sqlservr+00000000008574D8)
00000000016092B1 Module(sqlservr+00000000006092B1)
0000000001661680 Module(sqlservr+0000000000661680)
00000000018574E9 Module(sqlservr+00000000008574E9)
00000000016092B1 Module(sqlservr+00000000006092B1)
0000000001661680 Module(sqlservr+0000000000661680)
00000000018574E9 Module(sqlservr+00000000008574E9)
00000000016092B1 Module(sqlservr+00000000006092B1)
0000000001661680 Module(sqlservr+0000000000661680)
00000000018574E9 Module(sqlservr+00000000008574E9)
00000000015F038D Module(sqlservr+00000000005F038D)
00000000016092B1 Module(sqlservr+00000000006092B1)
0000000001661680 Module(sqlservr+0000000000661680)
00000000015F038D Module(sqlservr+00000000005F038D)
0000000001527BDB Module(sqlservr+0000000000527BDB)
000000000160C522 Module(sqlservr+000000000060C522)
0000000001605BC2 Module(sqlservr+0000000000605BC2)
00000000016101F2 Module(sqlservr+00000000006101F2)
00000000015CE649 Module(sqlservr+00000000005CE649)
00000000015CC59C Module(sqlservr+00000000005CC59C)
00000000014C3165 Module(sqlservr+00000000004C3165)
00000000014C2FA2 Module(sqlservr+00000000004C2FA2)
000000000185C990 Module(sqlservr+000000000085C990)
000000000160F98E Module(sqlservr+000000000060F98E)
00000000015CE649 Module(sqlservr+00000000005CE649)
00000000015CC59C Module(sqlservr+00000000005CC59C)
00000000025A4F50 Module(sqlservr+00000000015A4F50)
00000000026484B7 Module(sqlservr+00000000016484B7)
00000000026492B9 Module(sqlservr+00000000016492B9)
00000000015CB332 Module(sqlservr+00000000005CB332)
00000000015CBDF4 Module(sqlservr+00000000005CBDF4)
00000000015C483E Module(sqlservr+00000000005C483E)
00000000015C4AD9 Module(sqlservr+00000000005C4AD9)
00000000015BB254 Module(sqlservr+00000000005BB254)
00000000014D4687 Module(sqlservr+00000000004D4687)
00000000017BE7B9 Module(sqlservr+00000000007BE7B9)
00000000017BE585 Module(sqlservr+00000000007BE585)
00000000017EADE8 Module(sqlservr+00000000007EADE8)
00000000735D37D7 Module(MSVCR80+00000000000037D7)
00000000735D3894 Module(MSVCR80+0000000000003894)
000000007729652D Module(kernel32+000000000001652D)
000000007798C521 Module(ntdll+000000000002C521)
* -------------------------------------------------------------------------------
16 фев 13, 16:49    [13936109]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server Stack Dump  [new]
pkarklin
Member

Откуда: Москва (Муром)
Сообщений: 74927
DBCC CHECKDB прогоняли?
16 фев 13, 16:52    [13936117]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server Stack Dump  [new]
Eduard Minasyan
Member

Откуда:
Сообщений: 119
Да, все в порядке.
16 фев 13, 17:44    [13936232]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server Stack Dump  [new]
Eduard Minasyan
Member

Откуда:
Сообщений: 119
Eduard Minasyan
Да, все в порядке.


Это на счет DBCC CHECKDB
16 фев 13, 18:47    [13936411]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server Stack Dump  [new]
pkarklin
Member

Откуда: Москва (Муром)
Сообщений: 74927
автор
Bios Version is _ASUS_ - 1072009... 4 Unknown CPU


Что-то не припомню я серверного железа с таким BIOS. На чем это всё крутится?
16 фев 13, 20:37    [13936724]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server Stack Dump  [new]
Eduard Minasyan
Member

Откуда:
Сообщений: 119
pkarklin
автор
Bios Version is _ASUS_ - 1072009... 4 Unknown CPU


Что-то не припомню я серверного железа с таким BIOS. На чем это всё крутится?


Стыдно сказать железо ни серверное, простой офисный i5, но месяцев 4-5 надо продержатся, тогда и новое железо будет и SQL Server 2012.
17 фев 13, 15:02    [13938589]     Ответить | Цитировать Сообщить модератору
 Re: SQL Server Stack Dump  [new]
Eduard Minasyan
Member

Откуда:
Сообщений: 119
Может ли ограничение Memory оказать положитеьное влияние?
17 фев 13, 16:27    [13938787]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить