471,337 Members | 928 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,337 software developers and data experts.

SQL Server 2000 performance counter

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

MarcM
Jul 23 '05 #1
2 1974

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

Jul 23 '05 #2
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

Jul 23 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

19 posts views Thread by Thue Tuxen Sørensen | last post: by
9 posts views Thread by Steve Buster | last post: by
1 post views Thread by Dave Pink | last post: by
1 post views Thread by thomasamillergoogle | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.