April 14, 2011 at 3:58 am
Hi all,
Not sure if this should be in backups or replication, but ... (Background)
I have a 2005 Sp3 cu6 cluster, with 9 dbs running on 6 10k iscsi san disks; db, indexes and log groups on separate disks.
4 of these are published for replication.
Distribution db is local to the server and the db and log files are on the same disks as the user dbs.
Those 4 published dbs and distribution have the 'sync with backup' option set to true for replication. (this is why not sure this is the right place to ask).
I do log backups every 15mins from a maintenance plan,
My issue is, every so often the backup of the distribution log hangs....
From SQL, WhatsUpGold Monitoring and Idera, I can see that the log backup stalls the log reader jobs and has to be stopped to resume the log readers.
Nothing is blocking the distribution log backup, my only clue is when its traced, the server shows, a wait on 'i/o completion' backing up the log.
Which again makes no sense as I can stop the plan, and backup the log manually with no issue.
Another weird point is that the disks where the system dbs are held, becomes 60% utilized , (usually 5% utilized), during the backup hang and in Activity Monitor, the suspended spid shows the last command as an 'UPDTAE'.....
An update to what?? Is this an issue where it is trying to write to 'msdb' to say its started a log backup job???
The msdb checks out ok, and like I say it happens once in a while but is getting to be more often than the once a month it used to be.
Anyone else had this issue??
Any help would be gratefully appreciated 🙂
April 14, 2011 at 7:18 am
This is just a SWAG, but do you have a system backup that runs that might be locking files? We ran into a similar issue when our system backup would conflict with the backup process and both would hang.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 14, 2011 at 7:26 am
Nah, the system db backups are once a day at 2000.
So far this has happened in the mid afternoon, 1400 -1500 and once at 0000
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply