SQL Server Performance

Smaller disks <> more spindles which one is better for performance?

Discussion in 'Other SQL Server Blogs around the Web' started by Anonymous, Aug 10, 2007.

  1. Anonymous New Member

    I have gone through a question within the forums asking "smaller disks or more spindles" which is better for performance. The simple answer is more disks to handle the data growth and also mostly depends upon the number of transactons that are handled with a sensible normalization, as the transactions method &amp; the CHECKPOINT method are important to assess such information. Further if that database is currently in live and if you are looking to upgrade the hardware then the best option is to go...(<a href="http://sqlserver-qa.net/blogs/perftune/archive/2007/08/10/1347.aspx">read more</a>)<img src="http://sqlserver-qa.net/aggbug.aspx?PostID=1347" width="1" height="1">

Share This Page