Performance Monitor SQL Counters question

I'm a bit confused, so I hope someone can help.
Under the MSSQL$AAP1:Databases Object are two counters. Data File(s) Size
(KB) and Log File(s) Size (KB). If I understand these correctly, they are to
monitor spikes within the growth of the data & log files. However, when I
run them against my Production Server, they are both consistantly at 100%.
HUH?
The disk drive has more than enough space and both files for my database (I
chose to monitor a single DB, not all of them) are set to AutoGrow. So, why
do the counters register at the top of the charts?
If anyone could explain this for me, I'd greatly appreciate it. Thanks,
Catadmin
MCDBA, MCSA
Random Thoughts: If a person is Microsoft Certified, does that mean that
Microsoft pays the bills for the funny white jackets that tie in the back?
@.=)
Hi
I am not sure you are interpreting the counter correctly, with all
performance monitor counters you need to look at the scale to get the size.
Being 100% of the size all the time would indicate that there has been no
growth during that period.
If you do a period sp_helpfile and store the results into a table you should
be able to monitor store the current size over time.
John
"Catadmin" wrote:

> I'm a bit confused, so I hope someone can help.
> Under the MSSQL$AAP1:Databases Object are two counters. Data File(s) Size
> (KB) and Log File(s) Size (KB). If I understand these correctly, they are to
> monitor spikes within the growth of the data & log files. However, when I
> run them against my Production Server, they are both consistantly at 100%.
> HUH?
> The disk drive has more than enough space and both files for my database (I
> chose to monitor a single DB, not all of them) are set to AutoGrow. So, why
> do the counters register at the top of the charts?
> If anyone could explain this for me, I'd greatly appreciate it. Thanks,
> Catadmin
> --
> MCDBA, MCSA
> Random Thoughts: If a person is Microsoft Certified, does that mean that
> Microsoft pays the bills for the funny white jackets that tie in the back?
> @.=)
|||So how does one know when the files do change in size? Does the percentage
go down? Or is there a number higher than 100 that it shoots up to during a
"growth spurt"?
Thanks,
Catadmin
"John Bell" wrote:
[vbcol=seagreen]
> Hi
> I am not sure you are interpreting the counter correctly, with all
> performance monitor counters you need to look at the scale to get the size.
> Being 100% of the size all the time would indicate that there has been no
> growth during that period.
> If you do a period sp_helpfile and store the results into a table you should
> be able to monitor store the current size over time.
> John
> "Catadmin" wrote:
|||Hi
If open the performance data file in perfmon you will see a step when the
file grows.
John
"Catadmin" wrote:
[vbcol=seagreen]
> So how does one know when the files do change in size? Does the percentage
> go down? Or is there a number higher than 100 that it shoots up to during a
> "growth spurt"?
> Thanks,
> Catadmin
>
> "John Bell" wrote: