Post reply

How to estimate Database growth?

  • February 22, 2007 at 5:41 am

    #115717

    Hi,

    I'm knew to sql server administration, I've been asked to come up with a document estimating the database for the next 12 months.

     

    Please help.

  • February 22, 2007 at 9:22 am

    #691199

    Check it out in books online.

     

    http://msdn2.microsoft.com/en-us/library/aa933054(sql.80).aspx

     

  • February 22, 2007 at 2:52 pm

    #691260

    I run the following query on a daily basis and store the information into a DatabaseFileUsage Table.  

    I then export the data to excell and track file sizes over time. 

    EP 

     

    declare

    @server sysname

    select

    @server = name from sys.servers

    where

    server_id = 0

    --insert into DatabaseFileUsage

    select

    @server as 'ServerName',

    d

    .name as 'DBName',

    f

    .name as 'LogicalName ',

    f

    .physical_name as 'FileName',

    f

    .size / 128 as 'DBSize_MB' ,

    getdate() as 'TraceDate'

    from

    sys.master_files f

    join

    sys.databases d on d.database_id = f.database_id

  • February 22, 2007 at 11:30 pm

    #691315

    If your company interested to spend money then there are some third party tools out there for trend analysis and capcity planning...

    Otherwise Eric solution is the better one...I use similar method at this time...

     

    MohammedU
    Microsoft SQL Server MVP

Viewing 4 posts - 1 through 3 (of 3 total)

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