calculating sql server 2005 statistics...

Hi every one and greg,

We planning and estimating the sql server expiration or need to upgrade is there any thing in sql server so that i can calculate following things.

Growth of databases hosted on server

Average number of connection that being process in working times/hours

Average hardware consumption (like cups ram hard disk)

We need theses stats for projections.

Is there any thing in sql server 2005?

thanks in advance

I'm not aware of any inbuilt functions that can be used to return historic database growth. This is something that you will have to implement manually.

You could create a SQL Agent job to run every day to execute 'DBCC showfilestats' against each of your databases and log the results into a table. This will allow you to get an idea of your database's growth pattern, but it will take time to build a set of data that can be reliably used to predict database growth.

The number of connections, CPU usage, RAM and disk usage (and a whole lot of other useful counters) can be monitored using 'Perfmon' and the results can be logged into a SQL Server database for future analysis. Bear in mind that for the counter objects that you have specified, Perfmon will monitor all activity on the server rather than just specifically activity relating to SQL Server.

Here are a couple of links to help get you started with Perfmon:

http://www.computerperformance.co.uk/HealthCheck/index.htm

http://support.microsoft.com/kb/296222

Chris

|||

thank you Chris, I have written some procedures that will collects other stats like CPU usage, RAM and disk usage and thinking that execute this procedure after a specified interval and store result in a historical table. What you thinks it will better and if yes then how much time interval should?