467,116 Members | 1,135 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,116 developers. It's quick & easy.

SQL Server 2000 performance counter

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

MarcM
Jul 23 '05 #1
  • viewed: 1862
Share:
2 Replies

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@yahoo.com | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.