SQL Server 2000 performance counter

[Marc Melancon]

Will the next release of SQL Server 2000 64bit sp provide performance
counter?

MarcM

[dbmonitor]

Marc Melancon wrote:

Will the next release of SQL Server 2000 64bit sp provide performance
counter?

MarcM

What type of performance counters are you after?

There already are quite a few counters in SQL Server. All you need to
do is run the performance option in Control Panel->Administration
Tools.

You will need to run this on the computer running SQL Server or you
could run it on another machine with the counters installed as long as
you have connection access rights to the server.

There are variables that you can use to retrieve performance counts
yourself. I use some of these in my shareware application to display
graphs of CPU usage, network IO and disk access. Also, the application
displays the time it takes for the server to return a simple 'SELECT 1'
command.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com

[MarcM]

From what I understand all SQL Server related performance counter in Yukon
will be available internaly and was wondering if the same would be done on
SQL Server 2000 64bit service pack.

It would be useful in my case.

"dbmonitor" <db***************@hotmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

Marc Melancon wrote:

Will the next release of SQL Server 2000 64bit sp provide performance
counter?

MarcM

What type of performance counters are you after?

There already are quite a few counters in SQL Server. All you need to
do is run the performance option in Control Panel->Administration
Tools.

You will need to run this on the computer running SQL Server or you
could run it on another machine with the counters installed as long as
you have connection access rights to the server.

There are variables that you can use to retrieve performance counts
yourself. I use some of these in my shareware application to display
graphs of CPU usage, network IO and disk access. Also, the application
displays the time it takes for the server to return a simple 'SELECT 1'
command.

--
David Rowland
For a good user and performance monitor, check DBMonitor
http://dbmonitor.tripod.com