Any way to be notified if database grows?

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 to
rule out database growth.
TYIA
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...
> 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 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* 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 MVPhttp://www.karaszi.com/sqlserver/default.asphttp://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 to
>rule out database growth.
You could write a short app that checks the .mdf filesize every five
seconds or so.
J.

Any way to be notified if database grows?

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 to
rule out database growth.
TYIAYou 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...
> 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 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...
> > 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 to
> > rule out database growth.
> >
> > TYIA
>|||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...
> 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...
>> > 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 to
>> > rule out database growth.
>> >
>> > TYIA
>>|||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* 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 MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
> "RobinMC" <Robi...@.discussions.microsoft.com> wrote in message
> news:3AC5067C-9E8D-4564-BDD9-1F365BB8661D@.microsoft.com...
>
> > 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" <Robi...@.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 happened?
> >> > Our customers are complaining of "random" poor performance - I would like to
> >> > rule out database growth.
> >> > TYIA- Hide quoted text -
> - 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 to
>rule out database growth.
You could write a short app that checks the .mdf filesize every five
seconds or so.
J.

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.

Any problem for using a single data file?

Hi there,
Is there any problem using 1 data file with restricted file growth
set to 20GB? I've heard that it's better to have multiple data files with
2GB each. Is that true?
Thanks!
AlexThat was true for Win95/98 and FAT file partitions. If you are using
Win2000 or higher and NTFS, the 20 GB single file is just fine.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Alex Cheng" <acheng@.qtcm.com> wrote in message
news:uQisgrEkEHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> Is there any problem using 1 data file with restricted file growth
> set to 20GB? I've heard that it's better to have multiple data files with
> 2GB each. Is that true?
> Thanks!
> Alex
>|||Unless you're splitting filegroups up in order to put them on different
physical devices, there is, IMO, little benefit in creating multiple data
files. All it will accomplish is creating more of a maintenance headache
for you.
"Alex Cheng" <acheng@.qtcm.com> wrote in message
news:uQisgrEkEHA.1404@.TK2MSFTNGP09.phx.gbl...
> Hi there,
> Is there any problem using 1 data file with restricted file growth
> set to 20GB? I've heard that it's better to have multiple data files with
> 2GB each. Is that true?
> Thanks!
> Alex
>|||Hello Alex
It depends on what you are trying to achieve. There is no set requirement
or recommendation either way. However creating a lot of small files for a
database could lead to additional maintenance chores. From performance
standpoint, there should really be no difference either way unless you
achieve stripping with multiple database files across several disk
controllers and drives. However for a database of about 20GB in size, this
striping may only give you small performance benefit.
Thank you for using Microsoft newsgroups.
Sincerely
Pankaj Agarwal
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Thanks for the information. I'm really appreciated.
alex
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uBkGIFFkEHA.1348@.TK2MSFTNGP15.phx.gbl...
> That was true for Win95/98 and FAT file partitions. If you are using
> Win2000 or higher and NTFS, the 20 GB single file is just fine.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
> I support the Professional Association for SQL Server
> www.sqlpass.org
> "Alex Cheng" <acheng@.qtcm.com> wrote in message
> news:uQisgrEkEHA.1404@.TK2MSFTNGP09.phx.gbl...
> > Hi there,
> >
> > Is there any problem using 1 data file with restricted file
growth
> > set to 20GB? I've heard that it's better to have multiple data files
with
> > 2GB each. Is that true?
> >
> > Thanks!
> >
> > Alex
> >
> >
>|||Got it. Thanks!
alex
"Adam Machanic" <amachanic@.hotmail._removetoemail_.com> wrote in message
news:ej7SNGFkEHA.704@.TK2MSFTNGP09.phx.gbl...
> Unless you're splitting filegroups up in order to put them on different
> physical devices, there is, IMO, little benefit in creating multiple data
> files. All it will accomplish is creating more of a maintenance headache
> for you.
>
> "Alex Cheng" <acheng@.qtcm.com> wrote in message
> news:uQisgrEkEHA.1404@.TK2MSFTNGP09.phx.gbl...
> > Hi there,
> >
> > Is there any problem using 1 data file with restricted file
growth
> > set to 20GB? I've heard that it's better to have multiple data files
with
> > 2GB each. Is that true?
> >
> > Thanks!
> >
> > Alex
> >
> >
>|||Thanks!
alex
"Pankaj Agarwal [MSFT]" <pankaja@.online.microsoft.com> wrote in message
news:ecnxtZHkEHA.2516@.cpmsftngxa10.phx.gbl...
> Hello Alex
> It depends on what you are trying to achieve. There is no set requirement
> or recommendation either way. However creating a lot of small files for a
> database could lead to additional maintenance chores. From performance
> standpoint, there should really be no difference either way unless you
> achieve stripping with multiple database files across several disk
> controllers and drives. However for a database of about 20GB in size, this
> striping may only give you small performance benefit.
> Thank you for using Microsoft newsgroups.
> Sincerely
> Pankaj Agarwal
> Microsoft Corporation
> This posting is provided AS IS with no warranties, and confers no rights.
>