Useful Database Mirroring System Stored Procedure

I was spelunking around SQL Server 2008 Books Online (BOL), and I ran into a system stored procedure called sp_dbmmonitorresults, which is very useful for keeping track of what is going on with any database mirroring sessions that you have set up.

Here is an example of how to call it:

    -- Get database monitoring history data using system SP
    EXEC msdb.dbo.sp_dbmmonitorresults N'ngfulltext1', 2, 1

You have to give it a database name, a somewhat cryptic number code indicating how many rows to return, and a flag indicating the update status. If you are not a member of the sysadmin fixed server role, the update flag will be ignored.

At any rate, if you are using database mirroring, this is a programmatic way to to get some very valuable monitoring information without opening the Database Mirroring Monitor tool in SSMS.

This entry was posted in SQL Server 2008. Bookmark the permalink.

2 Responses to Useful Database Mirroring System Stored Procedure

  1. Unknown says:

    http://www.ccnacertificationguide.com/Configuring_Dynamic_NAT.phphttp://www.ccnacertificationguide.com/Configuring_NAT_Overload_and_PAT.phphttp://www.ccnacertificationguide.com/Internet_Control_Message_Protocol.phphttp://www.ccnacertificationguide.com/FTP_and_TFTP.phphttp://www.ccnacertificationguide.com/MTU_and_Fragmentation.phphttp://www.ccnacertificationguide.com/ccna.phphttp://www.ccnacertificationguide.com/ccna_certification.phphttp://www.ccnacertificationguide.com/ccna_training.phphttp://www.ccnacertificationguide.com/ccna_security.phphttp://www.ccnacertificationguide.com/ccna_voice.phphttp://www.ccnacertificationguide.com/ccna_wireless.phphttp://www.ccnacertificationguide.com/ccna_course.phphttp://www.ccnacertificationguide.com/ccna_notes.phphttp://www.ccnacertificationguide.com/ccna_exam.phphttp://www.ccnacertificationguide.com/ccna_dumps.phphttp://www.ccnacertificationguide.com/ccna_books.phphttp://www.ccnacertificationguide.com/ccna_jobs.phphttp://www.ccnacertificationguide.com/ccna_class.phphttp://www.ccnacertificationguide.com/ccna_1.phphttp://www.ccnacertificationguide.com/ccna_dummy.phphttp://www.ccnacertificationguide.com/ccna_cbt.phphttp://www.ccnacertificationguide.com/ccna_brain_dump.phphttp://www.ccnacertificationguide.com/ccna_exam_question.phphttp://www.ccnacertificationguide.com/ccna_forum.phphttp://www.ccnacertificationguide.com/ccna_icnd_1.phphttp://www.ccnacertificationguide.com/ccna_icnd_2.phphttp://www.ccnacertificationguide.com/ccna_intro.phphttp://www.ccnacertificationguide.com/ccna_certification_kit.phphttp://www.ccnacertificationguide.com/ccna_lab.phphttp://www.ccnacertificationguide.com/ccna_online_training.phphttp://www.ccnacertificationguide.com/ccna_pdf.phphttp://www.ccnacertificationguide.com/ccna_practice_exam.phphttp://www.ccnacertificationguide.com/ccna_practice_test.phphttp://www.ccnacertificationguide.com/ccna_salary.phphttp://www.ccnacertificationguide.com/ccna_3_4.phphttp://www.ccnacertificationguide.com/ccna_self_study.phphttp://www.ccnacertificationguide.com/ccna_simulator.phphttp://www.ccnacertificationguide.com/ccna_study.phphttp://www.ccnacertificationguide.com/ccna_study_guide.phphttp://www.ccnacertificationguide.com/ccna_test.phphttp://www.ccnacertificationguide.com/ccna_test_question.phphttp://www.ccnacertificationguide.com/ccna_640_802.phphttp://www.ccnacertificationguide.com/ccna_tutorial.phphttp://www.ccnacertificationguide.com/ccna_640_801.phphttp://www.ccnacertificationguide.com/ccna_boot_camp.phphttp://www.ccnacertificationguide.com/cisco_ccna.phphttp://www.ccnacertificationguide.com/cisco_ccna_certification.phphttp://www.ccnacertificationguide.com/cisco_ccna_training.phphttp://www.ccnacertificationguide.com/ccent.phphttp://www.ccnacertificationguide.com/ccna-practice-exam-questions.php

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s