SQLIO - simple system performance for SQL Server

• Alan Spillert

  SSCommitted

  Points: 1964

  More actions

  December 29, 2008 at 8:36 am

  #203292

  Microsoft SQLIO Disk Subsystem Benchmark Tool

  http://www.microsoft.com/DOWNLOADS/details.aspx?familyid=9A8B005B-84E4-4F24-8D65-CB53442D9E19&displaylang=en

  has been very useful in comparing different disk IO systems. I've seen values between 600 on my desktop PC and 8000 on a SAN, and SQL Server seems to perform in proportion to these benchmarks.

  Alan

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  December 29, 2008 at 9:36 am

  #918439

  You should probably add this as a reply to an existing thread.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]