<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
SQL Server 2008 High Availability
»
Mirroring restore rate very low (< 5...
12 posts, Page 1 of 2
1
2
»»
Mirroring restore rate very low (< 5 MB/sec) - database mirror stuck in "synchronizing" state for several hrs
Rate Topic
Display Mode
Topic Options
Author
Message
Marios Philippopoulos
Marios Philippopoulos
Posted Monday, July 16, 2012 3:13 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
A production mirroring session started synchronizing this morning and at first the restore rate on the mirror server was at about 30 MB /sec.
Suddenly it dropped to < 5 MB /sec and has stayed like this for most of the day.
As a result, the mirror has been in "synchronizing" status for most of the day, and we are unable to create snapshots for reporting users.
What could be the cause of such a low restore rate?
What should I be looking for?
Any links/suggestions would be most welcome.
__________________________________________________________________________________
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1330430
David Webb-CDS
David Webb-CDS
Posted Monday, July 16, 2012 3:23 PM
SSC Eights!
Group: General Forum Members
Last Login: 2 days ago @ 4:48 PM
Points: 834,
Visits: 5,836
Just some random thoughts:
Check the disks for contention
Check to see if anything else is running on the box and consuming inordinate CPU and/or memory
Make sure your anti-virus software isn't on and attempting to scan your database files
check the sql server for blocked processes
Depending on how far the data is travelling, you might have to have your network folks take a look at the traffic between source and mirror
And then again, I might be wrong ...
David Webb
Post #1330432
ksrikanth77
ksrikanth77
Posted Tuesday, July 17, 2012 12:45 AM
Valued Member
Group: General Forum Members
Last Login: Wednesday, June 05, 2013 3:01 PM
Points: 54,
Visits: 122
I think the above all is sufficient to get the culprit
but mostly It would be Network Bandwidth
Thanks
S.R.Kundur
Post #1330533
Marios Philippopoulos
Marios Philippopoulos
Posted Tuesday, July 17, 2012 2:41 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
Thanks both for your suggestions.
__________________________________________________________________________________
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1330579
Robert Davis
Robert Davis
Posted Tuesday, July 17, 2012 11:11 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 1,559,
Visits: 1,404
There is also a bug related to this (though I don't know if a KB has been published Try stopping and starting the mirroring queues to see if it resolves the problem. If not, continue investigating and consider opening a case with PSS.
My blog: SQL Soldier
Twitter:
@SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring
Post #1330903
Marios Philippopoulos
Marios Philippopoulos
Posted Wednesday, July 18, 2012 3:04 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
Robert Davis (7/17/2012)
There is also a bug related to this (though I don't know if a KB has been published Try stopping and starting the mirroring queues to see if it resolves the problem. If not, continue investigating and consider opening a case with PSS.
Thank you for the suggestion.
Do you mean suspend and resume the mirroring session?
I will try that next time this happens.
__________________________________________________________________________________
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1331314
Robert Davis
Robert Davis
Posted Wednesday, July 18, 2012 9:10 AM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 1,559,
Visits: 1,404
No I meant stop/start the mirroring endpoints. Use an Alter Endpoint caommand and do it on both partners.
My blog: SQL Soldier
Twitter:
@SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring
Post #1331547
Marios Philippopoulos
Marios Philippopoulos
Posted Wednesday, July 18, 2012 8:56 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
Robert Davis (7/18/2012)
No I meant stop/start the mirroring endpoints. Use an Alter Endpoint caommand and do it on both partners.
Thanks for clarifying, now I know what you mean; will try that.
__________________________________________________________________________________
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1331889
Marios Philippopoulos
Marios Philippopoulos
Posted Saturday, July 21, 2012 9:40 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:25 PM
Points: 1,825,
Visits: 3,484
Could the slow restore rate be caused by high file fragmentation on the mirror server?
Perhaps we are due for a file defrag outage.
__________________________________________________________________________________
Turbocharge Your Database Maintenance With Service Broker: Part 1
Real-Time Tracking of Tempdb Utilization Through Reporting Services
Monitoring Database Blocking Through SCOM 2007 Custom Rules and Alerts
Preparing for the Unthinkable - a Disaster/Recovery Implementation
Post #1333433
Robert Davis
Robert Davis
Posted Saturday, July 21, 2012 10:55 PM
SSCommitted
Group: General Forum Members
Last Login: Yesterday @ 2:01 PM
Points: 1,559,
Visits: 1,404
Marios Philippopoulos (7/21/2012)
Could the slow restore rate be caused by high file fragmentation on the mirror server?
Perhaps we are due for a file defrag outage.
No file level fragmentation would cause a slow degradation of performance, not a sudden one.
My blog: SQL Soldier
Twitter:
@SQLSoldier
Microsoft Certified Master: SQL Server 2008
Sr. Product Consultant and Chief SQL Server Evangelist @ Idera
My book: Pro SQL Server 2008 Mirroring
Post #1333436
« Prev Topic
|
Next Topic »
12 posts, Page 1 of 2
1
2
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
