How to get 'Best Performance tuning programmer' award ?

Question

How to get 'Best Performance tuning programmer' award ?

karthik M

One Orange Chip

Points: 29139
More actions
November 20, 2007 at 6:35 am

#179389

All experts inputs are welcome !
karthik

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

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

What are you looking for?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

karthik M One Orange Chip Points: 29139 More actions · Answer 2

I am going to involve myself in the project called 'Performance tuning stored procedure' very soon.

My team size would be 5. My reporting manager announced an award called ' best performance tuner' who would perform very well in this project. Basically, i know he announced this award to motivate the people. Ok let it be. I would like to buy that award.I know i have to perform very well, but if i get some good ideas,thoughts from some good experts then it would help me to acquire that award.

karthik

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

So we do the work and you get the award? 😉

Performance tuning is an art and it's mostly trial and error. I've been doing perf tuning for close on 4 years now, and I still have to try things 2-3 ways before I find the one that works better. Experience is about the best teacher there is.

As a simple methodology.

1) Identify the poorly performing queries (profiler, SQL 2005 cache analysis, complainig users)

2) Identify the reason the query is performing badly (incorrect indexes, poor query structure, retriving too much data, blocking)

3) Resolve the identified issue.

4) Go to step 2 and repeat until query cannot be optimised any more.

5) Go to step 1, identify another query, repeat.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

karthik M One Orange Chip Points: 29139 More actions · Answer 4

Well.I will implement your idea for the upcoming project.

If i got award, then i will send it to you.Ok.:)

karthik

Suresh B. SSC-Insane Points: 22986 More actions · Answer 5

Also use

1) Query Execution Plan

2) SET STATISTICS IO/TIME ON/OFF