How to save performance counters values to SQL Server database tab

I am monitoring sql server and windows performance counters.
My computer has "Microsoft windows XP professional". I am monitoring sql
servers (2000 (sp3 and sp4) and 2005) running on windows NT 4 and 5.2.
For historical analysis I want to store the values of various counters in
sql server database(table). I have created a a DSN for the sql server 2005
installed on my PC for data repository. Still I can save counter values as
report(.tsv) ot web (.html). I want to save the values to SQL server TABLE.
hOW DO i DO THAT'
--
ontario, canadaI am using microsoft management console 2.0 version 5.1.
--
ontario, canada
"db" wrote:
> I am monitoring sql server and windows performance counters.
> My computer has "Microsoft windows XP professional". I am monitoring sql
> servers (2000 (sp3 and sp4) and 2005) running on windows NT 4 and 5.2.
> For historical analysis I want to store the values of various counters in
> sql server database(table). I have created a a DSN for the sql server 2005
> installed on my PC for data repository. Still I can save counter values as
> report(.tsv) ot web (.html). I want to save the values to SQL server TABLE.
> hOW DO i DO THAT'
> --
> ontario, canada|||db
How about?
SELECT * FROM sys.dm_os_performance_counters
WHERE counter_name = 'Total Server Memory (KB)'
OR counter_name = 'Target Server Memory (KB)';
SELECT * FROM sys.dm_os_performance_counters
WHERE counter_name = 'Page life expectancy'
AND object_name = 'SQLServer:Buffer Manager';
"db" <db@.discussions.microsoft.com> wrote in message
news:F027E65B-CADE-41AE-97E2-DD3079D42481@.microsoft.com...
> I am monitoring sql server and windows performance counters.
> My computer has "Microsoft windows XP professional". I am monitoring sql
> servers (2000 (sp3 and sp4) and 2005) running on windows NT 4 and 5.2.
> For historical analysis I want to store the values of various counters in
> sql server database(table). I have created a a DSN for the sql server 2005
> installed on my PC for data repository. Still I can save counter values as
> report(.tsv) ot web (.html). I want to save the values to SQL server
> TABLE.
> hOW DO i DO THAT'
> --
> ontario, canada|||Thanks Uri. Two questions:
1. It works for SQL server 2005 by in sql server 2000 I am getting this
error message:
Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.dm_os_performance_counters'.
2. Parameter like sql Server: Buffer Manager (Buffer cache hit ratio) has a
value 3310 by this select statement. I was expecting something like (99%).
3. Many counters that available through MMC are not present in this table.
Should I be looking at some other tables.
--
ontario, canada
"Uri Dimant" wrote:
> db
> How about?
> SELECT * FROM sys.dm_os_performance_counters
> WHERE counter_name = 'Total Server Memory (KB)'
> OR counter_name = 'Target Server Memory (KB)';
> SELECT * FROM sys.dm_os_performance_counters
> WHERE counter_name = 'Page life expectancy'
> AND object_name = 'SQLServer:Buffer Manager';
>
> "db" <db@.discussions.microsoft.com> wrote in message
> news:F027E65B-CADE-41AE-97E2-DD3079D42481@.microsoft.com...
> >
> > I am monitoring sql server and windows performance counters.
> >
> > My computer has "Microsoft windows XP professional". I am monitoring sql
> > servers (2000 (sp3 and sp4) and 2005) running on windows NT 4 and 5.2.
> >
> > For historical analysis I want to store the values of various counters in
> > sql server database(table). I have created a a DSN for the sql server 2005
> > installed on my PC for data repository. Still I can save counter values as
> > report(.tsv) ot web (.html). I want to save the values to SQL server
> > TABLE.
> > hOW DO i DO THAT'
> >
> > --
> > ontario, canada
>
>|||1. Table in sql server 2000 looks like "sysperfinfo".
4. I need to append everyday all the counter values to the table with a
field for datetime at which counter values were captured.
ontario, canada
"db" wrote:
> Thanks Uri. Two questions:
> 1. It works for SQL server 2005 by in sql server 2000 I am getting this
> error message:
> Msg 208, Level 16, State 1, Line 1
> Invalid object name 'sys.dm_os_performance_counters'.
> 2. Parameter like sql Server: Buffer Manager (Buffer cache hit ratio) has a
> value 3310 by this select statement. I was expecting something like (99%).
> 3. Many counters that available through MMC are not present in this table.
> Should I be looking at some other tables.
> --
> ontario, canada
>
> "Uri Dimant" wrote:
> > db
> > How about?
> > SELECT * FROM sys.dm_os_performance_counters
> >
> > WHERE counter_name = 'Total Server Memory (KB)'
> >
> > OR counter_name = 'Target Server Memory (KB)';
> >
> > SELECT * FROM sys.dm_os_performance_counters
> >
> > WHERE counter_name = 'Page life expectancy'
> >
> > AND object_name = 'SQLServer:Buffer Manager';
> >
> >
> > "db" <db@.discussions.microsoft.com> wrote in message
> > news:F027E65B-CADE-41AE-97E2-DD3079D42481@.microsoft.com...
> > >
> > > I am monitoring sql server and windows performance counters.
> > >
> > > My computer has "Microsoft windows XP professional". I am monitoring sql
> > > servers (2000 (sp3 and sp4) and 2005) running on windows NT 4 and 5.2.
> > >
> > > For historical analysis I want to store the values of various counters in
> > > sql server database(table). I have created a a DSN for the sql server 2005
> > > installed on my PC for data repository. Still I can save counter values as
> > > report(.tsv) ot web (.html). I want to save the values to SQL server
> > > TABLE.
> > > hOW DO i DO THAT'
> > >
> > > --
> > > ontario, canada
> >
> >
> >|||I was able to save it in sql server table through MMC perfmon in the way i
want to do it.
--
ontario, canada
"db" wrote:
> 1. Table in sql server 2000 looks like "sysperfinfo".
> 4. I need to append everyday all the counter values to the table with a
> field for datetime at which counter values were captured.
> ontario, canada
>
> "db" wrote:
> > Thanks Uri. Two questions:
> >
> > 1. It works for SQL server 2005 by in sql server 2000 I am getting this
> > error message:
> >
> > Msg 208, Level 16, State 1, Line 1
> > Invalid object name 'sys.dm_os_performance_counters'.
> >
> > 2. Parameter like sql Server: Buffer Manager (Buffer cache hit ratio) has a
> > value 3310 by this select statement. I was expecting something like (99%).
> >
> > 3. Many counters that available through MMC are not present in this table.
> > Should I be looking at some other tables.
> >
> > --
> > ontario, canada
> >
> >
> > "Uri Dimant" wrote:
> >
> > > db
> > > How about?
> > > SELECT * FROM sys.dm_os_performance_counters
> > >
> > > WHERE counter_name = 'Total Server Memory (KB)'
> > >
> > > OR counter_name = 'Target Server Memory (KB)';
> > >
> > > SELECT * FROM sys.dm_os_performance_counters
> > >
> > > WHERE counter_name = 'Page life expectancy'
> > >
> > > AND object_name = 'SQLServer:Buffer Manager';
> > >
> > >
> > > "db" <db@.discussions.microsoft.com> wrote in message
> > > news:F027E65B-CADE-41AE-97E2-DD3079D42481@.microsoft.com...
> > > >
> > > > I am monitoring sql server and windows performance counters.
> > > >
> > > > My computer has "Microsoft windows XP professional". I am monitoring sql
> > > > servers (2000 (sp3 and sp4) and 2005) running on windows NT 4 and 5.2.
> > > >
> > > > For historical analysis I want to store the values of various counters in
> > > > sql server database(table). I have created a a DSN for the sql server 2005
> > > > installed on my PC for data repository. Still I can save counter values as
> > > > report(.tsv) ot web (.html). I want to save the values to SQL server
> > > > TABLE.
> > > > hOW DO i DO THAT'
> > > >
> > > > --
> > > > ontario, canada
> > >
> > >
> > >sql

How to save and replay the performance counters created in Performance Monitor?

Hi,
I would like to get these saved and later analysed, but could not make it
done, help please.
Thanks in advance
FrankHi
In the properties page the is a data source setting where you can specify
current, log file or database
John
"Frank" wrote:
> Hi,
> I would like to get these saved and later analysed, but could not make it
> done, help please.
> Thanks in advance
> Frank
>
>|||Hi John,
Thanks for your reply, but I still don't know how to read it.
B/R
Frank
"John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
> Hi
> In the properties page the is a data source setting where you can specify
> current, log file or database
> John
> "Frank" wrote:
> > Hi,
> >
> > I would like to get these saved and later analysed, but could not make
it
> > done, help please.
> >
> > Thanks in advance
> > Frank
> >
> >
> >|||Hello Frank,
This is the common confusion that the first time users of Performance
Monitor have.
Just because you have a Performance counter file that does not mean it will
display the graph
when you open it.
You got to "Open" the file in Performance Monitor and then "Select" the
counters that you
want to be displayed.
Hope this helps !!
Gopi
"Frank" <wangping@.lucent.com> wrote in message
news:uhKf$yUJFHA.656@.TK2MSFTNGP14.phx.gbl...
> Hi John,
> Thanks for your reply, but I still don't know how to read it.
> B/R
> Frank
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
>> Hi
>> In the properties page the is a data source setting where you can specify
>> current, log file or database
>> John
>> "Frank" wrote:
>> > Hi,
>> >
>> > I would like to get these saved and later analysed, but could not make
> it
>> > done, help please.
>> >
>> > Thanks in advance
>> > Frank
>> >
>> >
>> >
>|||RGN,
Thanks so much, that help!
Frank
"rgn" <gopinathr@.healthasyst.com> wrote in message
news:epZbB2VJFHA.2756@.TK2MSFTNGP10.phx.gbl...
> Hello Frank,
> This is the common confusion that the first time users of Performance
> Monitor have.
> Just because you have a Performance counter file that does not mean it
will
> display the graph
> when you open it.
> You got to "Open" the file in Performance Monitor and then "Select" the
> counters that you
> want to be displayed.
> Hope this helps !!
> Gopi
> "Frank" <wangping@.lucent.com> wrote in message
> news:uhKf$yUJFHA.656@.TK2MSFTNGP14.phx.gbl...
> > Hi John,
> > Thanks for your reply, but I still don't know how to read it.
> >
> > B/R
> > Frank
> > "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> > news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
> >> Hi
> >>
> >> In the properties page the is a data source setting where you can
specify
> >> current, log file or database
> >>
> >> John
> >>
> >> "Frank" wrote:
> >>
> >> > Hi,
> >> >
> >> > I would like to get these saved and later analysed, but could not
make
> > it
> >> > done, help please.
> >> >
> >> > Thanks in advance
> >> > Frank
> >> >
> >> >
> >> >
> >
> >
>|||Hi
If you create a new counter log, you can specify the file that log
should be written to. If you specify csv then you will get a readable
text file containing a row of headings for the counter names followed
by rows of timestamped values. Depending on what the counter is depends
on how you interpret it. The explain button in perfmon will give you
some details on what each counter means and what values to expect.
If you wish to replay the log file using perfmon you can set the data
source to be the file you have created and then it will show the
information in the perfmon window. The actual interpretation of the
results it up to you.
HTH
John
Frank wrote:
> Hi John,
> Thanks for your reply, but I still don't know how to read it.
> B/R
> Frank
> "John Bell" <JohnBell@.discussions.microsoft.com> wrote in message
> news:D683CA66-7D14-4A3B-98D0-4DF2B6590D00@.microsoft.com...
> > Hi
> >
> > In the properties page the is a data source setting where you can
specify
> > current, log file or database
> >
> > John
> >
> > "Frank" wrote:
> >
> > > Hi,
> > >
> > > I would like to get these saved and later analysed, but could not
make
> it
> > > done, help please.
> > >
> > > Thanks in advance
> > > Frank
> > >
> > >
> > >