|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
SQLServer gets busy, users timed out, what does this Error Log mean ?(this is related to the post : http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) Our custom application run on SQL Server 2000. On random period of time (but quite often lately) users get timed out, and when we checked the server resources utilization, the utilization is so hight, so that only 80 MB out of 1 GB memory available. But we do not know what makes the server very busy. Below is th Error LOG, what does it mean ? (I am developer and don't now what the log says) Thank you for your help, xtanto The Error Log : 2006-08-01 07:12:31.17 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: ) 2006-08-01 07:12:31.17 server Copyright (C) 1988-2002 Microsoft Corporation. 2006-08-01 07:12:31.17 server All rights reserved. 2006-08-01 07:12:31.17 server Server Process ID is 1336. 2006-08-01 07:12:31.17 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. 2006-08-01 07:12:31.20 server SQL Server is starting at priority class 'normal'(2 CPUs detected). 2006-08-01 07:12:31.49 server SQL Server configured for thread mode processing. 2006-08-01 07:12:31.49 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks. 2006-08-01 07:12:31.64 server Attempting to initialize Distributed Transaction Coordinator. 2006-08-01 07:12:33.46 spid3 Starting up database 'master'. 2006-08-01 07:12:36.76 spid3 0 transactions rolled back in database 'master' (1). 2006-08-01 07:12:36.76 spid3 Recovery is checkpointing database 'master' (1) 2006-08-01 07:12:38.40 spid5 Starting up database 'model'. 2006-08-01 07:12:38.40 server Using 'SSNETLIB.DLL' version '8.0.766'. 2006-08-01 07:12:38.45 server SQL server listening on 192.168.100.10: 1433. 2006-08-01 07:12:38.45 server SQL server listening on 127.0.0.1: 1433. 2006-08-01 07:12:38.45 spid3 Server name is 'SQL-SERVER'. 2006-08-01 07:12:38.46 spid8 Starting up database 'msdb'. 2006-08-01 07:12:38.46 spid9 Starting up database 'pubs'. 2006-08-01 07:12:38.46 spid10 Starting up database 'Northwind'. 2006-08-01 07:12:38.46 spid11 Starting up database 'coba'. 2006-08-01 07:12:38.48 spid12 Starting up database 'admis'. 2006-08-01 07:12:38.50 server SQL server listening on TCP, Shared Memory, Named Pipes. 2006-08-01 07:12:38.53 spid13 Starting up database 'admisgl'. 2006-08-01 07:12:38.53 spid14 Starting up database 'sskolap'. 2006-08-01 07:12:38.53 spid15 Starting up database 'JANUARI'. 2006-08-01 07:12:38.57 server SQL Server is ready for client connections 2006-08-01 07:12:39.48 spid14 Analysis of database 'sskolap' (10) is 100% complete (approximately 0 more seconds) 2006-08-01 07:12:40.48 spid5 Clearing tempdb database. 2006-08-01 07:12:52.15 spid5 Starting up database 'tempdb'. 2006-08-01 07:20:59.17 spid3 Recovery complete. 2006-08-01 07:20:59.17 spid3 SQL global counter collection task is created. 2006-08-01 07:21:03.40 spid51 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'. 2006-08-01 12:00:11.53 spid58 Using 'xpstar.dll' version '2000.80.760' to execute extended stored procedure 'xp_instance_regread'. 2006-08-01 12:07:21.22 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first LSN: 14511:1799:1, last LSN: 14511:1887:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\20060221'}). 2006-08-01 12:13:35.92 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first LSN: 14511:1934:1, last LSN: 14511:2001:1, number of dump devices: 1, device information: (FILE=6, TYPE=DISK: {'C:\softpack\admis\backup\20060220'}). 2006-08-01 14:47:34.65 spid61 Error: 15457, Severity: 0, State: 1 2006-08-01 14:47:34.65 spid61 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. 2006-08-01 14:47:34.87 spid61 Using 'xplog70.dll' version '2000.80.760' to execute extended stored procedure 'xp_msver'. 2006-08-01 17:00:02.49 spid53 BackupDiskFile::CreateMedia: Backup device 'C:\softpack\admis\backup\' failed to create. Operating system error = 3(error not found). 2006-08-01 17:00:02.49 backup BACKUP failed to complete the command BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, NOFORMAT 2006-08-01 17:18:17.30 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 52607, first LSN: 14527:1903:1, last LSN: 14527:1909:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\20070801'}). 2006-08-02 09:21:21.90 spid65 Error: 15457, Severity: 0, State: 1 2006-08-02 09:21:21.90 spid65 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. 2006-08-02 09:49:46.44 spid54 Error: 15457, Severity: 0, State: 1 2006-08-02 09:49:46.44 spid54 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. 2006-08-02 12:07:15.34 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 52656, first LSN: 14538:1968:1, last LSN: 14538:2503:1, number of dump devices: 1, device information: (FILE=2, TYPE=DISK: {'C:\softpack\admis\backup\20060221'}). 2006-08-02 12:13:31.92 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 52640, first LSN: 14539:200:1, last LSN: 14539:384:1, number of dump devices: 1, device information: (FILE=7, TYPE=DISK: {'C:\softpack\admis\backup\20060220'}). 2006-08-02 14:52:52.03 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 51155, first LSN: 14549:731:1, last LSN: 14549:946:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\suhe_live'}). 2006-08-02 15:18:27.55 backup Database backed up: Database: JANUARI, creation date(time): 2006/07/20(18:27:34), pages dumped: 45859, first LSN: 13616:1547:1, last LSN: 13616:1552:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\suhe_jan'}). 2006-08-02 15:27:32.93 backup Database backed up: Database: coba, creation date(time): 2006/04/24(14:54:07), pages dumped: 23195, first LSN: 6836:42:1, last LSN: 6836:46:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\suhe_coba'}). 2006-08-02 16:20:39.29 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 51132, first LSN: 14555:21914:1, last LSN: 14555:22024:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\20060802'}). 2006-08-02 17:00:02.58 spid53 BackupDiskFile::CreateMedia: Backup device 'C:\softpack\admis\backup\' failed to create. Operating system error = 3(error not found). 2006-08-02 17:00:02.59 backup BACKUP failed to complete the command BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, NOFORMAT 2006-08-03 10:50:03.50 spid69 Error: 15457, Severity: 0, State: 1 2006-08-03 10:50:03.50 spid69 Configuration option 'show advanced options' changed from 1 to 1. Run the RECONFIGURE statement to install.. 2006-08-03 17:00:02.47 spid56 BackupDiskFile::CreateMedia: Backup device 'C:\softpack\admis\backup\' failed to create. Operating system error = 3(error not found). 2006-08-03 17:00:02.49 backup BACKUP failed to complete the command BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, NOFORMAT 2006-08-03 17:08:49.78 backup Database backed up: Database: admis, creation date(time): 2005/12/06(14:20:58), pages dumped: 51452, first LSN: 14568:1152:1, last LSN: 14568:1173:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'C:\softpack\admis\backup\20070803'}). Please check do you have sufficient HDD Space in C:
BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system krisl***@gmail.com wrote:> error = 3(error not found). Show quote > Hi Sql Gurus, > (this is related to the post : > http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) > > Our custom application run on SQL Server 2000. On random period of time > > (but quite often lately) users get timed out, and when we checked the > server resources utilization, the utilization is so hight, so that only > > 80 MB out of 1 GB memory available. But we do not know what makes the > server very busy. > > Below is th Error LOG, what does it mean ? > (I am developer and don't now what the log says) > > Thank you for your help, > xtanto > > The Error Log : > > 2006-08-01 07:12:31.17 server Microsoft SQL Server 2000 - 8.00.760 > (Intel X86) > Dec 17 2002 14:22:05 > Copyright (c) 1988-2003 Microsoft Corporation > Standard Edition on Windows NT 5.2 (Build 3790: ) > > 2006-08-01 07:12:31.17 server Copyright (C) 1988-2002 Microsoft > Corporation. > 2006-08-01 07:12:31.17 server All rights reserved. > 2006-08-01 07:12:31.17 server Server Process ID is 1336. > 2006-08-01 07:12:31.17 server Logging SQL Server messages in file > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. > 2006-08-01 07:12:31.20 server SQL Server is starting at priority > class 'normal'(2 CPUs detected). > 2006-08-01 07:12:31.49 server SQL Server configured for thread mode > processing. > 2006-08-01 07:12:31.49 server Using dynamic lock allocation. [2500] > Lock Blocks, [5000] Lock Owner Blocks. > 2006-08-01 07:12:31.64 server Attempting to initialize Distributed > Transaction Coordinator. > 2006-08-01 07:12:33.46 spid3 Starting up database 'master'. > 2006-08-01 07:12:36.76 spid3 0 transactions rolled back in database > 'master' (1). > 2006-08-01 07:12:36.76 spid3 Recovery is checkpointing database > 'master' (1) > 2006-08-01 07:12:38.40 spid5 Starting up database 'model'. > 2006-08-01 07:12:38.40 server Using 'SSNETLIB.DLL' version > '8.0.766'. > 2006-08-01 07:12:38.45 server SQL server listening on > 192.168.100.10: 1433. > 2006-08-01 07:12:38.45 server SQL server listening on 127.0.0.1: > 1433. > 2006-08-01 07:12:38.45 spid3 Server name is 'SQL-SERVER'. > 2006-08-01 07:12:38.46 spid8 Starting up database 'msdb'. > 2006-08-01 07:12:38.46 spid9 Starting up database 'pubs'. > 2006-08-01 07:12:38.46 spid10 Starting up database 'Northwind'. > 2006-08-01 07:12:38.46 spid11 Starting up database 'coba'. > 2006-08-01 07:12:38.48 spid12 Starting up database 'admis'. > 2006-08-01 07:12:38.50 server SQL server listening on TCP, Shared > Memory, Named Pipes. > 2006-08-01 07:12:38.53 spid13 Starting up database 'admisgl'. > 2006-08-01 07:12:38.53 spid14 Starting up database 'sskolap'. > 2006-08-01 07:12:38.53 spid15 Starting up database 'JANUARI'. > 2006-08-01 07:12:38.57 server SQL Server is ready for client > connections > 2006-08-01 07:12:39.48 spid14 Analysis of database 'sskolap' (10) is > 100% complete (approximately 0 more seconds) > 2006-08-01 07:12:40.48 spid5 Clearing tempdb database. > 2006-08-01 07:12:52.15 spid5 Starting up database 'tempdb'. > 2006-08-01 07:20:59.17 spid3 Recovery complete. > 2006-08-01 07:20:59.17 spid3 SQL global counter collection task is > created. > 2006-08-01 07:21:03.40 spid51 Using 'xpsqlbot.dll' version > '2000.80.194' to execute extended stored procedure 'xp_qv'. > 2006-08-01 12:00:11.53 spid58 Using 'xpstar.dll' version > '2000.80.760' to execute extended stored procedure > 'xp_instance_regread'. > 2006-08-01 12:07:21.22 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > LSN: 14511:1799:1, last LSN: 14511:1887:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20060221'}). > 2006-08-01 12:13:35.92 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > LSN: 14511:1934:1, last LSN: 14511:2001:1, number of dump devices: 1, > device information: (FILE=6, TYPE=DISK: > {'C:\softpack\admis\backup\20060220'}). > 2006-08-01 14:47:34.65 spid61 Error: 15457, Severity: 0, State: 1 > 2006-08-01 14:47:34.65 spid61 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-01 14:47:34.87 spid61 Using 'xplog70.dll' version > '2000.80.760' to execute extended stored procedure 'xp_msver'. > 2006-08-01 17:00:02.49 spid53 BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system > error = 3(error not found). > 2006-08-01 17:00:02.49 backup BACKUP failed to complete the command > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > NOFORMAT > 2006-08-01 17:18:17.30 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52607, first > LSN: 14527:1903:1, last LSN: 14527:1909:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20070801'}). > 2006-08-02 09:21:21.90 spid65 Error: 15457, Severity: 0, State: 1 > 2006-08-02 09:21:21.90 spid65 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-02 09:49:46.44 spid54 Error: 15457, Severity: 0, State: 1 > 2006-08-02 09:49:46.44 spid54 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-02 12:07:15.34 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52656, first > LSN: 14538:1968:1, last LSN: 14538:2503:1, number of dump devices: 1, > device information: (FILE=2, TYPE=DISK: > {'C:\softpack\admis\backup\20060221'}). > 2006-08-02 12:13:31.92 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52640, first > LSN: 14539:200:1, last LSN: 14539:384:1, number of dump devices: 1, > device information: (FILE=7, TYPE=DISK: > {'C:\softpack\admis\backup\20060220'}). > 2006-08-02 14:52:52.03 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 51155, first > LSN: 14549:731:1, last LSN: 14549:946:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\suhe_live'}). > 2006-08-02 15:18:27.55 backup Database backed up: Database: JANUARI, > creation date(time): 2006/07/20(18:27:34), pages dumped: 45859, first > LSN: 13616:1547:1, last LSN: 13616:1552:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\suhe_jan'}). > 2006-08-02 15:27:32.93 backup Database backed up: Database: coba, > creation date(time): 2006/04/24(14:54:07), pages dumped: 23195, first > LSN: 6836:42:1, last LSN: 6836:46:1, number of dump devices: 1, device > information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\suhe_coba'}). > 2006-08-02 16:20:39.29 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 51132, first > LSN: 14555:21914:1, last LSN: 14555:22024:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20060802'}). > 2006-08-02 17:00:02.58 spid53 BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system > error = 3(error not found). > 2006-08-02 17:00:02.59 backup BACKUP failed to complete the command > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > NOFORMAT > 2006-08-03 10:50:03.50 spid69 Error: 15457, Severity: 0, State: 1 > 2006-08-03 10:50:03.50 spid69 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-03 17:00:02.47 spid56 BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system > error = 3(error not found). > 2006-08-03 17:00:02.49 backup BACKUP failed to complete the command > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > NOFORMAT > 2006-08-03 17:08:49.78 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 51452, first > LSN: 14568:1152:1, last LSN: 14568:1173:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20070803'}). Hi,
run the client side trace and examine the slow performing querries. Show quote "masri***@gmail.com" wrote: > > Please check do you have sufficient HDD Space in C: > > BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > > krisl***@gmail.com wrote: > > Hi Sql Gurus, > > (this is related to the post : > > http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) > > > > Our custom application run on SQL Server 2000. On random period of time > > > > (but quite often lately) users get timed out, and when we checked the > > server resources utilization, the utilization is so hight, so that only > > > > 80 MB out of 1 GB memory available. But we do not know what makes the > > server very busy. > > > > Below is th Error LOG, what does it mean ? > > (I am developer and don't now what the log says) > > > > Thank you for your help, > > xtanto > > > > The Error Log : > > > > 2006-08-01 07:12:31.17 server Microsoft SQL Server 2000 - 8.00.760 > > (Intel X86) > > Dec 17 2002 14:22:05 > > Copyright (c) 1988-2003 Microsoft Corporation > > Standard Edition on Windows NT 5.2 (Build 3790: ) > > > > 2006-08-01 07:12:31.17 server Copyright (C) 1988-2002 Microsoft > > Corporation. > > 2006-08-01 07:12:31.17 server All rights reserved. > > 2006-08-01 07:12:31.17 server Server Process ID is 1336. > > 2006-08-01 07:12:31.17 server Logging SQL Server messages in file > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. > > 2006-08-01 07:12:31.20 server SQL Server is starting at priority > > class 'normal'(2 CPUs detected). > > 2006-08-01 07:12:31.49 server SQL Server configured for thread mode > > processing. > > 2006-08-01 07:12:31.49 server Using dynamic lock allocation. [2500] > > Lock Blocks, [5000] Lock Owner Blocks. > > 2006-08-01 07:12:31.64 server Attempting to initialize Distributed > > Transaction Coordinator. > > 2006-08-01 07:12:33.46 spid3 Starting up database 'master'. > > 2006-08-01 07:12:36.76 spid3 0 transactions rolled back in database > > 'master' (1). > > 2006-08-01 07:12:36.76 spid3 Recovery is checkpointing database > > 'master' (1) > > 2006-08-01 07:12:38.40 spid5 Starting up database 'model'. > > 2006-08-01 07:12:38.40 server Using 'SSNETLIB.DLL' version > > '8.0.766'. > > 2006-08-01 07:12:38.45 server SQL server listening on > > 192.168.100.10: 1433. > > 2006-08-01 07:12:38.45 server SQL server listening on 127.0.0.1: > > 1433. > > 2006-08-01 07:12:38.45 spid3 Server name is 'SQL-SERVER'. > > 2006-08-01 07:12:38.46 spid8 Starting up database 'msdb'. > > 2006-08-01 07:12:38.46 spid9 Starting up database 'pubs'. > > 2006-08-01 07:12:38.46 spid10 Starting up database 'Northwind'. > > 2006-08-01 07:12:38.46 spid11 Starting up database 'coba'. > > 2006-08-01 07:12:38.48 spid12 Starting up database 'admis'. > > 2006-08-01 07:12:38.50 server SQL server listening on TCP, Shared > > Memory, Named Pipes. > > 2006-08-01 07:12:38.53 spid13 Starting up database 'admisgl'. > > 2006-08-01 07:12:38.53 spid14 Starting up database 'sskolap'. > > 2006-08-01 07:12:38.53 spid15 Starting up database 'JANUARI'. > > 2006-08-01 07:12:38.57 server SQL Server is ready for client > > connections > > 2006-08-01 07:12:39.48 spid14 Analysis of database 'sskolap' (10) is > > 100% complete (approximately 0 more seconds) > > 2006-08-01 07:12:40.48 spid5 Clearing tempdb database. > > 2006-08-01 07:12:52.15 spid5 Starting up database 'tempdb'. > > 2006-08-01 07:20:59.17 spid3 Recovery complete. > > 2006-08-01 07:20:59.17 spid3 SQL global counter collection task is > > created. > > 2006-08-01 07:21:03.40 spid51 Using 'xpsqlbot.dll' version > > '2000.80.194' to execute extended stored procedure 'xp_qv'. > > 2006-08-01 12:00:11.53 spid58 Using 'xpstar.dll' version > > '2000.80.760' to execute extended stored procedure > > 'xp_instance_regread'. > > 2006-08-01 12:07:21.22 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > > LSN: 14511:1799:1, last LSN: 14511:1887:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20060221'}). > > 2006-08-01 12:13:35.92 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > > LSN: 14511:1934:1, last LSN: 14511:2001:1, number of dump devices: 1, > > device information: (FILE=6, TYPE=DISK: > > {'C:\softpack\admis\backup\20060220'}). > > 2006-08-01 14:47:34.65 spid61 Error: 15457, Severity: 0, State: 1 > > 2006-08-01 14:47:34.65 spid61 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-01 14:47:34.87 spid61 Using 'xplog70.dll' version > > '2000.80.760' to execute extended stored procedure 'xp_msver'. > > 2006-08-01 17:00:02.49 spid53 BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > 2006-08-01 17:00:02.49 backup BACKUP failed to complete the command > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > NOFORMAT > > 2006-08-01 17:18:17.30 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52607, first > > LSN: 14527:1903:1, last LSN: 14527:1909:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20070801'}). > > 2006-08-02 09:21:21.90 spid65 Error: 15457, Severity: 0, State: 1 > > 2006-08-02 09:21:21.90 spid65 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-02 09:49:46.44 spid54 Error: 15457, Severity: 0, State: 1 > > 2006-08-02 09:49:46.44 spid54 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-02 12:07:15.34 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52656, first > > LSN: 14538:1968:1, last LSN: 14538:2503:1, number of dump devices: 1, > > device information: (FILE=2, TYPE=DISK: > > {'C:\softpack\admis\backup\20060221'}). > > 2006-08-02 12:13:31.92 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52640, first > > LSN: 14539:200:1, last LSN: 14539:384:1, number of dump devices: 1, > > device information: (FILE=7, TYPE=DISK: > > {'C:\softpack\admis\backup\20060220'}). > > 2006-08-02 14:52:52.03 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51155, first > > LSN: 14549:731:1, last LSN: 14549:946:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\suhe_live'}). > > 2006-08-02 15:18:27.55 backup Database backed up: Database: JANUARI, > > creation date(time): 2006/07/20(18:27:34), pages dumped: 45859, first > > LSN: 13616:1547:1, last LSN: 13616:1552:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\suhe_jan'}). > > 2006-08-02 15:27:32.93 backup Database backed up: Database: coba, > > creation date(time): 2006/04/24(14:54:07), pages dumped: 23195, first > > LSN: 6836:42:1, last LSN: 6836:46:1, number of dump devices: 1, device > > information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\suhe_coba'}). > > 2006-08-02 16:20:39.29 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51132, first > > LSN: 14555:21914:1, last LSN: 14555:22024:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20060802'}). > > 2006-08-02 17:00:02.58 spid53 BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > 2006-08-02 17:00:02.59 backup BACKUP failed to complete the command > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > NOFORMAT > > 2006-08-03 10:50:03.50 spid69 Error: 15457, Severity: 0, State: 1 > > 2006-08-03 10:50:03.50 spid69 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-03 17:00:02.47 spid56 BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > 2006-08-03 17:00:02.49 backup BACKUP failed to complete the command > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > NOFORMAT > > 2006-08-03 17:08:49.78 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51452, first > > LSN: 14568:1152:1, last LSN: 14568:1173:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20070803'}). > > Can you post server configuration
(#of Processors, Memory Size, OS, SQL Server version and SQL Service Pack Version) -- Show quoteThanks & Rate the Postings. -Ravi- "krisl***@gmail.com" wrote: > Hi Sql Gurus, > (this is related to the post : > http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) > > Our custom application run on SQL Server 2000. On random period of time > > (but quite often lately) users get timed out, and when we checked the > server resources utilization, the utilization is so hight, so that only > > 80 MB out of 1 GB memory available. But we do not know what makes the > server very busy. > > Below is th Error LOG, what does it mean ? > (I am developer and don't now what the log says) > > Thank you for your help, > xtanto > > The Error Log : > > 2006-08-01 07:12:31.17 server Microsoft SQL Server 2000 - 8.00.760 > (Intel X86) > Dec 17 2002 14:22:05 > Copyright (c) 1988-2003 Microsoft Corporation > Standard Edition on Windows NT 5.2 (Build 3790: ) > > 2006-08-01 07:12:31.17 server Copyright (C) 1988-2002 Microsoft > Corporation. > 2006-08-01 07:12:31.17 server All rights reserved. > 2006-08-01 07:12:31.17 server Server Process ID is 1336. > 2006-08-01 07:12:31.17 server Logging SQL Server messages in file > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. > 2006-08-01 07:12:31.20 server SQL Server is starting at priority > class 'normal'(2 CPUs detected). > 2006-08-01 07:12:31.49 server SQL Server configured for thread mode > processing. > 2006-08-01 07:12:31.49 server Using dynamic lock allocation. [2500] > Lock Blocks, [5000] Lock Owner Blocks. > 2006-08-01 07:12:31.64 server Attempting to initialize Distributed > Transaction Coordinator. > 2006-08-01 07:12:33.46 spid3 Starting up database 'master'. > 2006-08-01 07:12:36.76 spid3 0 transactions rolled back in database > 'master' (1). > 2006-08-01 07:12:36.76 spid3 Recovery is checkpointing database > 'master' (1) > 2006-08-01 07:12:38.40 spid5 Starting up database 'model'. > 2006-08-01 07:12:38.40 server Using 'SSNETLIB.DLL' version > '8.0.766'. > 2006-08-01 07:12:38.45 server SQL server listening on > 192.168.100.10: 1433. > 2006-08-01 07:12:38.45 server SQL server listening on 127.0.0.1: > 1433. > 2006-08-01 07:12:38.45 spid3 Server name is 'SQL-SERVER'. > 2006-08-01 07:12:38.46 spid8 Starting up database 'msdb'. > 2006-08-01 07:12:38.46 spid9 Starting up database 'pubs'. > 2006-08-01 07:12:38.46 spid10 Starting up database 'Northwind'. > 2006-08-01 07:12:38.46 spid11 Starting up database 'coba'. > 2006-08-01 07:12:38.48 spid12 Starting up database 'admis'. > 2006-08-01 07:12:38.50 server SQL server listening on TCP, Shared > Memory, Named Pipes. > 2006-08-01 07:12:38.53 spid13 Starting up database 'admisgl'. > 2006-08-01 07:12:38.53 spid14 Starting up database 'sskolap'. > 2006-08-01 07:12:38.53 spid15 Starting up database 'JANUARI'. > 2006-08-01 07:12:38.57 server SQL Server is ready for client > connections > 2006-08-01 07:12:39.48 spid14 Analysis of database 'sskolap' (10) is > 100% complete (approximately 0 more seconds) > 2006-08-01 07:12:40.48 spid5 Clearing tempdb database. > 2006-08-01 07:12:52.15 spid5 Starting up database 'tempdb'. > 2006-08-01 07:20:59.17 spid3 Recovery complete. > 2006-08-01 07:20:59.17 spid3 SQL global counter collection task is > created. > 2006-08-01 07:21:03.40 spid51 Using 'xpsqlbot.dll' version > '2000.80.194' to execute extended stored procedure 'xp_qv'. > 2006-08-01 12:00:11.53 spid58 Using 'xpstar.dll' version > '2000.80.760' to execute extended stored procedure > 'xp_instance_regread'. > 2006-08-01 12:07:21.22 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > LSN: 14511:1799:1, last LSN: 14511:1887:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20060221'}). > 2006-08-01 12:13:35.92 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > LSN: 14511:1934:1, last LSN: 14511:2001:1, number of dump devices: 1, > device information: (FILE=6, TYPE=DISK: > {'C:\softpack\admis\backup\20060220'}). > 2006-08-01 14:47:34.65 spid61 Error: 15457, Severity: 0, State: 1 > 2006-08-01 14:47:34.65 spid61 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-01 14:47:34.87 spid61 Using 'xplog70.dll' version > '2000.80.760' to execute extended stored procedure 'xp_msver'. > 2006-08-01 17:00:02.49 spid53 BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system > error = 3(error not found). > 2006-08-01 17:00:02.49 backup BACKUP failed to complete the command > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > NOFORMAT > 2006-08-01 17:18:17.30 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52607, first > LSN: 14527:1903:1, last LSN: 14527:1909:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20070801'}). > 2006-08-02 09:21:21.90 spid65 Error: 15457, Severity: 0, State: 1 > 2006-08-02 09:21:21.90 spid65 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-02 09:49:46.44 spid54 Error: 15457, Severity: 0, State: 1 > 2006-08-02 09:49:46.44 spid54 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-02 12:07:15.34 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52656, first > LSN: 14538:1968:1, last LSN: 14538:2503:1, number of dump devices: 1, > device information: (FILE=2, TYPE=DISK: > {'C:\softpack\admis\backup\20060221'}). > 2006-08-02 12:13:31.92 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 52640, first > LSN: 14539:200:1, last LSN: 14539:384:1, number of dump devices: 1, > device information: (FILE=7, TYPE=DISK: > {'C:\softpack\admis\backup\20060220'}). > 2006-08-02 14:52:52.03 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 51155, first > LSN: 14549:731:1, last LSN: 14549:946:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\suhe_live'}). > 2006-08-02 15:18:27.55 backup Database backed up: Database: JANUARI, > creation date(time): 2006/07/20(18:27:34), pages dumped: 45859, first > LSN: 13616:1547:1, last LSN: 13616:1552:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\suhe_jan'}). > 2006-08-02 15:27:32.93 backup Database backed up: Database: coba, > creation date(time): 2006/04/24(14:54:07), pages dumped: 23195, first > LSN: 6836:42:1, last LSN: 6836:46:1, number of dump devices: 1, device > information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\suhe_coba'}). > 2006-08-02 16:20:39.29 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 51132, first > LSN: 14555:21914:1, last LSN: 14555:22024:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20060802'}). > 2006-08-02 17:00:02.58 spid53 BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system > error = 3(error not found). > 2006-08-02 17:00:02.59 backup BACKUP failed to complete the command > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > NOFORMAT > 2006-08-03 10:50:03.50 spid69 Error: 15457, Severity: 0, State: 1 > 2006-08-03 10:50:03.50 spid69 Configuration option 'show advanced > options' changed from 1 to 1. Run the RECONFIGURE statement to > install.. > 2006-08-03 17:00:02.47 spid56 BackupDiskFile::CreateMedia: Backup > device 'C:\softpack\admis\backup\' failed to create. Operating system > error = 3(error not found). > 2006-08-03 17:00:02.49 backup BACKUP failed to complete the command > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > NOFORMAT > 2006-08-03 17:08:49.78 backup Database backed up: Database: admis, > creation date(time): 2005/12/06(14:20:58), pages dumped: 51452, first > LSN: 14568:1152:1, last LSN: 14568:1173:1, number of dump devices: 1, > device information: (FILE=1, TYPE=DISK: > {'C:\softpack\admis\backup\20070803'}). > > Hi Ravi,
one Processors, Memory 1 GB, WIndows Server 2003, SQL Server 2000 SP 3a. Does it indicate something ? Ravi menuliskan: Show quote > Can you post server configuration > (#of Processors, Memory Size, OS, SQL Server version and SQL Service Pack > Version) > > -- > Thanks & Rate the Postings. > -Ravi- > > > "krisl***@gmail.com" wrote: > > > Hi Sql Gurus, > > (this is related to the post : > > http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) > > > > Our custom application run on SQL Server 2000. On random period of time > > > > (but quite often lately) users get timed out, and when we checked the > > server resources utilization, the utilization is so hight, so that only > > > > 80 MB out of 1 GB memory available. But we do not know what makes the > > server very busy. > > > > Below is th Error LOG, what does it mean ? > > (I am developer and don't now what the log says) > > > > Thank you for your help, > > xtanto > > > > The Error Log : > > > > 2006-08-01 07:12:31.17 server Microsoft SQL Server 2000 - 8.00.760 > > (Intel X86) > > Dec 17 2002 14:22:05 > > Copyright (c) 1988-2003 Microsoft Corporation > > Standard Edition on Windows NT 5.2 (Build 3790: ) > > > > 2006-08-01 07:12:31.17 server Copyright (C) 1988-2002 Microsoft > > Corporation. > > 2006-08-01 07:12:31.17 server All rights reserved. > > 2006-08-01 07:12:31.17 server Server Process ID is 1336. > > 2006-08-01 07:12:31.17 server Logging SQL Server messages in file > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. > > 2006-08-01 07:12:31.20 server SQL Server is starting at priority > > class 'normal'(2 CPUs detected). > > 2006-08-01 07:12:31.49 server SQL Server configured for thread mode > > processing. > > 2006-08-01 07:12:31.49 server Using dynamic lock allocation. [2500] > > Lock Blocks, [5000] Lock Owner Blocks. > > 2006-08-01 07:12:31.64 server Attempting to initialize Distributed > > Transaction Coordinator. > > 2006-08-01 07:12:33.46 spid3 Starting up database 'master'. > > 2006-08-01 07:12:36.76 spid3 0 transactions rolled back in database > > 'master' (1). > > 2006-08-01 07:12:36.76 spid3 Recovery is checkpointing database > > 'master' (1) > > 2006-08-01 07:12:38.40 spid5 Starting up database 'model'. > > 2006-08-01 07:12:38.40 server Using 'SSNETLIB.DLL' version > > '8.0.766'. > > 2006-08-01 07:12:38.45 server SQL server listening on > > 192.168.100.10: 1433. > > 2006-08-01 07:12:38.45 server SQL server listening on 127.0.0.1: > > 1433. > > 2006-08-01 07:12:38.45 spid3 Server name is 'SQL-SERVER'. > > 2006-08-01 07:12:38.46 spid8 Starting up database 'msdb'. > > 2006-08-01 07:12:38.46 spid9 Starting up database 'pubs'. > > 2006-08-01 07:12:38.46 spid10 Starting up database 'Northwind'. > > 2006-08-01 07:12:38.46 spid11 Starting up database 'coba'. > > 2006-08-01 07:12:38.48 spid12 Starting up database 'admis'. > > 2006-08-01 07:12:38.50 server SQL server listening on TCP, Shared > > Memory, Named Pipes. > > 2006-08-01 07:12:38.53 spid13 Starting up database 'admisgl'. > > 2006-08-01 07:12:38.53 spid14 Starting up database 'sskolap'. > > 2006-08-01 07:12:38.53 spid15 Starting up database 'JANUARI'. > > 2006-08-01 07:12:38.57 server SQL Server is ready for client > > connections > > 2006-08-01 07:12:39.48 spid14 Analysis of database 'sskolap' (10) is > > 100% complete (approximately 0 more seconds) > > 2006-08-01 07:12:40.48 spid5 Clearing tempdb database. > > 2006-08-01 07:12:52.15 spid5 Starting up database 'tempdb'. > > 2006-08-01 07:20:59.17 spid3 Recovery complete. > > 2006-08-01 07:20:59.17 spid3 SQL global counter collection task is > > created. > > 2006-08-01 07:21:03.40 spid51 Using 'xpsqlbot.dll' version > > '2000.80.194' to execute extended stored procedure 'xp_qv'. > > 2006-08-01 12:00:11.53 spid58 Using 'xpstar.dll' version > > '2000.80.760' to execute extended stored procedure > > 'xp_instance_regread'. > > 2006-08-01 12:07:21.22 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > > LSN: 14511:1799:1, last LSN: 14511:1887:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20060221'}). > > 2006-08-01 12:13:35.92 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > > LSN: 14511:1934:1, last LSN: 14511:2001:1, number of dump devices: 1, > > device information: (FILE=6, TYPE=DISK: > > {'C:\softpack\admis\backup\20060220'}). > > 2006-08-01 14:47:34.65 spid61 Error: 15457, Severity: 0, State: 1 > > 2006-08-01 14:47:34.65 spid61 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-01 14:47:34.87 spid61 Using 'xplog70.dll' version > > '2000.80.760' to execute extended stored procedure 'xp_msver'. > > 2006-08-01 17:00:02.49 spid53 BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > 2006-08-01 17:00:02.49 backup BACKUP failed to complete the command > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > NOFORMAT > > 2006-08-01 17:18:17.30 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52607, first > > LSN: 14527:1903:1, last LSN: 14527:1909:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20070801'}). > > 2006-08-02 09:21:21.90 spid65 Error: 15457, Severity: 0, State: 1 > > 2006-08-02 09:21:21.90 spid65 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-02 09:49:46.44 spid54 Error: 15457, Severity: 0, State: 1 > > 2006-08-02 09:49:46.44 spid54 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-02 12:07:15.34 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52656, first > > LSN: 14538:1968:1, last LSN: 14538:2503:1, number of dump devices: 1, > > device information: (FILE=2, TYPE=DISK: > > {'C:\softpack\admis\backup\20060221'}). > > 2006-08-02 12:13:31.92 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52640, first > > LSN: 14539:200:1, last LSN: 14539:384:1, number of dump devices: 1, > > device information: (FILE=7, TYPE=DISK: > > {'C:\softpack\admis\backup\20060220'}). > > 2006-08-02 14:52:52.03 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51155, first > > LSN: 14549:731:1, last LSN: 14549:946:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\suhe_live'}). > > 2006-08-02 15:18:27.55 backup Database backed up: Database: JANUARI, > > creation date(time): 2006/07/20(18:27:34), pages dumped: 45859, first > > LSN: 13616:1547:1, last LSN: 13616:1552:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\suhe_jan'}). > > 2006-08-02 15:27:32.93 backup Database backed up: Database: coba, > > creation date(time): 2006/04/24(14:54:07), pages dumped: 23195, first > > LSN: 6836:42:1, last LSN: 6836:46:1, number of dump devices: 1, device > > information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\suhe_coba'}). > > 2006-08-02 16:20:39.29 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51132, first > > LSN: 14555:21914:1, last LSN: 14555:22024:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20060802'}). > > 2006-08-02 17:00:02.58 spid53 BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > 2006-08-02 17:00:02.59 backup BACKUP failed to complete the command > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > NOFORMAT > > 2006-08-03 10:50:03.50 spid69 Error: 15457, Severity: 0, State: 1 > > 2006-08-03 10:50:03.50 spid69 Configuration option 'show advanced > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > install.. > > 2006-08-03 17:00:02.47 spid56 BackupDiskFile::CreateMedia: Backup > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > error = 3(error not found). > > 2006-08-03 17:00:02.49 backup BACKUP failed to complete the command > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > NOFORMAT > > 2006-08-03 17:08:49.78 backup Database backed up: Database: admis, > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51452, first > > LSN: 14568:1152:1, last LSN: 14568:1173:1, number of dump devices: 1, > > device information: (FILE=1, TYPE=DISK: > > {'C:\softpack\admis\backup\20070803'}). > > > > Please refer the MS Article for the reason I asked the configurtion
http://support.microsoft.com/kb/835864/ Mutiprocessor computer running SQL 2000 SP3 or Sp3a may have performance bottlenecks. In your case, you are running SQL on a single processor box. This may not be applicable to you. But you can check the following - Are you reindexing the tables. If Yes, How Often? - Is there any other applications running on the server besides SQL Server. Also it is not a bad idea to upgrade to SP4. There are many performance related fixes in SP4. In my personal experience SP4 resolved couple of performance issues. But the test the application completly with SP4 in a test environment before updating the live server Hope this helps -- Show quoteTHANKS & PLEASE RATE THE POSTING. --RAVI-- "krisl***@gmail.com" wrote: > Hi Ravi, > > one Processors, > Memory 1 GB, > WIndows Server 2003, > SQL Server 2000 SP 3a. > > Does it indicate something ? > > > > > Ravi menuliskan: > > Can you post server configuration > > (#of Processors, Memory Size, OS, SQL Server version and SQL Service Pack > > Version) > > > > -- > > Thanks & Rate the Postings. > > -Ravi- > > > > > > "krisl***@gmail.com" wrote: > > > > > Hi Sql Gurus, > > > (this is related to the post : > > > http://groups.google.co.id/group/microsoft.public.sqlserver.programming/browse_thread/thread/cad52b42320a6b60/2fe00ae19e805da1?lnk=gst&q=xtanto&rnum=1#2fe00ae19e805da1) > > > > > > Our custom application run on SQL Server 2000. On random period of time > > > > > > (but quite often lately) users get timed out, and when we checked the > > > server resources utilization, the utilization is so hight, so that only > > > > > > 80 MB out of 1 GB memory available. But we do not know what makes the > > > server very busy. > > > > > > Below is th Error LOG, what does it mean ? > > > (I am developer and don't now what the log says) > > > > > > Thank you for your help, > > > xtanto > > > > > > The Error Log : > > > > > > 2006-08-01 07:12:31.17 server Microsoft SQL Server 2000 - 8.00.760 > > > (Intel X86) > > > Dec 17 2002 14:22:05 > > > Copyright (c) 1988-2003 Microsoft Corporation > > > Standard Edition on Windows NT 5.2 (Build 3790: ) > > > > > > 2006-08-01 07:12:31.17 server Copyright (C) 1988-2002 Microsoft > > > Corporation. > > > 2006-08-01 07:12:31.17 server All rights reserved. > > > 2006-08-01 07:12:31.17 server Server Process ID is 1336. > > > 2006-08-01 07:12:31.17 server Logging SQL Server messages in file > > > 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'. > > > 2006-08-01 07:12:31.20 server SQL Server is starting at priority > > > class 'normal'(2 CPUs detected). > > > 2006-08-01 07:12:31.49 server SQL Server configured for thread mode > > > processing. > > > 2006-08-01 07:12:31.49 server Using dynamic lock allocation. [2500] > > > Lock Blocks, [5000] Lock Owner Blocks. > > > 2006-08-01 07:12:31.64 server Attempting to initialize Distributed > > > Transaction Coordinator. > > > 2006-08-01 07:12:33.46 spid3 Starting up database 'master'. > > > 2006-08-01 07:12:36.76 spid3 0 transactions rolled back in database > > > 'master' (1). > > > 2006-08-01 07:12:36.76 spid3 Recovery is checkpointing database > > > 'master' (1) > > > 2006-08-01 07:12:38.40 spid5 Starting up database 'model'. > > > 2006-08-01 07:12:38.40 server Using 'SSNETLIB.DLL' version > > > '8.0.766'. > > > 2006-08-01 07:12:38.45 server SQL server listening on > > > 192.168.100.10: 1433. > > > 2006-08-01 07:12:38.45 server SQL server listening on 127.0.0.1: > > > 1433. > > > 2006-08-01 07:12:38.45 spid3 Server name is 'SQL-SERVER'. > > > 2006-08-01 07:12:38.46 spid8 Starting up database 'msdb'. > > > 2006-08-01 07:12:38.46 spid9 Starting up database 'pubs'. > > > 2006-08-01 07:12:38.46 spid10 Starting up database 'Northwind'. > > > 2006-08-01 07:12:38.46 spid11 Starting up database 'coba'. > > > 2006-08-01 07:12:38.48 spid12 Starting up database 'admis'. > > > 2006-08-01 07:12:38.50 server SQL server listening on TCP, Shared > > > Memory, Named Pipes. > > > 2006-08-01 07:12:38.53 spid13 Starting up database 'admisgl'. > > > 2006-08-01 07:12:38.53 spid14 Starting up database 'sskolap'. > > > 2006-08-01 07:12:38.53 spid15 Starting up database 'JANUARI'. > > > 2006-08-01 07:12:38.57 server SQL Server is ready for client > > > connections > > > 2006-08-01 07:12:39.48 spid14 Analysis of database 'sskolap' (10) is > > > 100% complete (approximately 0 more seconds) > > > 2006-08-01 07:12:40.48 spid5 Clearing tempdb database. > > > 2006-08-01 07:12:52.15 spid5 Starting up database 'tempdb'. > > > 2006-08-01 07:20:59.17 spid3 Recovery complete. > > > 2006-08-01 07:20:59.17 spid3 SQL global counter collection task is > > > created. > > > 2006-08-01 07:21:03.40 spid51 Using 'xpsqlbot.dll' version > > > '2000.80.194' to execute extended stored procedure 'xp_qv'. > > > 2006-08-01 12:00:11.53 spid58 Using 'xpstar.dll' version > > > '2000.80.760' to execute extended stored procedure > > > 'xp_instance_regread'. > > > 2006-08-01 12:07:21.22 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > > > LSN: 14511:1799:1, last LSN: 14511:1887:1, number of dump devices: 1, > > > device information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\20060221'}). > > > 2006-08-01 12:13:35.92 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52389, first > > > LSN: 14511:1934:1, last LSN: 14511:2001:1, number of dump devices: 1, > > > device information: (FILE=6, TYPE=DISK: > > > {'C:\softpack\admis\backup\20060220'}). > > > 2006-08-01 14:47:34.65 spid61 Error: 15457, Severity: 0, State: 1 > > > 2006-08-01 14:47:34.65 spid61 Configuration option 'show advanced > > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > > install.. > > > 2006-08-01 14:47:34.87 spid61 Using 'xplog70.dll' version > > > '2000.80.760' to execute extended stored procedure 'xp_msver'. > > > 2006-08-01 17:00:02.49 spid53 BackupDiskFile::CreateMedia: Backup > > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > > error = 3(error not found). > > > 2006-08-01 17:00:02.49 backup BACKUP failed to complete the command > > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > > NOFORMAT > > > 2006-08-01 17:18:17.30 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52607, first > > > LSN: 14527:1903:1, last LSN: 14527:1909:1, number of dump devices: 1, > > > device information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\20070801'}). > > > 2006-08-02 09:21:21.90 spid65 Error: 15457, Severity: 0, State: 1 > > > 2006-08-02 09:21:21.90 spid65 Configuration option 'show advanced > > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > > install.. > > > 2006-08-02 09:49:46.44 spid54 Error: 15457, Severity: 0, State: 1 > > > 2006-08-02 09:49:46.44 spid54 Configuration option 'show advanced > > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > > install.. > > > 2006-08-02 12:07:15.34 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52656, first > > > LSN: 14538:1968:1, last LSN: 14538:2503:1, number of dump devices: 1, > > > device information: (FILE=2, TYPE=DISK: > > > {'C:\softpack\admis\backup\20060221'}). > > > 2006-08-02 12:13:31.92 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 52640, first > > > LSN: 14539:200:1, last LSN: 14539:384:1, number of dump devices: 1, > > > device information: (FILE=7, TYPE=DISK: > > > {'C:\softpack\admis\backup\20060220'}). > > > 2006-08-02 14:52:52.03 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51155, first > > > LSN: 14549:731:1, last LSN: 14549:946:1, number of dump devices: 1, > > > device information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\suhe_live'}). > > > 2006-08-02 15:18:27.55 backup Database backed up: Database: JANUARI, > > > creation date(time): 2006/07/20(18:27:34), pages dumped: 45859, first > > > LSN: 13616:1547:1, last LSN: 13616:1552:1, number of dump devices: 1, > > > device information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\suhe_jan'}). > > > 2006-08-02 15:27:32.93 backup Database backed up: Database: coba, > > > creation date(time): 2006/04/24(14:54:07), pages dumped: 23195, first > > > LSN: 6836:42:1, last LSN: 6836:46:1, number of dump devices: 1, device > > > information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\suhe_coba'}). > > > 2006-08-02 16:20:39.29 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51132, first > > > LSN: 14555:21914:1, last LSN: 14555:22024:1, number of dump devices: 1, > > > device information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\20060802'}). > > > 2006-08-02 17:00:02.58 spid53 BackupDiskFile::CreateMedia: Backup > > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > > error = 3(error not found). > > > 2006-08-02 17:00:02.59 backup BACKUP failed to complete the command > > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > > NOFORMAT > > > 2006-08-03 10:50:03.50 spid69 Error: 15457, Severity: 0, State: 1 > > > 2006-08-03 10:50:03.50 spid69 Configuration option 'show advanced > > > options' changed from 1 to 1. Run the RECONFIGURE statement to > > > install.. > > > 2006-08-03 17:00:02.47 spid56 BackupDiskFile::CreateMedia: Backup > > > device 'C:\softpack\admis\backup\' failed to create. Operating system > > > error = 3(error not found). > > > 2006-08-03 17:00:02.49 backup BACKUP failed to complete the command > > > BACKUP DATABASE [admis] TO DISK = N'C:\softpack\admis\backup\' WITH > > > NOINIT , NOUNLOAD , NAME = N'admis backup', NOSKIP , STATS = 10, > > > NOFORMAT > > > 2006-08-03 17:08:49.78 backup Database backed up: Database: admis, > > > creation date(time): 2005/12/06(14:20:58), pages dumped: 51452, first > > > LSN: 14568:1152:1, last LSN: 14568:1173:1, number of dump devices: 1, > > > device information: (FILE=1, TYPE=DISK: > > > {'C:\softpack\admis\backup\20070803'}). > > > > > > > >  |
|||||||||||||||||||||||
Other interesting topics