Any way to be notified if database grows?

Our databases are configured for automatic growth by varying increments of M
B.
Is there a way (an alert?) to find out when the growth has actualy happened?
Our customers are complaining of "random" poor performance - I would like to
rule out database growth.
TYIAYou can catch it using a Profiler trace. And probably also using an event no
tification (see CREATE
EVENT NOTIFICATION), if you are on 2005.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:EA3B1E1E-9A31-4C7D-B3F0-89B32CAD431F@.microsoft.com...
> Our databases are configured for automatic growth by varying increments of
MB.
> Is there a way (an alert?) to find out when the growth has actualy happene
d?
> Our customers are complaining of "random" poor performance - I would like
to
> rule out database growth.
> TYIA|||Thank you for your response.
Unfortunately, we are sill on 2000.
Are there any alerts SQL that would capture this?
Any way to write to the Event logs?
I don't know when it will happen and can't have a trace running 24 x 7.
Thank you .
"Tibor Karaszi" wrote:

> You can catch it using a Profiler trace. And probably also using an event
notification (see CREATE
> EVENT NOTIFICATION), if you are on 2005.
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://sqlblog.com/blogs/tibor_karaszi
>
> "RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
> news:EA3B1E1E-9A31-4C7D-B3F0-89B32CAD431F@.microsoft.com...
>|||No and no, I'm afraid. It isn't a big deal to have a *server side* profiler
trace running
continually. Of you can poll for the file size as frequently as you need and
based on that log when
you notice a change in size.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"RobinMC" <RobinMC@.discussions.microsoft.com> wrote in message
news:3AC5067C-9E8D-4564-BDD9-1F365BB8661D@.microsoft.com...[vbcol=seagreen]
> Thank you for your response.
> Unfortunately, we are sill on 2000.
> Are there any alerts SQL that would capture this?
> Any way to write to the Event logs?
> I don't know when it will happen and can't have a trace running 24 x 7.
> Thank you .
> "Tibor Karaszi" wrote:
>|||On Aug 15, 9:45 pm, "Tibor Karaszi"
<tibor_please.no.email_kara...@.hotmail.nomail.com> wrote:
> No and no, I'm afraid. It isn't a big deal to have a *server side* profile
r trace running
> continually. Of you can poll for the file size as frequently as you need a
nd based on that log when
> you notice a change in size.
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asph
ttp://sqlblog.com/blogs/tibor_karaszi
> "RobinMC" <Robi...@.discussions.microsoft.com> wrote in message
> news:3AC5067C-9E8D-4564-BDD9-1F365BB8661D@.microsoft.com...
>
>
>
>
>
>
>
> - Show quoted text -
Instead of a profiler trace, start a perfmon (administrative tools-
>performance) trace on the server, tracing the following counters:
Performance Object: MsSQL:Databases
Counters: Data File Size KB, Log File Size KB
Instances: Select the appropriate database(s) that you'd like to
collect.
A relatively low sampling interval (once per every minute or few)
should be enough to give you the data that you're looking for.
Whenever any of these counters increase, you'll know that a file
growth occured and the amount that the file was expanded.
MS|||On Wed, 15 Aug 2007 13:10:01 -0700, RobinMC
<RobinMC@.discussions.microsoft.com> wrote:

>Our databases are configured for automatic growth by varying increments of
MB.
>Is there a way (an alert?) to find out when the growth has actualy happened
?
>Our customers are complaining of "random" poor performance - I would like t
o
>rule out database growth.
You could write a short app that checks the .mdf filesize every five
seconds or so.
J.