tools to track disk or folder used space

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 High Availability » tools to track disk or folder used space

tools to track disk or folder used space

Rate Topic

Display Mode

Topic Options

Author

Message

sqlfriends

Posted Wednesday, December 05, 2012 11:10 AM

SSCommitted

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 1,605, Visits: 2,783

I would like to know the size increase rate of a disk drive that stores database backups.

I have overheard from some network people they have a tool to check that, for example to find out in last year- each month what is the size increase of the drive/folder.

Anyone knows what the tool is?

Thanks

Post #1393139

anthony.green

Posted Thursday, December 06, 2012 3:11 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

You could just query the backupset table and get the space of the backups that way, unless the drive/folders also store none backup files.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1393395

Joie Andrew

Posted Thursday, December 06, 2012 7:02 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 12:52 AM
Points: 548, Visits: 1,023

Couldn't monitoring tools such as SCOM accomplish what you are trying to do?

Joie Andrew
"Since 1982"

Post #1393500

Chris Becker

Posted Thursday, December 06, 2012 2:17 PM

SSC Veteran

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:49 AM
Points: 220, Visits: 216

We capture size a different way, however you can use backup_size in backupset, write to a dim/fact table and build a cube off of. Then drop in an excel pivot table to drive a nice chart showing growth over time..

Regards,
Chris
mssqlconsulting.com

Post #1393751

vikingDBA

Posted Friday, December 07, 2012 6:58 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:19 AM
Points: 189, Visits: 863

I found this software back in the summer. Has a 15 day free trial. I installed it for testing and it was nice. You can see if it will do what you are wanting.

http://www.foldersizes.com/index.htm

(I have no affiliation with the software company.)

Post #1394045

« Prev Topic | Next Topic »

Permissions