Performance Monitor

8 Feb 2007 1:38 AM

Sean

Using SQL Server 2000; how do I start Performance Monitor for a specific SQL
Server?
Currently, I have multiple servers including my local and each time
Performance Monitor is started, it monitors the local SQL Server.

What is the best way to monitor the SQL Server's performance and fine tune it?

Thanks

9 Feb 2007 1:42 AM

Steve

On Feb 7, 5:38 pm, Sean <S***@discussions.microsoft.com> wrote:

> Using SQL Server 2000; how do I start Performance Monitor for a specific SQL
> Server?
> Currently, I have multiple servers including my local and each time
> Performance Monitor is started, it monitors the local SQL Server.
>
> What is the best way to monitor the SQL Server's performance and fine tune it?
>
> Thanks

Clcik the add counter icon or right click in the display area to open
the Add Counters dialog
Add Counters/Select counters from computer