Post reply

sp_monitor

  • September 7, 2016 at 11:33 am

    #329945

    Hi

    Can you please suggest in which situation does it make sense to run:

    USE [user_db/anydb]

    EXEC sp_monitor

    What is my benefit of using such internal SP?

    Thanks.

  • September 9, 2016 at 12:23 pm

    #1900134

    SQL-DBA-01 (9/7/2016)

    Hi

    Can you please suggest in which situation does it make sense to run:

    USE [user_db/anydb]

    EXEC sp_monitor

    What is my benefit of using such internal SP?

    It gives you a quick view of how busy SQL Server is. The benefit to you would depend on the system, what you are monitoring, etc. With the DMVs and such, you can often quickly get more information tailored to what you need using other scripts.

    Sp_monitor is an older built in system procedure, going back to the Sybase days when there wasn't much in terms of what you could query to monitor the system. Things have changed a lot since then and I don't think it's used much anymore.

    Sue

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply