Post reply

Analyzing Disk Capacity for SQL Server

  • 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

     

  • 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....  

  • 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.

Viewing 3 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply