January 17, 2013 at 6:57 am
I have 2 requirements:
1. Find the growth of user databases over a period of time, say for last 3 or 6 months.
I found this script but am not very convienced with the result - http://gallery.technet.microsoft.com/scriptcenter/f1df9f50-9cd9-4c75-a8d9-e2faba6b8574
2. I need a script to find out how much time a particular job took over a period of time(Full backup job and differential backup job which are created using DB Maintenance plan)
January 17, 2013 at 9:12 am
Benki Chendu (1/17/2013)
1. Find the growth of user databases over a period of time, say for last 3 or 6 months.
I found this script but am not very convienced with the result - http://gallery.technet.microsoft.com/scriptcenter/f1df9f50-9cd9-4c75-a8d9-e2faba6b8574%5B/quote%5D
A backup will store used data space plus or minus some log activity while the backup is running so it's a pretty good indication of the growth of resting data over time, but not necessarily database file growth since there are many other factors besides the size of the resting data that can affect that. What are you going to do with the numbers?
2. I need a script to find out how much time a particular job took over a period of time(Full backup job and differential backup job which are created using DB Maintenance plan)
SQL Agent Job History should have it. You can also look in msdb.dbo.backupset for backup start and end dates and calculate the durations.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply