Home Forums SQL Server 2008 SQL Server Newbies do the amount of disks on a machine affect SQL's performance RE: do the amount of disks on a machine affect SQL's performance

  • In general, more disks can improve performance, not generally hurt it. But, you also have to have more controllers to really achieve meaningful benefits. In general, based on what you're saying, I would not assume that you should see performance degradation from just those few disks. I'd suspect the problem is elsewhere.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning