Performance Counters query - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Performance Counters query

Author

Topic

Kinnerton
Starting Member

21 Posts

Posted - 2011-03-22 : 10:30:09

Hi - still a newbie dba,

We're running a 24/7 replicated raided SQL 2005 16 proc/16Gb mem Standard OLTP database that is currently around 750Gb and 300 users.

I am consistently getting the following perf counters :

Page Reads/sec 1466
Page Writes/sec 132
Checkpoint Pages/sec 24

Would these point to any area that I need to investigate? Or is it an 'it depends' situation?

Any help would be greatly appreciated.

Regards,

Kinnerton

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-22 : 10:56:18

Are you experiencing performance issues?

These #s in and of themselves don't bother me. Checkpoints will be high for a minute or so right after a checkpoint.

Kinnerton
Starting Member

21 Posts

Posted - 2011-03-22 : 11:19:03

Thanks for the reply, russell.

The performance is Ok. I was wondering if the high checkpoints may be causing unwanted overhead? What figure should I be looking for and what would I need to do to achieve it?

The db had been in quite a bad way so I was tasked with knocking it back into shape. I'm trying to iron out the last few wrinkles.

Cheers,

Kinnerton

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-03-22 : 11:25:45

Might have a look at this thread and schuhtl's post in it.

Generally, there's no correct target value for checkpoints. On a roughly comparable system I have to yours, my checkpoint pages are higher and my writes are higher. My reads are way lower, but we replicate out to three other servers where most of the reads occur.

I'd look at PLE, more than these numbers, though might be a good idea to save these over time for baselining.

Kinnerton
Starting Member

21 Posts

Posted - 2011-03-22 : 11:37:35

Thanks russell,

I'll check that out.

Added:

What a gem of a post - brilliant!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources