PTO for the Rest of Us - Feb 2007 - Clown Cramming

Last Post 24 Mar 2007 11:49 AM by SQLUSA. 5 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
briancmoran
New Member
New Member

--
02 Feb 2007 12:20 PM
Ok, I'll admit that the analogy of 'how many clowns can you squeeze into a Volkswagen' doesn't map 100% to real world capacity planning. But I will say that I used it recently at one of my customer sites and a few months later the executives were still asking thier IT staff 'can squeeze more clowns into our system yet'. It turned out to be a great way to help 'business folks' understand the some basic truths of capacity planning.

Brian Moran
Solid Quality Learning
JHunter
New Member
New Member

--
02 Feb 2007 12:35 PM
Hey Brian,

My Feb edition was delivered yesterday, and I found myself giggling on the train into work this morning as I read about your clowns. I always feel business people fail to understand (or take in) enough from our IO conversations - I may just try the red nose and big shoes approach!

Cheers
Jamie
JHunter
New Member
New Member

--
02 Feb 2007 12:35 PM
Double post... mods please delete...
SQLUSA
New Member
New Member

--
06 Feb 2007 12:26 AM
(reposted)


Brian -

My comments:

Partially I agree with you that the system should be optimized by traditional means, such as index optimization, improving T-SQL logic in spocs, before pulling out a blank Purchase Order to upgrade the hardware.

However to make your point, you are exagerating the cost of HW upgrade to several hundred thousands dollars, ignoring that one can upgrade a server for as little as $10K.

Naturally I am in favor of database optimization as an on going duty of a DBA. However, since HW prices dropping and technology advances, I am also in favor of hardware upgrades. Not only you get better performance, but you get new "iron" which is less likely to break down (as opposed to 3-5 year old server).

There are limits to optimization:

1. Skill of DBA. It requires a senior DBA to do good optimization.

2. Political issue of throwing back slow queries/sprocs to the development department and QA.

3. In case of 3rd party software, only index optimization can be applied. Even that may become a political or licensing issue.

Kalman Toth
SQLUSA: http://www.sqlusa.com


John Langston
New Member
New Member

--
20 Mar 2007 10:16 AM
I ask the question "What makes sizing so difficult?" and will be the first to admit that sometimes there seems to be more art than science involved here. When I compare the sizing approaches I have read about with those employed by sizing specialists, the approaches have all been very different.

Kalman makes some good points. Most developers with whom I have worked think in terms of correct functionality and meeting the deadline with all other considerations (performance) being secondary.
Index optimization was the only course available to us on a key third party software product.
SQLUSA
New Member
New Member

--
24 Mar 2007 11:49 AM
Interesting case to justify INDEX OPTIMIZATION IS #1 in PTO
You are not authorized to post a reply.

Acceptable Use Policy