Database Growth Report - Date wise

Last Post 20 Apr 2012 07:24 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages Not Resolved
Neeraj
New Member
New Member

--
19 Apr 2012 09:44 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



rm
New Member
New Member

--
20 Apr 2012 04:47 AM
It reports at db and table level, you may need write own code for usage of schema.
gunneyk
New Member
New Member

--
20 Apr 2012 07:24 AM
I would suggest you look at the reports for the database such as space usage and space usage by top tables. You can right click on the database and choose reports to get to them. If you run profiler while you run the report it will show you the code it uses to get that size information which you can then customize to meet your needs.
You are not authorized to post a reply.

Acceptable Use Policy