question

narendba avatar image
narendba asked

Health checkups on mirroring server?

Can anyone give me the health checkups information on mirror database servers and everyday what are the important information have to be change mirror server?
sql-server-2005
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

narendba avatar image narendba commented ·
Do we have to check any other related information for daily monitoring purpose? Is there any commands for it? How to test the data or packets(latancy) are sending from principle and mirror server or fastness?
0 Likes 0 ·
narendba avatar image narendba commented ·
what are the main things we have to conentrate on monitoring the servers which are in mirroring heigh availability...
0 Likes 0 ·
narendba avatar image narendba commented ·
Normally if the principle database status changed to suspended and it don't have witnes server then what are the steps we are going to concentrate on failover?
0 Likes 0 ·
narendba avatar image narendba commented ·
what is the use of unsent log portion?
0 Likes 0 ·

2 Answers

·
ramesh 1 avatar image
ramesh 1 answered
check this blog monitoring SQL Server 2005 for database monitoring http://www.mssqltips.com/sqlservertip/1859/monitoring-sql-server-database-mirroring-with-email-alerts/
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

narendba avatar image narendba commented ·
Great one.. I have tested also it is giving the status of priciple and mirror databases... Do we have to check any other related information for daily monitoring purpose? Is there any commands for it? How to test the data or packets(latancy) are sending from principle and mirror server or fastness?
0 Likes 0 ·
Kev Riley avatar image
Kev Riley answered
This is another monitoring solution that I have implemented on a number of mirrors http://www.sqlservercentral.com/scripts/alerts/71731/ I'd also recommend [Robert Davis & Ken Simmons book Pro SQL Server 2008 Mirroring][1] [1]: http://www.amazon.com/Server-2008-Mirroring-Experts-Voice/dp/1430224231
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.