Enterprise Manager

Hello, My used-to-be-stable SQL server 2000 running on windows 2000 server
has started freezing whenever I make attempt to open the enterprise manager.
It does so at an interval of 1/2- days and the solution at this point is to
restart the machine.
This makes me to restart the machine at an interval of 1-2 days.
Can somebody fix me out.
Thasks
Hi
Make sure your server has SP3a applied to the SQL Install and that the
Windows 2000 is on the latest SP and hotfixes.
Check the SQL Event log for any errors, and also the NT event log.
Does SQL server freeze, or just EM, does the OS remain responsive?
What does Task Manager show during the "freeze"?
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"olefemmy" <olefemmy@.discussions.microsoft.com> wrote in message
news:F4C6FB7C-C82A-46E3-AFB8-4436867AEBF7@.microsoft.com...
> Hello, My used-to-be-stable SQL server 2000 running on windows 2000 server
> has started freezing whenever I make attempt to open the enterprise
manager.
> It does so at an interval of 1/2- days and the solution at this point is
to
> restart the machine.
> This makes me to restart the machine at an interval of 1-2 days.
> Can somebody fix me out.
> Thasks
|||This is a copy of the log messages:
DateSourceMessage
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
----...
004E43DDModule(sqlservr+000E43DD) (LogMgr::LogWriter(void *)+00000087)
004E3CEDModule(sqlservr+000E3CED) (lazywriter(void *)+000000FF)
004E506FModule(sqlservr+000E506F) (BPool::LazyWriter(void)+0000022E)
004EF270Module(sqlservr+000EF270) (ckptproc(void *)+000000FD)
004E55FFModule(sqlservr+000E55FF) (systemTaskThread(void *)+000001CD)
004E434DModule(sqlservr+000E434D) (lockMonitorThread(void *)+000000AA)
004E4B88Module(sqlservr+000E4B88) (lockMonitor(void)+000000B7)
004E3DF0Module(sqlservr+000E3DF0) (StartUp::InitDBMS(void *)+00000112)
004DF1ADModule(sqlservr+000DF1AD) (SignalProc(class ExecutionContext
*)+000000D7)
004E43DDModule(sqlservr+000E43DD) (LogMgr::LogWriter(void *)+00000087)
004E3CEDModule(sqlservr+000E3CED) (lazywriter(void *)+000000FF)
004E506FModule(sqlservr+000E506F) (BPool::LazyWriter(void)+0000022E)
004EF270Module(sqlservr+000EF270) (ckptproc(void *)+000000FD)
004E55FFModule(sqlservr+000E55FF) (systemTaskThread(void *)+000001CD)
004E434DModule(sqlservr+000E434D) (lockMonitorThread(void *)+000000AA)
004E4B88Module(sqlservr+000E4B88) (lockMonitor(void)+000000B7)
004E3DF0Module(sqlservr+000E3DF0) (StartUp::InitDBMS(void *)+00000112)
004DF1ADModule(sqlservr+000DF1AD) (SignalProc(class ExecutionContext
*)+000000D7)
004E43DDModule(sqlservr+000E43DD) (LogMgr::LogWriter(void *)+00000087)
004E3CEDModule(sqlservr+000E3CED) (lazywriter(void *)+000000FF)
004E506FModule(sqlservr+000E506F) (BPool::LazyWriter(void)+0000022E)
004EF270Module(sqlservr+000EF270) (ckptproc(void *)+000000FD)
004E55FFModule(sqlservr+000E55FF) (systemTaskThread(void *)+000001CD)
004E434DModule(sqlservr+000E434D) (lockMonitorThread(void *)+000000AA)
004E4B88Module(sqlservr+000E4B88) (lockMonitor(void)+000000B7)
004E3DF0Module(sqlservr+000E3DF0) (StartUp::InitDBMS(void *)+00000112)
004DF1ADModule(sqlservr+000DF1AD) (SignalProc(class ExecutionContext
*)+000000D7)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
00401B40Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned
long)+00000070)
00401C71Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned
long)+00000036)
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
0040129CModule(sqlservr+0000129C)
(ExecutionContext::WaitForSignal(unsigned long,unsign
006F006DModule(sqlservr+002F006D) (CXteSort::SetMemGrant(class
CPhaseMemoryGrantContext
006F006DModule(sqlservr+002F006D) (CXteSort::SetMemGrant(class
CPhaseMemoryGrantContext
006F006DModule(sqlservr+002F006D) (CXteSort::SetMemGrant(class
CPhaseMemoryGrantContext
02B06EF6Module(SSNETLIB+00006EF6)
02B06EF6Module(SSNETLIB+00006EF6)
02B06EF6Module(SSNETLIB+00006EF6)
2005-03-15 09:02:20.73 serverMicrosoft SQL Server 2000 - 8.00.194 (Intel
X86) ...
2005-03-15 09:02:20.76 serverLogging SQL Server messages in file
'd:\MSSQL\log\ERRORLOG'.
2005-03-15 09:02:20.76 serverServer Process ID is 1016.
2005-03-15 09:02:20.76 serverAll rights reserved.
2005-03-15 09:02:20.76 serverCopyright (C) 1988-2000 Microsoft Corporation.
2005-03-15 09:02:20.82 serverSQL Server is starting at priority class
'normal'(1 CPU detected).
2005-03-15 09:02:21.35 serverSQL Server configured for thread mode
processing.
2005-03-15 09:02:21.39 serverUsing dynamic lock allocation. [2500] Lock
Blocks, [5000] Lock Owner Blocks.
2005-03-15 09:02:21.51 serverAttempting to initialize Distributed
Transaction Coordinator.
2005-03-15 09:02:25.51 spid3Starting up database 'master'.
2005-03-15 09:02:25.87 spid5Starting up database 'model'.
2005-03-15 09:02:25.87 serverUsing 'SSNETLIB.DLL' version '8.0.194'.
2005-03-15 09:02:25.92 spid3Server name is 'IPNXTWO'.
2005-03-15 09:02:25.95 spid11Starting up database 'RodopiManagement'.
2005-03-15 09:02:25.95 spid10Starting up database 'Northwind'.
2005-03-15 09:02:25.95 spid9Starting up database 'pubs'.
2005-03-15 09:02:25.95 spid8Starting up database 'msdb'.
2005-03-15 09:02:26.07 spid5Clearing tempdb database.
2005-03-15 09:02:26.25 spid9Starting up database 'AbacPay'.
2005-03-15 09:02:26.25 spid11Starting up database 'AbacBill'.
2005-03-15 09:02:26.28 spid8Recovery is checkpointing database 'msdb' (4)
2005-03-15 09:02:26.28 spid10Starting up database 'iWireless'.
2005-03-15 09:02:26.96 spid5Starting up database 'tempdb'.
2005-03-15 09:02:27.59 spid3Recovery complete.
2005-03-15 09:02:32.31 serverSQL Server is ready for client connections
2005-03-15 09:02:32.31 serverSQL server listening on 62.173.32.84:1433,
127.0.0.1:1433.
2005-03-15 09:02:32.31 serverSQL server listening on TCP, Shared Memory,
Named Pipes.
2005-03-15 09:02:34.38 spid51Using 'xpsqlbot.dll' version '2000.80.194' to
execute extended stored procedure
2005-03-15 09:05:20.25 spid59Using 'xpstar.dll' version '2000.80.194' to
execute extended stored procedure '
2005-03-16 00:00:11.09 backupLog backed up: Database: AbacBill, creation
date(time): 2004/12/13(08:30:08), f
2005-03-16 00:00:11.46 backupLog backed up: Database: AbacPay, creation
date(time): 2004/12/13(08:32:12), fi
2005-03-16 00:18:11.76 serverUsing 'sqlimage.dll' version '4.0.5'...
2005-03-16 00:18:11.78 serverprocess_commands: Process 2280 generated
fatal exception c0000005 EXCEPTION_ACC
2005-03-16 00:18:15.51 serverprocess_commands: Process 2048 generated
fatal exception c0000005 EXCEPTION_ACC
2005-03-16 00:18:15.51 serverUsing 'sqlimage.dll' version '4.0.5'...
2005-03-16 04:38:31.48 serverprocess_commands: Process 1844 generated
fatal exception c0000005 EXCEPTION_ACC
2005-03-16 04:38:31.48 serverUsing 'sqlimage.dll' version '4.0.5'...
2005-03-17 09:04:29.14 serverSQL Server terminating because of system
shutdown.
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
4107149DModule(UMS+0000149D) (UmsThreadScheduler::Switch(class
UmsUserContext *,class U
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
410717FFModule(UMS+000017FF) (UmsScheduler::Suspend(unsigned
long,int)+0000007E)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
4107173FModule(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
41071918 Module(UMS+00001918)(UmsEvent::Wait(unsigned
long,int,int)+00000095)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
410735D0Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue
*)+00000264)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
4107382CModule(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
42B68ABAModule(SQLSORT+00088ABA)
42B68ABAModule(SQLSORT+00088ABA)
42B68ABAModule(SQLSORT+00088ABA)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
7C57B388Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
77F82870Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
78008454 Module(MSVCRT+00008454)(_endthread+000000C1)
Short Stack Dump
Dump thread - spid = 3, PSS = 0x42c04090, EC = 0x42c043a0
Stack Dump being sent to d:\MSSQL\log\SQL00044.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 03/16/05 04:38:32 spid 3
*
* StackDump (all)
*
*
*
* Edi: 0000030C:
* Esi: 77F82865: 0000EAB8 24548D00 C22ECD04 E9B8000C 8D000000
CD042454
* Eax: 00000000:
* Ebx: 00000000:
* Ecx: 012EBE88: 00000000 00000000 00000000 00000000 00000000
00000000
* Edx: 00000000:
* Eip: 77F82870: B8000CC2 000000E9 0424548D 14C22ECD 001CB800
548D0000
* Ebp: 0287FE34: 0287FE50 4107149D 0000030C FFFFFFFF 00000001
00BC63C0
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 0287FE10: 7C599FE4 0000030C 00000001 00000000 42C043A0
42C04090
* SegSs: 00000023:
************************************************** *****************************
Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
(_endthread+000000C1)
Module(UMS+0000382C) (ThreadStartRoutine(void *)+000000BC)
Module(UMS+000035D0) (ProcessWorkRequests(class UmsWorkQueue *)+00000264)
Module(sqlservr+000E43DD) (LogMgr::LogWriter(void *)+00000087)
Module(sqlservr+00001B40) (ResQueueBase::Dequeue(unsigned long)+00000070)
Module(sqlservr+00001C71) (ResQueueBase::Wait(unsigned long)+00000036)
Module(sqlservr+0000129C) (ExecutionContext::WaitForSignal(unsigned
long,unsigned int,enum ExecutionContext::WAIT_IO_SERVICE,enum
ExecutionContext::RETURN_IO_COMPLETE)+000001B5)
(UmsEvent::Wait(unsigned long,int,int)+00000095)
Module(UMS+000017FF) (UmsScheduler::Suspend(unsigned long,int)+0000007E)
Module(UMS+0000173F) (UmsScheduler::IdleLoop(void)+0000011F)
Module(UMS+0000149D) (UmsThreadScheduler::Switch(class UmsUserContext
*,class UmsUserContext *)+00000058)
Module(ntdll+00002870) (ZwWaitForSingleObject+0000000B)
Short Stack Dump
Dump thread - spid = 2, PSS = 0x42c06090, EC = 0x42c063a0
Stack Dump being sent to d:\MSSQL\log\SQL00044.dmp
************************************************** *****************************
*
* BEGIN STACK DUMP:
* 03/16/05 04:38:32 spid 2
*
* StackDump (all)
*
*
*
* Edi: 00000304:
* Esi: 77F82865: 0000EAB8 24548D00 C22ECD04 E9B8000C 8D000000
CD042454
* Eax: 000B9AD8: 00000000 42C06090 42C063A0 00000000 00030002
00080100
* Ebx: 00000000:
* Ecx: 00000000:
* Edx: 00000000:
* Eip: 77F82870: B8000CC2 000000E9 0424548D 14C22ECD 001CB800
548D0000
* Ebp: 027FFDC0: 027FFDDC 4107149D 00000304 FFFFFFFF 00000001
00BC63C0
* SegCs: 0000001B:
* EFlags: 00000246:
* Esp: 027FFD9C: 7C599FE4 00000304 00000001 00000000 00A0AD48
41071883
* SegSs: 00000023:
************************************************** *****************************
Module(KERNEL32+0000B388) (lstrcmpiW+000000B7)
"olefemmy" wrote:

> Hello, My used-to-be-stable SQL server 2000 running on windows 2000 server
> has started freezing whenever I make attempt to open the enterprise manager.
> It does so at an interval of 1/2- days and the solution at this point is to
> restart the machine.
> This makes me to restart the machine at an interval of 1-2 days.
> Can somebody fix me out.
> Thasks
|||Any error/warnings in the Event Logs?
Regards,
Hank Arnold
"olefemmy" <olefemmy@.discussions.microsoft.com> wrote in message
news:F4C6FB7C-C82A-46E3-AFB8-4436867AEBF7@.microsoft.com...
> Hello, My used-to-be-stable SQL server 2000 running on windows 2000 server
> has started freezing whenever I make attempt to open the enterprise
> manager.
> It does so at an interval of 1/2- days and the solution at this point is
> to
> restart the machine.
> This makes me to restart the machine at an interval of 1-2 days.
> Can somebody fix me out.
> Thasks
|||There's no error in the log apart from socket info error (which I find is due
to the absence of active directory installed) and insufficient memory. But
the utilization on the 2G memory box is not even noticeable most times. Apart
from the 2, no more message in the log.
"Hank Arnold" wrote:

> Any error/warnings in the Event Logs?
> --
> Regards,
> Hank Arnold
> "olefemmy" <olefemmy@.discussions.microsoft.com> wrote in message
> news:F4C6FB7C-C82A-46E3-AFB8-4436867AEBF7@.microsoft.com...
>
>