Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mazher
Starting Member
2 Posts |
 Posted - 2014-02-06 : 01:32:45
|
| I have created a database in Dec, 2012 now the size of database is 1 TB. Now we want to add more resources but before this we want to know that last 1 year what is the size of DB in each month. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-02-06 : 07:19:01
|
| If you are performing regular backups,this might give the database backup sizes moth wiseSELECT[database_name] AS "Database",DATEPART(month,[backup_start_date]) AS "Month",AVG([backup_size]/1024/1024) AS "Backup Size MB",AVG([compressed_backup_size]/1024/1024) AS "Compressed Backup Size MB",AVG([backup_size]/[compressed_backup_size]) AS "Compression Ratio"FROM msdb.dbo.backupsetWHERE [database_name] = ''AND [type] = 'D'GROUP BY [database_name],DATEPART(mm,[backup_start_date]);Also check this one:http://www.sqlservercentral.com/Forums/Topic493130-146-1.aspxJaveed Ahmed |
 |
|
|
mazher
Starting Member
2 Posts |
|
|
|
|
|
How to check history of database size month wise?