Post reply

DMV to know my workload type

  • May 19, 2014 at 12:49 am

    #307474

    Hi Everyone,

    Just wanted to know if there is a DMV through I can able to tell that my workload type is 'ad hoc'?

    Any help would be appreciated.

    Thank you.

  • May 19, 2014 at 1:36 am

    #1714531

    For workload what are the things would like to monitor?

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • May 19, 2014 at 2:07 am

    #1714533

    I just wanted to know through DMV (if any), the most of workload is 'Ad hoc' type.

    Can we get this information from plan cache using any DMV?

  • May 19, 2014 at 3:57 am

    #1714553

    Check plan cache here[/url].

    Shawn Melton
    Twitter: @wsmelton
    Blog: wsmelton.github.com
    Github: wsmelton

  • May 19, 2014 at 4:54 am

    #1714575

    Shawn, thanks for pointing me to paul randal link.

    Thanks a ton.

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

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