갑자기 정전작업 후 서버 킨후에
데이터베이스가 느려ㅤㅈㅔㅆ네요...
pda에서 위치정보를 누르고 엔터치면 20~30후 수량 입력하는 칸으로 넘어갑니다..
근데 위치정보를 잘못입력하면 보통 5초정도 후에 잘못되었다고 나오고요..
전에는 위치정보 입력하고 2-3후에 다음라인으로 넘어갔는데...
db가 꼬인건지 어떻게 해야 할까요...
재부팅할때마다 똑같은 log 가 쌓이는 어떻게 해결해야 할지 모르겠습니다... 확인좀 부탁드릅니다....
이것때문에 죽겠네요... 도와주세요.ㅠㅠ
원격이나 전화통화도 가능합니다... 정말 죽겠습니다...
도와주실분 메일 주세요...
hazia@naver.com
2011-12-26 14:29:53 - ? [393] Waiting for SQL Server to recover databases...
2011-12-26 14:29:58 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3084
2011-12-26 14:29:58 - ? [101] SQL Server JAHNAP01 version 8.00.194 (0 connection limit)
2011-12-26 14:29:58 - ? [102] SQL Server ODBC driver version 3.86.3959
2011-12-26 14:29:58 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local)
2011-12-26 14:29:58 - ? [310] 4 processor(s) and 2048 MB RAM detected
2011-12-26 14:29:58 - ? [339] Local computer is JAHNAP01 running Windows NT 5.2 (3790) Service Pack 2
2011-12-26 14:29:58 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2011-12-26 14:29:58 - + [260] Unable to start mail session (reason: No mail profile defined)
2011-12-26 14:29:58 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2011-12-28 10:25:43 - ? [130] SQLSERVERAGENT stopping because of Windows shutdown...
2011-12-28 10:25:44 - ! [298] SQLServer Error: 1115, Cannot generate SSPI context [SQLSTATE HY000]
2011-12-28 10:25:44 - ! [382] Logon to server '(local)' failed (SaveAllSchedules)
2011-12-28 10:25:46 - ? [098] SQLServerAgent terminated (normally)
2011-12-28 10:27:38 - ? [393] Waiting for SQL Server to recover databases...
2011-12-28 10:27:44 - ? [100] Microsoft SQLServerAgent version 8.00.194 (x86 unicode retail build) : Process ID 3396
2011-12-28 10:27:44 - ? [101] SQL Server JAHNAP01 version 8.00.194 (0 connection limit)
2011-12-28 10:27:44 - ? [102] SQL Server ODBC driver version 3.86.3959
2011-12-28 10:27:44 - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local)
2011-12-28 10:27:44 - ? [310] 4 processor(s) and 2048 MB RAM detected
2011-12-28 10:27:44 - ? [339] Local computer is JAHNAP01 running Windows NT 5.2 (3790) Service Pack 2
2011-12-28 10:27:44 - ? [129] SQLSERVERAGENT starting under Windows NT service control
2011-12-28 10:27:44 - + [260] Unable to start mail session (reason: No mail profile defined)
2011-12-28 10:27:44 - + [396] An idle CPU condition has not been defined - OnIdle job schedules will have no effect
2011-12-28 10:27:34.45 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2011-12-28 10:27:34.45 server Copyright (C) 1988-2000 Microsoft Corporation.
2011-12-28 10:27:34.45 server All rights reserved.
2011-12-28 10:27:34.45 server Server Process ID is 1984.
2011-12-28 10:27:34.45 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2011-12-28 10:27:34.46 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2011-12-28 10:27:34.65 server SQL Server configured for thread mode processing.
2011-12-28 10:27:34.65 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2011-12-28 10:27:34.73 server Attempting to initialize Distributed Transaction Coordinator.
2011-12-28 10:27:35.98 spid4 Starting up database 'master'.
2011-12-28 10:27:36.79 spid4 Server name is 'JAHNAP01'.
2011-12-28 10:27:36.79 spid5 Starting up database 'msdb'.
2011-12-28 10:27:36.81 spid6 Starting up database 'pubs'.
2011-12-28 10:27:36.81 spid7 Starting up database 'Northwind'.
2011-12-28 10:27:36.84 spid8 Starting up database 'labelprintdb'.
2011-12-28 10:27:36.84 server Using 'SSNETLIB.DLL' version '8.0.311'.
2011-12-28 10:27:36.84 spid9 Starting up database 'model'.
2011-12-28 10:27:36.84 spid10 Starting up database 'AT_SAP'.
2011-12-28 10:27:36.90 server SQL server listening on 10.162.227.214: 1433.
2011-12-28 10:27:36.90 server SQL server listening on 127.0.0.1: 1433.
2011-12-28 10:27:37.03 server SQL server listening on TCP, Shared Memory, Named Pipes.
2011-12-28 10:27:37.11 spid9 Clearing tempdb database.
2011-12-28 10:27:38.32 server SQL Server is ready for client connections
2011-12-28 10:27:39.67 spid9 Starting up database 'tempdb'.
2011-12-28 10:27:43.64 spid10 Analysis of database 'AT_SAP' (8) is 100% complete (approximately 0 more seconds)
2011-12-28 10:27:43.74 spid4 Recovery complete.
2011-12-28 10:27:44.57 spid51 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2011-12-28 10:27:44.70 spid52 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_sqlagent_monitor'.
2011-12-26 14:29:48.25 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)
2011-12-26 14:29:48.25 server Copyright (C) 1988-2000 Microsoft Corporation.
2011-12-26 14:29:48.25 server All rights reserved.
2011-12-26 14:29:48.25 server Server Process ID is 1960.
2011-12-26 14:29:48.25 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2011-12-26 14:29:48.29 server SQL Server is starting at priority class 'normal'(4 CPUs detected).
2011-12-26 14:29:48.48 server SQL Server configured for thread mode processing.
2011-12-26 14:29:48.48 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2011-12-26 14:29:48.54 server Attempting to initialize Distributed Transaction Coordinator.
2011-12-26 14:29:49.73 spid4 Starting up database 'master'.
2011-12-26 14:29:50.23 spid5 Starting up database 'model'.
2011-12-26 14:29:50.23 server Using 'SSNETLIB.DLL' version '8.0.311'.
2011-12-26 14:29:50.23 spid4 Server name is 'JAHNAP01'.
2011-12-26 14:29:50.23 spid8 Starting up database 'msdb'.
2011-12-26 14:29:50.23 spid9 Starting up database 'pubs'.
2011-12-26 14:29:50.24 spid11 Starting up database 'labelprintdb'.
2011-12-26 14:29:50.24 spid10 Starting up database 'Northwind'.
2011-12-26 14:29:50.24 spid12 Starting up database 'AT_SAP'.
2011-12-26 14:29:50.24 server SQL server listening on 10.162.227.214: 1433.
2011-12-26 14:29:50.24 server SQL server listening on 127.0.0.1: 1433.
2011-12-26 14:29:50.31 server SQL server listening on TCP, Shared Memory, Named Pipes.
2011-12-26 14:29:50.46 spid5 Clearing tempdb database.
2011-12-26 14:29:51.70 server SQL Server is ready for client connections
2011-12-26 14:29:52.49 spid5 Starting up database 'tempdb'.
2011-12-26 14:29:57.67 spid12 Analysis of database 'AT_SAP' (8) is 100% complete (approximately 0 more seconds)
2011-12-26 14:29:57.85 spid4 Recovery complete.
2011-12-26 14:29:58.49 spid51 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2011-12-26 14:29:58.84 spid51 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'xp_sqlagent_monitor'.
2011-12-27 16:15:16.35 spid54 Error: 15457, Severity: 0, State: 1
2011-12-27 16:15:16.35 spid54 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install..
2011-12-27 16:15:16.44 spid54 Using 'xplog70.dll' version '2000.80.194' to execute extended stored procedure 'xp_msver'.
2011-12-28 10:25:43.05 server SQL Server terminating because of system shutdown.
2011-12-28 10:25:43.05 server LogEvent: Failed to report the current event. Operating system error = 31(error not found).
2011-12-28 10:25:49.28 spid4 SQL Server is terminating due to 'stop' request from Service Control Manager.
|