Track Database growth

Question

Post reply

Track Database growth

sqlfriend

SSC Guru

Points: 52781
More actions
January 22, 2013 at 10:35 pm

#393995

Anyone knows a third party SQL sever monitor tool that has functionality that can track database file size growth?
Whoops, the topic should be track database growth, I don't have an option to change the topic

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Vegard Hagen Hall of Fame Points: 3078 More actions · Answer 1

Why do you need a third party tool?

The default trace run by SQL Server itself already tracks this for you right out of the box. 😉

Database growth that is. Whether the DBA grows or shrinks is an entirely different matter. 😛 😉

Kind regards,

Vegard Hagen
Norwegian DBA, occasional blogger and generally a nice guy who believes the world is big enough for all of us.
@vegard_hagen on Twitter
Blog: Vegards corner (No actual SQL stuff here - havent found my niche yet. Maybe some day...)

It is better to light a candle than to curse the darkness. (Chinese proverb)

Ant-Green SSC Guru Points: 113507 More actions · Answer 2

You could as well, depending how often you read the default trace and its limited storage space, create a custom proc which loops through the system tables and dumps the values into a table for you to compare on a day to day basis.

sys.master_files, size column would be the one to look at, remember to multiply it by 8 as size is number of pages, so size * 8 = size in KB

SQLQuest29 SSCrazy Eights Points: 8264 More actions · Answer 3

sqlfriends (1/22/2013)
Anyone knows a third party SQL sever monitor tool that has functionality that can track database file size growth?
Whoops, the topic should be track database growth, I don't have an option to change the topic

Agree with Vegard !

Also, you can refer to :

Erin's Post (Uses TSQL) : http://www.sqlservercentral.com/articles/baselines/96059/

-- or --

by Chad Miller (Uses Powershell) : http://www.sqlservercentral.com/articles/powershell/68011/

______________________________________________________________________________________________________________________________________________________________________________________
HTH !
Kin
MCTS : 2005, 2008
Active SQL Server Community Contributor 🙂

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

SQL Monitor from Red Gate will do this (and more). You can eval and see if it is valuable for you: https://www.red-gate.com/products/dba/sql-monitor/

Disclosure: I work for Red Gate

sqlfriend SSC Guru Points: 52781 More actions · Answer 5

Thanks all.

For default trace, there is one active trace file, is it overwritten whenever server is restarted?

I see you can track autogrowth of files in the default trace, but it didn't tell what size is?

I will explore the powershell script of Ched Miller.