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

Knowing What's Normal

By Steve Jones,

I noticed in Database Weekly this week that I found a lot of posts on performance related topics, especially hardware ones. There was a note about a new Intel chip, getting performance counters with Powershell, and a review of drive performance by one individual. There was even some research from Andy Warren on SSD drives and a pre-sales evaluation of whether they are worth the cost. Those are all good topics, and worth reading about. However knowing all those tricks and techniques might not help you unless you're Gregory House, DBA.

There was a great post from our resident SQL Server MCM, Robert Davis, on taking a medicinal approach to troubleshooting performance. Using the television show House as an example, Robert gives reasons why you don't want to necessarily take the approach of just trying something, and that you ought to be aware if you really have a performance problem.

What is "slow" performance? How do you know things are slow? Slow is one of those descriptive terms that's vague, unreliable, and uncertain in it's meaning. I run every day, but there are times that my two miles seem to go faster than others, and times that it seems to go slower. However often I find that my perceptions aren't correct and the times are very similar. I just can't tell what "slow" by myself.

Neither can users. They often don't know even what normal is. Their perceptions, like mine, are clouded by many external factors. Without actually measuring what a normal baseline is, they can't necessarily be sure that their systems are operating any better or worse than on another day.

I'd urge you to not only read Robert's post, but also make sure that you are capturing baselines on your systems, especially the hosts for virtual machines. That way you'll be able to make some objective comparisons and analysis to find out if things really are slow.

Total article views: 143 | Views in the last 30 days: 1
 
Related Articles
BLOG

SQLSaturday#59 - Interview with Robert Pearl (1st in series)

SQLSaturday#59 - Interview with Robert Pearl (1st in series) - Say what?  As we get the countdown ...

BLOG

Performance Tuning – Over the Top Biz Logic

This month, Robert Pearl is helping to host a Performance Story contest.  The contest is being spons...

BLOG

Farewell, Robert B. Parker

I heard the news via a blog post by Ward Pond that one of my favorite authors had died at...

FORUM

Performance

performance

FORUM

performance

performance

Tags
 
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