December 26, 2008 at 8:46 am
Hi All,
We are seeing UMS Errors in SQL Server ERRORLOG file on one of my prodution box while we are taking the backup of the database.
I suspected that there is a problem with the disk sussystems and latency issues with the disks.
I verified with the SAN Disk hardware vendor and they said that there is no problem with the Disks IO and latency issues.
I am seeing lastwaittype as ASYNC_DISKPOOL_LOCK in sysprocesses while I am taking the backup of the database,
database size is just 2 GB.
I am sure that there is no IO pressure on the disks where database data file and log file were placed and the backup file target disk.
We have set the correct DOP (Degree of Parallelism) to balance the threads.
It is not throwing dump any stack dump files in SQL Server Error Log folder.
Find the SQL Server and OS details below.
1. SQL Server 2000 with SP4 and product version is 8.00.2187
2. It is a clustered server
3. SELECT @@VERSION
-----------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2000 - 8.00.2187 (Intel X86)
Mar 9 2006 11:38:51
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
-----------------------------------------------------------------------------------------------------------------------------
Here my questions are
1. I have SP4 with hot fix 2187, (8.00.2187) Do I need to apply any hotfix or patch to avoid UMS errors or ASYNC_DISKPOOL_LOCK.
I have the preprod server with the same configuration, there SQL Server is not throwing the UMS errors but I could see the lastwaittype as ASYNC_DISKPOOL_LOCK in sysprocesses while I am taking the backup of the database.
Here Why I am seeing the lastwaittype as ASYNC_DISKPOOL_LOCK in sysprocesses while I am taking the backup of the database even though there is no I0 issues and no problem with the Indexes.
Did any one of you faced the same kind of problem.
Please help me and give me the suggestions to resolve the issue.
Thanks in Advance
Regards
Rajesh Kasturi
Rajesh Kasturi
December 26, 2008 at 12:39 pm
How much time it takes to backup this 2GB database? Also, check the following disk counters:
See PhysicalDisk counters:
· Disk sec/Read
· Disk sec/Write
· Average Disk Queue Length.
MJ
December 27, 2008 at 11:14 pm
It will complete in 2 to 3 min, it is not taking much time.
Rajesh Kasturi
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply