December 19, 2001 02:19 PM

Tracking Automatic Growth of Database Files

Rating: (0)
SQL Server Magazine
InstantDoc ID #23232

I'm running SQL Server 2000 and have set my database file to automatically grow as much as 10 percent when it needs the extra space. One of the databases has grown several times. How can I see when the growth occurred and how much the database grew each time?

I don't know of a simple way to get these answers after the files have grown. However, I agree that the information would be valuable, and I hope Microsoft will add a way to access the information in a future SQL Server re...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Using DMO is a good method.

Juan Pablo López Aguilar 4/2/2002 7:00:18 PM


You must log on before posting a comment.

Are you a new visitor? Register Here