Table of all mdf+ldf growths and dates
staggerlee
Member Posts: 90 ■■□□□□□□□□
Hi all,
Anyone know if theres a way to get a list of all the databases file growths and dates.
I found the Standard Report on Disk Usage (Right clicking a database -> Standard Reports -> Disk Usage) and it gives me everything i want. I just want it for all the databases at once instead of doing each one at a time. I figured the data must be in there somewhere. But no idea where!
Any ideas?
Anyone know if theres a way to get a list of all the databases file growths and dates.
I found the Standard Report on Disk Usage (Right clicking a database -> Standard Reports -> Disk Usage) and it gives me everything i want. I just want it for all the databases at once instead of doing each one at a time. I figured the data must be in there somewhere. But no idea where!
Any ideas?
Comments
-
RobertKaucher
Member Posts: 4,299 ■■■■■■■■■■
staggerlee, sorry. I thought I had already responded:
How to track database file growth over a period of time? : Narayana Vyas Kondreddi's homepage
Download his stored procedure and you can use it. -
staggerlee
Member Posts: 90 ■■□□□□□□□□
awesome as always sir!
Im trying to get the the data and log files resized to decent sizes (loads of shrinking and autogrowth going on, or totally the other way and having a 15gb file for 3gb of actually data??
With monitoring a live server, ive set up a temp db on the server, to run some SP that fill some tables so i can get a overview of it all. Would you say thats a good idea or just have a SP and sent that data via email/ input it to excel to get the details.
thanks again! -
RobertKaucher
Member Posts: 4,299 ■■■■■■■■■■
Sounds tight to me. That way you can easily track teh historical data.