Solved

Database Mirroring :  increasing network RTT for Workload on windows

Posted on 2011-09-15
4
265 Views
Last Modified: 2012-05-12
Hello,

How can I opimize dbmirroring with increasing network RTT for Workload on windows?
http://msdn.microsoft.com/en-us/library/cc917681.aspx#EGAA

Thanks
bibi
0
Comment
Question by:bibi92
  • 3
4 Comments
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36542522
Have you seen the mirroring monitor?  It definitely opens your eyes to several key performance metrics:
http://sqlserver-training.com/how-to-monitor-database-mirroring-sql-server/-
0
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 36542547
also, there are several key optimization tips here:  http://technet.microsoft.com/en-us/magazine/cc135965.aspx
mirrored or not, they should be advantageous
0
 

Author Closing Comment

by:bibi92
ID: 36543218
Thanks bibi
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36543320
glad to help!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

920 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now