Post reply

database IO?

  • March 6, 2014 at 12:36 am

    #289119

    Hi,

    Is there a simple way to measure the database IO throuput?

    I have the feeling that we have sometimes serious IO performance issues.

    10% of our WAITs are Buffer IO Wait Types (PAGEIOLATCH_SH,-EX,-UP), 25% of our WAITs are CXPACKET Waits

    I'm looking for a simple way to measure the current IO, what is the best approach?

    According to figures (e.g.Page reads/sec, Page writes/sec), in general what would you say is good, acceptable and absolutly worse?

    thank you for your help!

    Ralf

  • March 6, 2014 at 1:28 am

    #1694558

    I'd probably start with the Virtual File Stats DMV.

    Good, acceptable and worse for IO volumes is completely dependent on your hardware and application, there's no universal figure for how many IOs is too many.

    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

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

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