Re: Monitor performance

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Gregory A. Larsen (greg.larsen_at_doh.wa.gov)
Date: 04/27/04 

Date: Tue, 27 Apr 2004 10:31:26 -0700

Have you checked out http://www.sql-server-performance.com/. There is a
fair amount of performance information and tips on this site.

"joe" <pearl_77@hotmail.com> wrote in message
news:uEfActHLEHA.1644@TK2MSFTNGP09.phx.gbl...
> I would like to know more information about the following counters:
> is there a good website that teach you how to do performance baselining,
> benchmarking, and monitoring?
>
>
>
> Memory - Pages/Sec
> Network Interface - Bytes total/sec
> Physical Disk - Disk Transfers/Sec
> Processor - %Processor Time
> SQLServer: Access Methods - Full Scans/Sec
> SQLServer:Buffer Manager - Buffer Cache Hit Ratio
> SQLServer: Database application Database -Transaction/Sec
> SQLServer: General Statistics - User Connections
> SQLServer: Latches - Average Latch Wait Time
> SQLServer: LOCKs - Average Wait Time
> SQLServer: Locks - Lock Timeouts/sec
> SQLServer: Locks - Number of Deadlocks/sec
>
>