PTO for the Rest of Us - Jan 2007 - A new slant on performance tuning

Last Post 03 Feb 2007 01:46 AM by SQLUSA. 4 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:15 PM
Hello everyone,

I hope some of you have had a chance to read (and hopefully enjoy) my new column called 'PTO for the Rest of Us'. The January column describes, at a high level, what I hope to accomplish. I'll start a new thread each month to give readers a place to chat about the column. And I'll be really sad if no one has any questions, thoughts, or comments.



Brian Moran
Solid Quality Learning
SQLUSA
New Member
New Member

--
03 Feb 2007 01:46 AM
Brian,

Can you give a link to your column? Or post it.

What is PTO?

Kalman Toth
SQLUSA: http://www.sqlusa.com
JHunter
New Member
New Member

--
03 Feb 2007 10:30 AM
quote:

Originally posted by: SQLUSA

Can you give a link to your column? Or post it.

SQLUSA: http://www.sqlusa.com


Just browse to the January or February issues, its the last article on the page. In the magazine, the column was on page 5 in both issues... and the links are:

A new slant on performance tuning
InstantDoc #94248
http://www.sqlmag.com/Article/Artic...94248.html

Clown Cramming
InstantDoc #94597
http://www.sqlmag.com/Article/Artic...94597.html

Jamie
SQLUSA
New Member
New Member

--
05 Feb 2007 03:50 PM
>Clown Cramming
>InstantDoc #94597
>http://www.sqlmag.com/Article/.../s...94597.html

>Jamie

Thanks Jamie.

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




SQLUSA
New Member
New Member

--
06 Feb 2007 12:24 AM
>A new slant on performance tuning
>InstantDoc #94248
>http://www.sqlmag.com/Article/.../s...94248.html

Brian,

I agree with you that performance tuning is more difficult than we like to admit.

Basically PTO is the domain of a senior DBA. Even for him/her it may be a time-consuming exercise.

My favorite weapons are:

1. Reindexing everynight busy OLTP tables with 50-70 FILL FACTOR
2. Constantly monitoring with SQL profiler for slow running queries. I maintain a list of TOP 10. No developer likes to be on my hit list.

Kalman Toth
SQLUSA: http://www.sqlusa.com
You are not authorized to post a reply.

Acceptable Use Policy