Post reply

Timed DMV's?

  • June 19, 2012 at 11:50 pm

    #258341

    Hello

    I've used a number of DMVs in the past to tell me things like 'top 10 longest running queries', which are very useful. However we have a number of very large jobs which run over night, to be quite frank I don't care how long these take to run as long as they're finished by the morning. However they appear in the my 10 list. Is there a way of excluding them?

    I'm guessing not, and its just a case of extending the list and ignoring them.

    Thanks

    Jay

  • June 20, 2012 at 12:59 am

    #1503242

    A where clause that filters out the jobs based on their text or other characteristic? Otherwise SQL has no way of knowing that you don't want those in your top 10.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 20, 2012 at 1:26 am

    #1503251

    Thanks... yes I was thinking that - where possible. Just wondered if there was some DMV I haven't heard of, I know there are hundreds but rarely people use more than 10-20.

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

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