Knowing What's Normal

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQLServerCentral.com » Editorials » Knowing What's Normal

Knowing What's Normal

Rate Topic

Display Mode

Topic Options

Author

Message

Steve Jones - SSC Editor

Posted Saturday, June 05, 2010 11:20 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:24 AM
Points: 31,426, Visits: 13,739

Comments posted to this topic are about the item Knowing What's Normal

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #933160

SQLRNNR

Posted Sunday, June 06, 2010 9:20 AM

SSCoach

Group: General Forum Members
Last Login: Monday, May 20, 2013 1:07 PM
Points: 18,733, Visits: 12,332

Thanks for the reminder Steve.

When running I sometimes find the same thing. I may perceive that my body isn't responding. When I feel that way I try to push a little harder and I usually run considerably faster. Maybe a perceived problem could be worth checking into as well with SQL server - you could make it better as well.

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #933240

Jeff Moden

Posted Sunday, June 06, 2010 4:07 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 5:13 AM
Points: 32,906, Visits: 26,793

Heh... when a patient comes in with a bone sticking out of the skin, guess what's wrong. Wink

I agree... too many people treat symptoms on SQL Server and, many times, they'll treat slow servers with new hardware without correctly identifying what the problem actually is. These same people are frequently grossly diappointed that their new wizz-bang server doesn't do much better than their old one did. Baselines don't help such people because they're not "doctors" and they sometimes just don't know what the symptom of a change compared to a baseline actually means. Worse than that, these same people are terrible "patients" because they don't want to take the necessary "medicine" especially when the correct treatment involves rewriting code.

So far as the question of how to define if the server is slow, it's kind of like defining the difference between a leak and flooding on a submarine. If you find it, it's a leak. If it finds you, it's flooding. Tongue

--Jeff Moden

"RBAR is pronounced "ree-bar" and is a "Modenism" for "Row-By-Agonizing-Row".

First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #933287

Keith.Hart

Posted Monday, June 07, 2010 8:56 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, January 21, 2013 4:05 PM
Points: 2, Visits: 9

Kurt Vonnegut wrote a book in 1975 that addresses just the perception of heavy: “Slapstick, or Lonesome No More!”

http://www.newyorker.com/archive/1976/10/25/1976_10_25_182_TNY_CARDS_000106272

Post #933555

Daniel Bowlin

Posted Monday, June 07, 2010 11:35 AM

SSCrazy

Group: General Forum Members
Last Login: Yesterday @ 1:10 PM
Points: 2,673, Visits: 2,418

Without a baseline, slow is all about perception.

With a baseline, slow is still usually about perception.

So, know your baseline, keep your system running well, and fight the perception! Crazy

Post #933616

« Prev Topic | Next Topic »

Permissions