SQL 2005 Counters | keyongtech

03-17-09, 08:39 PM

tolcis

Hi,
Is there a document (microsoft or not) that I can use to set up a
baseline for my SQL Server 2005 Counters?
As an example I would like to know what is the normal Buffer Cache Hit
Rate or what is the normal vlue for deadlocks per second.

Thank you,
T.

03-18-09, 02:45 AM

Ekrem Önsoy

Check out PAL: http://pal.codeplex.com/

03-18-09, 05:07 AM

SQLSQUIRREL

Hi tolcis,

Here is a post I put up on my blog about detecting hardware bottlenecks with
SQL server. I will be posting in a few days the counters you need to be
tracking inorder to get a well defined baseline for your SQL servers.

http://www.lockergnome.com/sqlsquirr...pu-bottleneck/

sqlsquirrel

"tolcis" wrote:
[..]

03-18-09, 01:06 PM

tolcis

On Mar 17, 10:45 pm, Ekrem Önsoy <ek> wrote:
> Check out PAL:[..]
>
> --
> Ekrem Önsoy
>
> "tolcis" <nytolly> wrote in message
>
> news:ec87
>>
>> - Show quoted text -
Not sure if this will help me. I need a baseline for a normal SQL
Server. From what I understand that tool will analyze my current
server state.

T.

03-18-09, 03:38 PM

Ekrem Önsoy

I suggested you the tool so that it may help you to set your baseline. For
instance, when your processor time hits 80 then it means a CPU bottleneck
and you'll find this in PAL as well, however there's no a standard threshold
for locks\blocks as it depends on your transactions' durations, isolation
levels and lots of things. There's no a template baseline for every counter
and situation.

Similar Threads
Thread	Thread Starter
SQL Server 2005 Ent. Ed. Perfmon Counters I have several SQL Server 2005 Enterprise Edition database servers that have Windows 2003 Server as the operating system. I would like to set up perfmon counters to monitor...	Joe K.
MoM 2005 Performance Counters In a MoM 2005 environment, is there a reason why servers with the same base OS do not have the same performance counters available? As a number of Windows 2003 servers are...	Robin9876
SQL 2005 WMI Performance Counters Hello all, I'm new to SQL2005 and I seem to be missing something when it comes to performance counters and the WMI interface. Back in the day of SQL 2000 there was a set of...	David Gibbons
MOM 2005 - graphing counters to a website? Hi, Is there anyway to graph counters in MOM2005 to a website? I was looking at using MRTG which uses a vbscript as a target which gets WMI information, it is a little...	Matthew M \(UK\)
Counters in MOM 2005 I'm using MOM2005 right out of the box using the OS mgt pack and sql server. I've registered a number of servers and have begun to notice that different servers have...	tom frost