Expansion History

Is there any way of seeing when a databse se tto Autogrow last expanded and
by how much?Hi
Look at sysfiles system tables and compare it with the time.
Also you can run Profiler which has AutoGrow event to see when it kicks in.
"Firestarter" <Firestarter@.discussions.microsoft.com> wrote in message
news:6681C1A9-446B-454B-AB6C-398FC472BAC2@.microsoft.com...
> Is there any way of seeing when a databse se tto Autogrow last expanded
and
> by how much?
>|||Thanks for reply.
I've just had a look sysfiles. Not what I'm after. A sort of
"sysfilesHistory" would be good.
I want to be able to check, today, when the last time an Autogrow database
last grew. Don't want to run profiler indefinitely. Any other ideas?
"Uri Dimant" wrote:
> Hi
> Look at sysfiles system tables and compare it with the time.
> Also you can run Profiler which has AutoGrow event to see when it kicks in.
>
>
> "Firestarter" <Firestarter@.discussions.microsoft.com> wrote in message
> news:6681C1A9-446B-454B-AB6C-398FC472BAC2@.microsoft.com...
> > Is there any way of seeing when a databse se tto Autogrow last expanded
> and
> > by how much?
> >
> >
>
>|||Firestarter
What is wrong with Profiler?
"Firestarter" <Firestarter@.discussions.microsoft.com> wrote in message
news:4F2E7F95-26A9-4F50-B69A-23141604B8D9@.microsoft.com...
> Thanks for reply.
> I've just had a look sysfiles. Not what I'm after. A sort of
> "sysfilesHistory" would be good.
> I want to be able to check, today, when the last time an Autogrow database
> last grew. Don't want to run profiler indefinitely. Any other ideas?
> "Uri Dimant" wrote:
> > Hi
> > Look at sysfiles system tables and compare it with the time.
> >
> > Also you can run Profiler which has AutoGrow event to see when it kicks
in.
> >
> >
> >
> >
> > "Firestarter" <Firestarter@.discussions.microsoft.com> wrote in message
> > news:6681C1A9-446B-454B-AB6C-398FC472BAC2@.microsoft.com...
> > > Is there any way of seeing when a databse se tto Autogrow last
expanded
> > and
> > > by how much?
> > >
> > >
> >
> >
> >|||You don't need you keep the Profiler GUI running. You can generate a script
the create the trace and then modify and run the script from Query Analyzer.
Just be sure to change the destination file and include only those events
you actually need.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Firestarter" <Firestarter@.discussions.microsoft.com> wrote in message
news:4F2E7F95-26A9-4F50-B69A-23141604B8D9@.microsoft.com...
> Thanks for reply.
> I've just had a look sysfiles. Not what I'm after. A sort of
> "sysfilesHistory" would be good.
> I want to be able to check, today, when the last time an Autogrow database
> last grew. Don't want to run profiler indefinitely. Any other ideas?
> "Uri Dimant" wrote:
>> Hi
>> Look at sysfiles system tables and compare it with the time.
>> Also you can run Profiler which has AutoGrow event to see when it kicks
>> in.
>>
>>
>> "Firestarter" <Firestarter@.discussions.microsoft.com> wrote in message
>> news:6681C1A9-446B-454B-AB6C-398FC472BAC2@.microsoft.com...
>> > Is there any way of seeing when a databse se tto Autogrow last expanded
>> and
>> > by how much?
>> >
>> >
>>