Post reply

Read RESOURCE MONITOR?

  • April 21, 2010 at 2:14 pm

    #223729

    Hi,

    I want to monitor my SQL server better. When running sp_who2, I see that RESOURCE MONITOR is always running... does it store its data somewhere for me as DBA to read?

    Thanks,

    Raymond

  • April 21, 2010 at 2:54 pm

    #1155687

    Hi Raymond

    This process is might be associated with RESOURCE GOVERNER, that is

    new feature in SQL2008 for better resource utilization.

    Regards,

    Nitin Gupta

    Thanks & Regards,

    Nitin Gupta
    SQl Server (7.0,2000,2005) - Sr. DBA
    HCL Technologies, India

  • April 21, 2010 at 3:20 pm

    #1155710

    What do you want to monitor? Fortunatly sql stores all sorts of interesting things about itself that you have access to query.

  • April 22, 2010 at 1:22 am

    #1155884

    m

  • April 22, 2010 at 1:33 am

    #1155887

    To be honest I would like to monitor everything 🙂

    More specific for now: (history of) CPU utilisation and (history of) resources stored procedures used

    We have lots of stored procedures running and a steady growth of customers.... we want to keep performance at its best.

    All database queries go through stored procedures.

    Thanks,

    Raymond

Viewing 5 posts - 1 through 4 (of 4 total)

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