Q:Data file/log file growth

Sorry for the cross post but I really would need an answer to this as soon
as possible.
Two questions:
1. How can I know how many times and what dates etc a database file with
automatic growth either in percent or in megabyte has grown?
2. If I specify to automaticly grow by 10 percent. Will the file then each
time grow with 10 percent of the original file size (when created) or with
10 percent of the current size?
/Peter> Sorry for the cross post but I really would need an answer to this as soon
> as possible.
So because you are urgent, that somehow makes your question relevant for
programming, setup, msde and tools? Did you also cross-post to the BMW,
Oracle, and LOTR newsgroups? ;-)
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/|||I´m sorry but I see no need for arrogans.
I had been better of with an answer to my questions but maybe these ones
were kind of tricky... ;-)
Regards /Peter
"Aaron Bertrand - MVP" <aaron@.TRASHaspfaq.com> wrote in message
news:OcoU9BBxDHA.3816@.tk2msftngp13.phx.gbl...
> > Sorry for the cross post but I really would need an answer to this as
soon
> > as possible.
> So because you are urgent, that somehow makes your question relevant for
> programming, setup, msde and tools? Did you also cross-post to the BMW,
> Oracle, and LOTR newsgroups? ;-)
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>|||For the second (from BOL)
When % is specified, the growth increment size is the specified percentage
of the size of the file at the time the increment occurs.
For the first.
Not sure of any stored data for this (doesn't say that it doesn't exist) but
at least for the number of growths you could calculate from start DB size +
growth % (assumes no shrinks)
Dave
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter" <peter@.dsds.com> wrote in message
news:OH0%231rAxDHA.2356@.TK2MSFTNGP12.phx.gbl...
> Sorry for the cross post but I really would need an answer to this as soon
> as possible.
>
> Two questions:
> 1. How can I know how many times and what dates etc a database file with
> automatic growth either in percent or in megabyte has grown?
> 2. If I specify to automaticly grow by 10 percent. Will the file then each
> time grow with 10 percent of the original file size (when created) or with
> 10 percent of the current size?
> /Peter
>|||You could use the DataFileAutoGrow/LogFileAutoGrow event
class under the Database event category to trace the
automatic growth of your data/log files. Personally, I
don't think this is a good solution. It's a bit like
shooting a fly with cannon.
I think a better solution would be for SQL Server to log
an entry in the errorlog when an auto growth takes place.
It would be even better if SQL Server could provide a
switch to control whether such an entry is written to the
errorlog.
Linchi
>--Original Message--
>Sorry for the cross post but I really would need an
answer to this as soon
>as possible.
>
>Two questions:
>1. How can I know how many times and what dates etc a
database file with
>automatic growth either in percent or in megabyte has
grown?
>2. If I specify to automaticly grow by 10 percent. Will
the file then each
>time grow with 10 percent of the original file size (when
created) or with
>10 percent of the current size?
>/Peter
>
>.
>|||> I´m sorry but I see no need for arrogans.
I see this far too often.
"Well, my question is really important, or my problem is really urgent. I
couldn't be bothering figuring out which group it belonged in, or I wanted
to get the widest even remotely relevant audience possible. So I just
blasted it to every group with SQL Server in its name."
Which translates, roughly, to "... because my question is more important
than everyone else's."
So, IMHO, the arrogance lies elsewhere...
--
Aaron Bertrand
SQL Server MVP|||> 1. How can I know how many times and what dates etc a database file with
> automatic growth either in percent or in megabyte has grown?
There's a profiler event methinks for this. Or download the util proc from www.dbmaint.com which you
can run as a job at desired interval and will email you each time the db file is bigger than on last
execution.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
"Peter" <peter@.dsds.com> wrote in message news:OH0%231rAxDHA.2356@.TK2MSFTNGP12.phx.gbl...
> Sorry for the cross post but I really would need an answer to this as soon
> as possible.
>
> Two questions:
> 1. How can I know how many times and what dates etc a database file with
> automatic growth either in percent or in megabyte has grown?
> 2. If I specify to automaticly grow by 10 percent. Will the file then each
> time grow with 10 percent of the original file size (when created) or with
> 10 percent of the current size?
> /Peter
>