Knowing What's Normal

Question

Knowing What's Normal

Steve Jones - SSC Editor

SSC Guru

Points: 736291
More actions
June 5, 2010 at 11:20 am

#233451

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

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLRNNR SSC Guru Points: 281334 More actions · Answer 1

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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Jeff Moden SSC Guru Points: 1004378 More actions · Answer 2

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

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. 😛

--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.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Keith.Hart Newbie Points: 4 More actions · Answer 3

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

Daniel Bowlin SSC-Dedicated Points: 34566 More actions · Answer 4

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: