April 19, 2012 at 11:55 pm
Hi,
I am working on database growth report schema wise. I have found sp_spaceused, but this is not given date wise report.
I am looking report schema wise where table and index column have showing for one month or week.
Following are the Ex i am looking for growth in one month (March 1 to March 31):
Schema Starting Current Size
Name Size(MB) Size(MB) Change(MB)
----- ------------- ------------- ------------
ALPS 37,542.06 47,542.06 10,000.00
SYS 1,001.00 2,001.00 1,000.00
Please suggest.
Thanks,
Neeraj
April 20, 2012 at 7:36 am
If you want those types of statistics you have to collect the data. In other words you would need to store all your data and certain periods (daily, weekly, monthly, whatever). Then you can create your query to show growth over time.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply