|
Home > Archive > MS SQL Server > January 2006 > performance monitor
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
performance monitor
|
|
|
| Hi,
Can someone tell me how i should create a monitoring file for sql server.
I want to establish a baseline in a production environment for a week or
so. What counters i should use, etc.
| |
|
| Give this a try :-
http://www.sql-server-performance.c...lining_tips.asp
--
HTH. Ryan
"Jason" <jasonlewis@hotmail.com> wrote in message
news:OH%23EabqGGHA.1192@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Can someone tell me how i should create a monitoring file for sql server.
>
> I want to establish a baseline in a production environment for a week or
> so. What counters i should use, etc.
| |
|
|
| Jack Vamvas 2006-01-16, 9:23 am |
| The following are good performance measurements - f
Memory: Pages/sec
Memory: Available Bytes
Physical Disk: % Disk time
Physical Disk: Avg. Disk Queue Length
Processor: % Processor Time
System: Processor Queue Length
SQL Server Buffer: Buffer Cache Hit Ratio
SQL Server General: User Connections
Monitor them for 24 hrs to 1 week.
An easy way to capture the measurements is via the built in Windows
Performance Monitor. Just output data to a log file . You can then import
into a sql db for analysis
--
Jack Vamvas
____________________
____________________
____________________
______
Receive free SQL tips - register at www.ciquery.com/remotedba.htm
SQL Server Performance Audit - check www.ciquery.com/sqlserver_audit.htm
New article by Jack Vamvas - SQL and Markov Chains -
www.ciquery.com/articles/art_04.asp
"Jason" <jasonlewis@hotmail.com> wrote in message
news:OH%23EabqGGHA.1192@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> Can someone tell me how i should create a monitoring file for sql server.
>
> I want to establish a baseline in a production environment for a week or
> so. What counters i should use, etc.
|
|
|
|
|