Disk Performance

• EvilPostIT

  SSCrazy

  Points: 2578

  More actions

  November 20, 2007 at 9:41 am

  #119623

  Does anyone know of any good resources to find out more about # of Data files per CPU. Ie why it actually improves performance, how data is written in this configs, recomended hardware configs for this approach.

  Thanks

  ---

  
  Nuke the site from orbit, its the only way to be sure... :w00t:

• Jo Pattyn

  SSC-Dedicated

  Points: 32347

  More actions

  November 21, 2007 at 4:40 am

  #753035

  Have a look at:

  http://www.sql-server-performance.com/tips/filegroups_p1.aspx

  http://sqlblogcasts.com/blogs/tonyrogerson/archive/2006/08/17/948.aspx