June 20, 2011 at 2:35 am
Hi,
Is there any way we can measure how much is the database growth in last one hour if the database size is not captured before one hour?
Ryan
//All our dreams can come true, if we have the courage to pursue them//
June 20, 2011 at 5:29 am
Sumanta Roy (6/20/2011)
Is there any way we can measure how much is the database growth in last one hour if the database size is not captured before one hour?
No that I know but, size of full backup gives a good idea of growth by comparing dump sizes and size of t-log backups gives a good idea about i/o activity - the former, in an insert bound database will allow to infer database growth.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 20, 2011 at 11:03 am
Sumanta Roy (6/20/2011)
Hi,Is there any way we can measure how much is the database growth in last one hour if the database size is not captured before one hour?
I am assuming you had some auto-growth in your DB files and that you;re not looking to find out if someone manually grew the files.
I am also going to assume that the autogrow settings on your databases have not changed in the last hour.
If those are both true then you can look in the default trace for autogrow events that occurred in the last hour and do the math going back in time using the current size of your database files and the autogrow settings to figure out how much the files grew during that time.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply