Performance Monitor Data (Sysperfinfo)

I have serveral 2000 databases on a Winwords 2000 Advanced server.
I would like to collect server,processor, disk, performance data monitor
data within SQL Server.
I would like to collect the same data that you can get from perfmon but
withinQL Sever. I know SQL Server has sysperfinfo table but missing several
counters from perfmon that I would like to collect.
Please help me this issue.Hi Joe,
try using SQL profiler and set up a new trace. You can choose the data
fields you wish to see within SQL.
Hope this helps,
Isobel
"Joe K." wrote:

> I have serveral 2000 databases on a Winwords 2000 Advanced server.
> I would like to collect server,processor, disk, performance data monitor
> data within SQL Server.
> I would like to collect the same data that you can get from perfmon but
> withinQL Sever. I know SQL Server has sysperfinfo table but missing sever
al
> counters from perfmon that I would like to collect.
> Please help me this issue.|||Nothing built in to do this with Win 2K. You can log the
Perf Mon counters to a csv and import the data into SQL
Server from there. The operating systems after 2000 have an
option to log directly to a database table but that will
have a negative impact on performance. It's generally a
better idea to log to files rather than databases and then
import the data from the files.
-Sue
On Mon, 1 May 2006 09:45:02 -0700, Joe K. <Joe
K.@.discussions.microsoft.com> wrote:

>I have serveral 2000 databases on a Winwords 2000 Advanced server.
>I would like to collect server,processor, disk, performance data monitor
>data within SQL Server.
>I would like to collect the same data that you can get from perfmon but
>withinQL Sever. I know SQL Server has sysperfinfo table but missing severa
l
>counters from perfmon that I would like to collect.
>Please help me this issue.