Tracking DB grows

Question

Post reply

Tracking DB grows

Tmp

SSCommitted

Points: 1938
More actions
November 25, 2003 at 6:14 am

#59858

Hi all! i'm looking for a way to track the automatic db grows. I was checking the server log, but nothing appears there...

Viewing 15 posts - 1 through 15 (of 17 total)

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

mngong SSCertifiable Points: 6167 More actions · Answer 1

mngong

SSCertifiable

Points: 6167

November 25, 2003 at 6:56 am

#483529

Manually sp_spaceused should be of use

Mike

Tmp SSCommitted Points: 1938 More actions · Answer 2

sp_spaceused doesn't show dates, or changes in the space allocated

Frank Kalis SSC Guru Points: 111183 More actions · Answer 3

I would search this site.

I'm pretty sure that I have seen several threads in the past on the same topic.

I'll post them when I find the links.

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

What about this one?

http://www.sqlservercentral.com/scripts/contributions/108.asp

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

amitelman SSC Enthusiast Points: 180 More actions · Answer 5

This might show database growing trend.

select backup_finish_date,database_name, backup_size from msdb..backupset where type='D'

Steen Molberg Valued Member Points: 55 More actions · Answer 6

Hi everybody,

I wanted to attach a script for tmp on trach db growth and diskspace but it seems that it's not possible to attach files. I have posted the script in Maintenance and monitoring, but how can he get a hold on it there?

/Molberg

/Steen Molberg

/Molberg

Tmp SSCommitted Points: 1938 More actions · Answer 7

Maybe my original request wasn't enough clear (my English sucks). What i really need to check is the growth in the data files produced by the 'Automatic grow file' option, not the database data itself.

Sorry all for the confusion.. 🙁

Frank Kalis SSC Guru Points: 111183 More actions · Answer 8

Now you've got me confused.

You want to know how many MBs or GBs did you database grow last time autogrow did occur?

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Steen Molberg Valued Member Points: 55 More actions · Answer 9

But that is the only way the a db grows unless you do it manually.

/Molberg

James Luetkehoelter SSCommitted Points: 1733 More actions · Answer 10

This is a great question! I think what you're looking for is some sort of event that is fired when the autogrow kicks in -- is that correct? With dates and times, you could compare performance dips with autogrow times. I know there is a performance counter for log growth and shrink events, but I can't find one for database growth events. I'm going to keep looking though, and I'll bet there's a system view in Yukon that would provide this.

Personally, I leave autogrow on, but I never let it execute. I measure the rate of growth and pre-allocate space as necessary.

If I find more, I'll repost.

J.

Steen Molberg Valued Member Points: 55 More actions · Answer 11

OK I think I got it - Tmp.

My script reports on pagesize and usedpages for each filegroup and log + reports on freespace on each drive + pages used for each table and index.

/Molberg

Tmp SSCommitted Points: 1938 More actions · Answer 12

Thats correct lubenfarber, unfortunately i'm not working with Yukon yet :)))

Frank, the question isn't 'how many', is 'when'. Some kind of log or warning that show me the date/time of an autogrow event...

Frank Kalis SSC Guru Points: 111183 More actions · Answer 13

Still, little confused.

You mean when the last autogrow occured or when the next one will occur?

If you're looking for the last one, this might help http://www.sqlservercentral.com/forum/link.asp?TOPIC_ID=12368

Frank

http://www.insidesql.de

http://www.familienzirkus.de

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

Tmp SSCommitted Points: 1938 More actions · Answer 14

Tmp

SSCommitted

Points: 1938

November 27, 2003 at 7:34 am

#483928

When the last autogrow occured