sql server 2005下数据库读写缓慢？？

Question

请教下各位，我单位窗口业务软件是C/S结构的，后台数据库为sql2005工作组版，近期业务软件经常出现数据读写缓慢的情况，经检查服务器负载及客户端软件均正常，数据库日志有错误记录，请帮忙看下是否是数据库的问题，非常感谢！！部分日志如下：(业务软件数据库名称为"DBFile")

 

 

09/07/2011 15:02:52,spid75,未知,Starting up database 'scanmaster'.

09/07/2011 15:02:52,spid75,未知,Starting up database 'scanmaster'.

09/07/2011 15:02:52,spid75,未知,Starting up database 'dbawr'.

09/07/2011 15:02:51,spid75,未知,Starting up database 'scanmaster'.

09/07/2011 15:02:50,spid75,未知,Starting up database 'dbawr'.

09/07/2011 15:02:50,spid75,未知,Starting up database 'scanmaster'.

09/07/2011 15:02:50,spid75,未知,Starting up database 'dbawr'.

09/07/2011 15:02:49,spid75,未知,Starting up database 'scanmaster'.

09/07/2011 15:02:49,spid75,未知,Starting up database 'dbawr'.

09/07/2011 14:49:11,spid4s,未知,SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x0000003e748000

09/07/2011 12:27:44,备份,未知,Log was backed up. Database: DBFile<c/> creation date(time): 2007/08/20(14:20:03)<c/> first LSN: 7681:115414:1<c/> last LSN: 7682:57694:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#80ace3b0-fa32-45db-8a05-89abcaae43db'}). This is an informational message only. No user action is required.

09/07/2011 12:27:35,备份,未知,Log was backed up. Database: userDB<c/> creation date(time): 2007/08/20(14:24:56)<c/> first LSN: 289:513:1<c/> last LSN: 289:527:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#c0983b41-c82f-4353-b490-682adff8c298'}). This is an informational message only. No user action is required.

09/07/2011 10:02:27,spid4s,未知,SQL Server has encountered 8 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x000000fc50e000

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4fe000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4fc000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4fa000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4f8000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4f6000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4f4000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4f2000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:33,spid96,未知,A read of the file 'Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf' at offset 0x0000018d4f0000 succeeded after failing 1 time(s) with error: 1167(设备没有连接。). Additional messages in the SQL Server error log and system event log may provide more detail. This error condition threatens database integrity and must be corrected. Complete a full database consistency check (DBCC CHECKDB). This error can be caused by many factors; for more information<c/> see SQL Server Books Online.

09/07/2011 09:53:28,spid4s,未知,SQL Server has encountered 15 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x0000018e0fc000

09/07/2011 09:32:17,spid4s,未知,SQL Server has encountered 16 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x000001a1bb0000

09/07/2011 00:27:43,备份,未知,Log was backed up. Database: DBFile<c/> creation date(time): 2007/08/20(14:20:03)<c/> first LSN: 7681:66657:1<c/> last LSN: 7681:115414:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#be06ce95-a717-4f08-8a82-35062738c4fd'}). This is an informational message only. No user action is required.

09/07/2011 00:27:39,备份,未知,Log was backed up. Database: userDB<c/> creation date(time): 2007/08/20(14:24:56)<c/> first LSN: 289:503:1<c/> last LSN: 289:513:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#40ddad1f-0682-4070-bdcd-36dd4b0dea96'}). This is an informational message only. No user action is required.

09/07/2011 00:00:26,spid23s,未知,This instance of SQL Server has been using a process ID of 1480 since 2011-8-23 17:56:23 (local) 2011-8-23 9:56:23 (UTC). This is an informational message only; no user action is required.

09/06/2011 17:47:15,备份,未知,Database backed up. Database: DBFile<c/> creation date(time): 2007/08/20(14:20:03)<c/> pages dumped: 1346388<c/> first LSN: 7681:115271:254<c/> last LSN: 7681:115376:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=DISK: {'F:\zfgjjdata\201109061744DBFile.dat'}). This is an informational message only. No user action is required.

09/06/2011 17:11:06,spid4s,未知,SQL Server has encountered 34 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x00000206b60000

09/06/2011 16:25:07,spid4s,未知,SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\userDB.mdf] in database [userDB] (10).  The OS file handle is 0x00000814.  The offset of the latest long I/O is: 0x00000000042000

09/06/2011 16:24:57,spid4s,未知,SQL Server has encountered 10 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x000001ca2c0000

09/06/2011 15:49:27,spid4s,未知,SQL Server has encountered 3 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x0000001d0d0000

09/06/2011 12:27:53,备份,未知,Log was backed up. Database: DBFile<c/> creation date(time): 2007/08/20(14:20:03)<c/> first LSN: 7680:19088:1<c/> last LSN: 7681:66657:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#ccda6158-05ba-49d4-aba3-17306814c632'}). This is an informational message only. No user action is required.

09/06/2011 12:27:38,备份,未知,Log was backed up. Database: userDB<c/> creation date(time): 2007/08/20(14:24:56)<c/> first LSN: 289:492:1<c/> last LSN: 289:503:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#cbe024b2-e56e-4aca-8754-fe6692672b67'}). This is an informational message only. No user action is required.

09/06/2011 11:29:04,spid4s,未知,SQL Server has encountered 23 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x00000026700000

09/06/2011 10:43:39,spid4s,未知,SQL Server has encountered 10 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x00000022d90000

09/06/2011 10:02:54,spid4s,未知,SQL Server has encountered 2 occurrence(s) of I/O requests taking longer than 15 seconds to complete on file [Z:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\DBFile.mdf] in database [DBFile] (9).  The OS file handle is 0x000007F4.  The offset of the latest long I/O is: 0x0000003a830000

09/06/2011 00:28:01,备份,未知,Log was backed up. Database: DBFile<c/> creation date(time): 2007/08/20(14:20:03)<c/> first LSN: 7678:108640:1<c/> last LSN: 7680:19088:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#93d5702f-8ad1-49b3-b93d-3a2466f400c6'}). This is an informational message only. No user action is required.

09/06/2011 00:27:42,备份,未知,Log was backed up. Database: userDB<c/> creation date(time): 2007/08/20(14:24:56)<c/> first LSN: 289:465:1<c/> last LSN: 289:492:1<c/> number of dump devices: 1<c/> device information: (FILE=1<c/> TYPE=VIRTUAL_DEVICE: {'Legato#edd8bd1e-98cb-441b-b02e-1725e874eb1e'}). This is an informational message only. No user action is required.

09/06/2011 00:00:15,spid18s,未知,This instance of SQL Server has been using a process ID of 1480 since 2011-8-23 17:56:23 (local) 2011-8-23 9:56:23 (UTC). This is an informational message only; no user action is required.