Analyzing Disk Capacity for SQL Server

• Soonyu-163551

  SSC Eights!

  Points: 811

  More actions

  July 24, 2006 at 9:59 pm

  #651243

  maybe my question bit out from your discussion.

  but I keeping asking this question myself

  in article, it mention for disk throughput capacity, we should monitor physical disk counter, disk read bytes/sec, disk write bytes/sec.

  my question is should we take physical disk counter /logical disk counter?

  any why. we need take physical disk counter instead of logical disk counter?

  --soonyu

   

• jeep44

  Valued Member

  Points: 73

  More actions

  July 4, 2007 at 6:56 am

  #717144

  This article is great, now i just need to convince make my IT to be more concious....  

• cy.harrild

  SSC Enthusiast

  Points: 111

  More actions

  January 6, 2008 at 10:59 pm

  #765225

  Just some ambiguity there. Your example of linear growth is incorrect. You state that the database starts at 100GB and grows at 10% per year for 2 years. That gives it a size of 100 * 1.1 = 110GB for the end of the first year and 110 * 1.1 = 121GB for the end of the second year. Percentage growth plans are always exponential, never linear. If your target growth is by a certain number of MB (or GB) per year then the growth plan should be specifiying MB (or GB) and not a percentage.