Post reply

PerfMon & SQL MPA

  • July 27, 2012 at 7:59 am

    #264895

    Does anyone know of a PerfMon counter for the SQL MPA?

    I'm looking for a way to record the output of this query, on a regular basis like a PerfMon counter:

    select sum(multi_pages_kb)/1024.0 as multipage_mb

    from sys.dm_os_memory_clerks

  • July 27, 2012 at 8:06 am

    #1518538

    If I remember correctly, you can create a customer counter in System Monitor with your own query.

    John

  • July 27, 2012 at 8:20 am

    #1518546

    Is System Monitor a 3rd party tool?

  • July 27, 2012 at 8:24 am

    #1518548

    Maybe I'm using the wrong name - it's actually called Performance on my machine. It's what you referred to as PerfMon. Sorry, I should have checked before posting.

    John

  • July 27, 2012 at 8:33 am

    #1518553

    Do you know how to add a custom SQL query to PerfMon? I can't figure it out.

  • July 27, 2012 at 8:51 am

    #1518564

    The performance object is called SQLServer:User Settable and the counter is called Query. I can't remember how you get the query into the system and I'm afraid I don't have time to look into it right now, but you should be able to find some information if you search for it.

    John

  • July 27, 2012 at 9:12 am

    #1518580

    Cool, I will give it a shot. Thanks.

Viewing 7 posts - 1 through 6 (of 6 total)

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