Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Baselines

By Steve Jones,

You come into work one day and as you sit down, your phone rings. It's one of the business groups complaining that the database is running slow. You check the server and find CPU at 80%, 800 pages/sec, disk IOps of 230 and 124 transactions/sec. Is the database the problem? 

Good DBAs know that baselines are essential. If you don't know what values to expect from your server, it's often hard to determine if the system is running slower than normal. Normal is something you need to define for each system, preferably in an automated way that updates your baseline over time.

When building a baseline, however, how do you average out the information?

That's the poll this Friday. Let's assume that you are examining the CPU percentage for a SQL Server and you have data points from every 5 minutes across the last month. What's the average? Do you take the straight average? Do you break this down to hourly segments and then create further analysis that looks at different business periods?

It can become problematic very quickly. Many of us have slow and busy periods. Do we want an average that's perhaps lowered by the slow periods in our workload? Do we want to break out the averages for maintenance periods separately from normal operations? If you are looking to compare today's values, do you look at yesterday's for the same time period? Last week? An average of all points across the last week?

Let us know what methodology you use and if you'd like to describe it in more than a paragraph or two, we'd love to have some articles published here on the site.

Steve Jones


The Voice of the DBA Podcasts

We publish three versions of the podcast each day for you to enjoy.

Everyday Jones

The podcast feeds are available at sqlservercentral.mevio.com. You can also follow Steve Jones on Twitter:

Today's podcast features music by Everyday Jones. No relation, but I stumbled on to them and really like the music. Support this great duo at www.everydayjones.com. They have a great version of Message in a Bottle if you want to check it out.

I really appreciate and value feedback on the podcasts. Let us know what you like, don't like, or even send in ideas for the show. If you'd like to comment, post something here. The boss will be sure to read it.

Total article views: 479 | Views in the last 30 days: 15
 
Related Articles
FORUM

Baselines

Comments posted to this topic are about the item [B]Baselines[/B] We autochart KPI's on control char...

ARTICLE

Podcast Announcements

Podcast Feeds

BLOG

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!...

BLOG

The power of the baseline

There is one thing we all have in common, and a lot of us probably don’t even realize it, baselines!...

BLOG

Podcasting

A new video setup is on the way!!!! Actually I'll do a couple podcasts on podcasting over the hol...

Tags
baselines    
editorial    
 
Contribute

Join the most active online SQL Server Community

SQL knowledge, delivered daily, free:

Email address:  

You make SSC a better place

As a member of SQLServerCentral, you get free access to loads of fresh content: thousands of articles and SQL scripts, a library of free eBooks, a weekly database news roundup, a great Q & A platform… And it’s our huge, buzzing community of SQL Server Professionals that makes it such a success.

Join us!

Steve Jones
Editor, SQLServerCentral.com

Already a member? Jump in:

Email address:   Password:   Remember me: Forgotten your password?
Steve Jones