Post reply

How to fing I/O via DMV

  • January 12, 2009 at 3:52 am

    #126591

    Hi All

    Is there any way to find the average I/O per transcation from DMV's, i have seem total reads and writes from a database from DMV, and this is been used on performance dashborad. can any one help me to figure out how to find out I/O per transcation (x Milliseconds/trans), and how much time is considered the best. 😀

    Thanks in advance 🙂

  • January 12, 2009 at 6:37 am

    #925226

    maybe what you're looking for and what you're asking for are not the same? io/transaction where "transaction" is just a measure without any related substance would just give you another counter unrelated to performance other than being able to plot it up and down.

    io per query, statement, batch, sp, rpc is far more relevant and easy to extract, mostly through profiler - first ask what it is you wish to accomplish, then why, then will it actually add any value? I figure you're probably looking for a "golden bullet" which will tell you exactly how your server is running?

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 12, 2009 at 6:50 am

    #925232

    Thanks Colin, i need this to measure my SAN performance and test if i am getting the same performance on the new SAN, i know this will not be accurate on dmv, but this will give me a approx idea of my present i/o and then check this on new SAN, i can see this by waits, It will be good to find out I/O for each statement as u said, is there any other easier way to do this??

  • January 12, 2009 at 12:52 pm

    #925507

    ah .. you mentioned the "S" word !!!! Have a read through my blog on San testing http://sqlblogcasts.com/blogs/grumpyolddba/default.aspx

    Most disk counters don't work on a san, but io latency does and that will be one of your biggest indicators of poor performance.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • January 13, 2009 at 8:22 am

    #925923

    Thanks Colin, that's right the 'S' word, where i got stuck,i will read the post and let you know 🙂

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

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