February 8, 2008 at 8:25 am
I need something that can help me to monitor my capacity for Database,Table,Index...
February 8, 2008 at 10:04 am
Take a look at sp_spaceused It will show how much actual space tables and indexes occupy. Even if your mdf data file is 100GB on disk, it may only contain 75GB of actual data. I also found a table that gives me a true record count of customer records. In a relational database all of your tables might total 10 million records but there may actually only be 3 million customer records. If you take the actual size of your data file and divide by the number of truly unique customer records you get a rough idea of size per record. So if you know you'll be adding 5 million records this year you can get a rough forecast of disk space growth etc. Also take into account how much space your backups and / or log shipping server need.
February 8, 2008 at 10:14 am
as standard you can call these sprocs
exec sp_helpdb
exec sp_spaceused
and in SSMS (SQL2005-SP2) you can right-click on your db, Reports, StandardReports
- a useful screenshot of numbers but not easy to persist for long-term trends etc
You could take a look at the SCCM, SCOM products
Systems Center Configuration Manager 2007 (SCCM)
Systems Center Operations Manager 2007 (SCOM)
there is a 180-day trial so won't cost you to take a look !
http://www.microsoft.com/systemcenter/opsmgr/evaluation/default.mspx
HTH
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply