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

Откуда:
Сообщений: 28
Симптоматика такая - периодически (от одного до нескольких раз в день )
самопроизвольно перегружается сервис SQL.
При этом в логах SQL имеется вот что

Date Source Message
2003-10-10 08:25:32.84 server Logging SQL Server messages in file 'C:\mssql2k\MSSQL\log\ERRORLOG'.
2003-10-10 08:25:32.84 server Server Process ID is 792.
2003-10-10 08:25:32.84 server All rights reserved.
2003-10-10 08:25:32.84 server Copyright (C) 1988-2002 Microsoft Corporation.
2003-10-10 08:25:32.84 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) ...
2003-10-10 08:25:32.90 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2003-10-10 08:25:33.60 server SQL Server configured for thread mode processing.
2003-10-10 08:25:33.62 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2003-10-10 08:25:44.25 server Attempting to initialize Distributed Transaction Coordinator.
2003-10-10 08:25:45.97 spid4 Starting up database 'master'.
2003-10-10 08:25:47.13 spid8 Starting up database 'Documents'.
2003-10-10 08:25:47.13 spid6 Starting up database 'model'.
2003-10-10 08:25:47.13 server Using 'SSNETLIB.DLL' version '8.0.766'.
2003-10-10 08:25:47.13 spid5 Starting up database 'msdb'.
2003-10-10 08:25:47.13 spid4 Server name is 'HURRICANE'.
2003-10-10 08:25:47.16 spid15 Starting up database 'salary'.
2003-10-10 08:25:47.16 spid14 Starting up database 'production'.
2003-10-10 08:25:47.16 spid13 Starting up database 'production_cat'.
2003-10-10 08:25:47.16 spid12 Starting up database 'plan'.
2003-10-10 08:25:47.16 spid11 Starting up database 'fondy'.
2003-10-10 08:25:47.16 spid10 Starting up database 'alpha'.
2003-10-10 08:25:47.61 spid11 Starting up database 'sprav'.
2003-10-10 08:25:47.88 spid6 Clearing tempdb database.
2003-10-10 08:25:48.34 spid5 Starting up database 'tbl_main_2001'.
2003-10-10 08:25:48.36 server SQL server listening on 127.0.0.1: 1433.
2003-10-10 08:25:48.36 server SQL server listening on 192.168.0.252: 1433.
2003-10-10 08:25:48.69 spid11 Starting up database 'tbl_main'.
2003-10-10 08:25:48.75 spid12 Starting up database 'Documents_cat'.
2003-10-10 08:25:48.94 server SQL Server is ready for client connections
2003-10-10 08:25:48.94 server SQL server listening on TCP, Shared Memory, Named Pipes.
2003-10-10 08:25:49.13 spid11 Starting up database 'Sklad'.
2003-10-10 08:25:49.85 spid6 Starting up database 'tempdb'.
2003-10-10 08:25:52.30 spid15 Analysis of database 'salary' (11) is 100% complete (approximately 0 more secon
2003-10-10 08:25:58.61 spid51 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure '
2003-10-10 08:26:53.38 spid56 Configuration option 'show advanced options' changed from 1 to 1. Run the RECON
2003-10-10 08:26:53.38 spid56 Error: 15457, Severity: 0, State: 1
2003-10-10 08:26:53.55 spid56 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure
2003-10-10 08:26:58.44 spid4 SQL global counter collection task is created.
2003-10-10 08:26:58.44 spid4 Recovery complete.
2003-10-10 08:26:58.78 spid58 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure
2003-10-10 08:27:09.38 spid56 Configuration option 'max server memory (MB)' changed from 1894 to 1826. Run th
2003-10-10 08:27:09.38 spid56 Error: 15457, Severity: 0, State: 1
2003-10-10 13:00:05.96 backup Database backed up: Database: master, creation date(time): 2003/10/10(08:25:45)
2003-10-10 13:00:12.04 backup Database differential changes backed up: Database: salary, creation date(time):
2003-10-10 13:00:14.05 backup Database differential changes backed up: Database: sprav, creation date(time):
2003-10-10 13:00:15.13 backup Database differential changes backed up: Database: Fondy, creation date(time):
2003-10-10 13:00:17.04 backup Database differential changes backed up: Database: documents, creation date(tim
2003-10-10 13:00:19.27 backup Database differential changes backed up: Database: msdb, creation date(time): 2
2003-10-10 13:00:20.16 backup Database differential changes backed up: Database: Plan, creation date(time): 2
2003-10-10 13:00:26.13 backup Database differential changes backed up: Database: Production, creation date(ti
2003-10-10 13:00:28.62 backup Database differential changes backed up: Database: tbl_main_2001, creation date
2003-10-10 14:00:02.25 spid102 Using 'dbghelp.dll' version '4.0.5'...
2003-10-10 14:00:03.69 spid102 SQL Server Assertion: File: <p:\sql\ntdbms\storeng\drs\include\record.inl>, lin
2003-10-10 14:00:03.69 spid102 Stack Signature for the dump is 0xE442D707
2003-10-10 14:00:03.71 spid102 Using 'dbghelp.dll' version '4.0.5'...
2003-10-10 14:00:03.71 spid102 Error: 3624, Severity: 20, State: 1.
2003-10-10 14:00:04.08 spid102 SQL Server Assertion: File: <umsio.cpp>, line=563 ...
2003-10-10 14:00:04.08 spid102 Stack Signature for the dump is 0x37E42ECC
2003-10-10 14:00:04.10 spid102 Using 'dbghelp.dll' version '4.0.5'...
2003-10-10 14:00:04.46 spid102 SQL Server Assertion: File: <umsio.cpp>, line=563 ...
2003-10-10 14:00:04.46 spid102 Stack Signature for the dump is 0x6FF399D0
2003-10-10 14:00:04.47 server Using 'dbghelp.dll' version '4.0.5'...
2003-10-10 14:00:11.52 server PSS NULL for assert - raising EXCEPTION_ILLEGAL_INSTRUCTION
2003-10-10 14:00:11.52 server SQL Server Assertion: File: <umsio.cpp>, line=563 ...
2003-10-10 14:00:11.52 server Stack Signature for the dump is 0xDF168956
2003-10-10 14:00:11.54 server SqlDumpExceptionHandler: Process 324 generated fatal exception c000001d EXCEPTI
2003-10-10 14:00:11.54 server Using 'dbghelp.dll' version '4.0.5'...
2003-10-10 14:00:18.33 server SQL Server is aborting. Fatal exception c000001d caught.
2003-10-10 14:00:18.33 server Stack Signature for the dump is 0x876BEB4A

Система - W2k server c 4-м сервиспаком , SQL версия 8.00.760 (SP3а)
Появилась данная ошибка несколько дней назад , до этого месяца три все работало без единого сбоя.
По сайту Микрософта полазил , в нескольких статьях нечто похожее описывалось, но были заверения , что после установки SP3a все пройдет.
Не прошло :-((.
Посоветуйте , где покопать еще.
Заранее спасибо , Роман
10 окт 03, 14:17    [372132]     Ответить | Цитировать Сообщить модератору
 Re: Прошу совета- периодически валится SQL-сервер  [new]
Сергей Тихонов
Member

Откуда: Киев
Сообщений: 787
Поищи по следующим темам:

1. PRB: Additional SQL Server Diagnostics Added to Detect Unreported I/O Problems
2. HOW TO: Use the SQLIOStress Utility to Stress a Disk Subsystem Such as SQL Server
10 окт 03, 14:53    [372203]     Ответить | Цитировать Сообщить модератору
Все форумы / Microsoft SQL Server Ответить