Re: Graphing Database Growth Rate

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 02/02/05 

Date: Wed, 02 Feb 2005 00:01:57 GMT

If I were in your shoes, the first thing I'd do is see if a PivotTable
(and Chart) do the job. Start with Data | PivotTable and PivotChart
Report...

One of the options you will see is to use an external database. Follow
the various dialog boxes and XL should do all the necessary
SQL/whatever work is needed to get you the data.

If that is not good enough, consider using Data | Import External Data
> and then either Import Data... or New Database query... This will
give you the data from your database in a XL work***. You can then
analyze it in various ways. 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <#QMZR5KCFHA.1004@TK2MSFTNGP15.phx.gbl>, spam@spam.net 
says...
> Hello, all -- I have a job that grabs the size of each SQL Server database 
> and log file size and saves one row per database into a table.  I run this 
> routine on a daily basis, so I basically grab the size each day and can 
> monitor growth.
> 
> The table data is below.
> 
> What I would like to do is have a SQL Query setup to graph the data in Excel 
> to show the growth rate of each database by week, month, year.
> 
> I'm not sure the best way to do the SQL and the best way to do the graph. 
> Since new databases are created all the time, new rows will appear in the 
> output -- so creating specific graphs for each database may not be ideal... 
> so I'm hoping someone could help me.
> 
> Essentially, I want a graph of:
> 
> By Week -All Databases (DB274, DB332, DB344, etc) showing the start size and 
> the end size within a specified period.
> By Month - All Databases (DB274, DB332, DB344, etc) showing the start size 
> and the end size within a specified period.
> By Year - All Databases (DB274, DB332, DB344, etc) showing the start size 
> and the end size within a specified period.
> 
> I woudl then like to graph each database individually showing its individual 
> growt as:
> By Week - DB274
> By Month - DB274
> By Year - DB274
> 
> Then again another by Week, Month, Year for each remaining database.
> 
> I figure I'll need a separate query for the Week, Month, Year for all 
> databases.  Then separate queries for the Week, Month, Year for each 
> individual database.
> 
> How to have this in Excel for graphing is another big question for me. 
> Obviously, as new databases come on... I do not want to have to remember and 
> add/create a new graph.  (If this is required, fine... I'm just trying to 
> find a dynamic solution here.)
> 
> Here is all my data that I've been collecting each data starting 12/17/04 
> thru 02/01/05.
> 
> Any help or pointers would be appreciated greatly.
> 
> ID          RECORD_TYPE DBNAME 
> DATA_SIZE   DATA_USED   LOG_SIZE    LOG_USED    STAT_DATE
> ----------- ----------- -------------------------------------------------- ----------- 
>  ----------- ----------- ----------- ------------------------------------------------------
> 2           1           DB274 
> 15670.00    15517.00    3.49        .40         2005-01-17 13:59:10.477
> 36          1           DB274 
> 15670.00    15518.00    .99         .62         2005-01-18 08:00:11.637
> 70          1           DB274 
{snip}
Quantcast