Re: performance monitor

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

Date: Thu, 20 Jan 2005 16:15:10 +0000

Catelin,

This site is great for taking you through performance monitoring:
http://www.sql-server-performance.com

I recommend you go through their guides. 

-- 
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:
> 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: Performance Monitoring
    ... SQL Server 2000 Enterprise Edition ... Windows Resource Kit & Platform SDK ... > When I want add an object to performance monitor under performance object ...
    (microsoft.public.win2000.general)
  • Re: on nt4
    ... using performance monitor. ... Check the usage of virtual memory as well. ... Look into the Event viewer as well as SQL server error logs for any messages ... > on an NT4 machine. ...
    (microsoft.public.sqlserver.server)
  • Re: Enabling SQL performance monitoring objects
    ... Counters may disappear when you don't close performance monitor before ... SQL Server MVP ... "Mark Baldwin" wrote in message ... > How do I enable the SQL performance monitoring objects to be used by ...
    (microsoft.public.sqlserver.server)
  • Re: A way to track open data connections?
    ... If it's SQL Server, ... you can use perfmon (Performance Monitor) which is included with Windows NT, ... > showing a list of currently open data connections or recordsets. ...
    (microsoft.public.inetserver.asp.general)
  • Re: CoInitialize failure with many processes
    ... directly communicate with the SQL server. ... _connection object ... Regarding the Performance Monitor, I haven't seen anything out of the ... "Brian Muth" wrote: ...
    (microsoft.public.win32.programmer.ole)
Loading