Re: performance monitor

From: Mark Allison (mark_at_no.tinned.meat.mvps.org)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 07:59:01 +0000

Catelin,

Both performance monitor and SQL Profiler can monitor remote machines.
With perfmon, when you add a counter to monitor, you can choose which
machine this counter is on at the top of the Add Counters dialog box.

With SQL Profiler, when you launch it, you just choose the SQL Server
you want. 

-- 
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
Catelin wang wrote:
> Thanks for the replay, but how can I find the SQL SErvers,I want to monitor
> the Servers through  my PC and my pc is not a SQL server . is this possible
> 
> Catelin
> "Catelin wang" <cwang@cemstone.com> wrote in message
> news:OI0QTdw$EHA.2444@TK2MSFTNGP10.phx.gbl...
> 
>>I have windowns 2000, and I wan to monitor the SQL Servers, how can I do
> 
> it?
> 
>>
>>"Yih-Yoon Lee" <yihyoon.online@gmail.com> wrote in message
>>news:O3drYWw$EHA.2552@TK2MSFTNGP09.phx.gbl...
>>
>>>Hi Catelin
>>>
>>>What version of Windows are you running on? Windows XP/2000/2003/4.0 all
>>>have performance monitor installed by default. You can launch
>>>performance monitor from Administrative Tools, or go to start-run, type
>>>in perfmon.
>>>
>>>Yih-Yoon Lee
>>>My blog http://www.mssql-tools.com/blog
>>>E-mail: yihyoon.online@gmail.com
>>>/* remove .online to send me e-mail */
>>>
>>>Catelin wang wrote:
>>>
>>>>How can I have performance monitor on my computer to check CPU usage?
>>>>
>>>>
>>
>>
> 
>

Relevant Pages

  • Re: Batch Requests/Sec counter
    ... The scale on performance monitor only affects the position of the graph. ... I support the Professional Association for SQL Server ... >>> The batch requests per second shown on the performance ...
    (microsoft.public.sqlserver.server)
  • Re: Batch Requests/Sec counter
    ... Andrew J. Kelly SQL MVP ... > but the scale in the column beneath it is 1000.... ... >>I support the Professional Association for SQL Server ... >>> The performance monitor shows it at the scale of 1000 ...
    (microsoft.public.sqlserver.server)
  • SP timing out, cant find the cause
    ... We are using SQL Server 2005. ... I've also run the blocking monitor as described on ... through the performance monitor on the server and everything looked ...
    (comp.databases.ms-sqlserver)
  • Re: How to monitor Triggers in VB6
    ... You can use Profiler to or SQL Trace to monitor what's currently executing ... Vyas, MVP (SQL Server) ... > I have this triggers in T-SQL to execute when a product qty is 0, ...
    (microsoft.public.sqlserver.programming)
  • Re: [PHP] most powerful php editor
    ... Jon Anderson wrote: ... SQL actually does lend itself rather well to normal code style indenting, even though not many seem to do it...Breaking it (and PHP code of course) into 78/80-char lines makes great sense for readability within PHP code: ... As for monitor size, I've noticed over the years that my function size increased with the height of my monitor. ...
    (php.general)