August 2012
Intermediate to advanced
1416 pages
33h 39m
English
book
Microsoft SQL Server 2012 Bible
by Adam Jorgensen, Jorge Segarra, Patrick LeBlanc, Jose Chinchilla, Aaron Nelson
Content preview from Microsoft SQL Server 2012 Bible
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Monitoring Database Mirroring
You can monitor database mirroring in many ways. The simplest way to monitor database mirroring is to launch the Database Mirroring Monitor. To monitor database mirroring performance, you can use System Monitor performance counters on the mirroring partners. You can also use the SQL Server Profiler tool to capture the time taken for database mirroring failover.
Monitoring Using Database Mirroring Monitor
Microsoft provides a useful tool called Database Mirroring Monitor to monitor database mirroring. You can launch the Database Mirroring Monitor tool from SQL Server Management Studio as follows:
1. Open Management Studio, and connect to the principal or mirror server.
2. Expand Databases, and right-click the principal database.
3. Select Tasks, and then click Launch Database Mirroring Monitor.
4. Click Action menu, and select Register Mirrored Database.
5. On the Register Mirrored Database dialog box, click the Connect button to display the Connect to Server dialog box. Type the connection properties of the principal or the mirror server, and click Connect. This brings you back to the Register Mirrored Database dialog box. Click Register. Database Mirroring Monitor registers the database and both partner servers. To modify the credentials used to connect to the partners, click the Show the Manage Server Connections Dialog Box When I Click OK check box. Click OK to continue.
6. The Database Mirroring Monitor should now show you the principal and ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.