Home All Groups Group Topic Archive Search About

book on performance tuning

Author
2 Jun 2005 4:10 PM
ChrisR
I need to sharpen my performance tuning skills... fast. Does anyone know of
a good book for this? I don't need a book to tell me where to put Indexes. I
need a book that will tell me "if you see this in the Graphical Eecution
Plan, re-write your code like this". Is there such a thing?

Also, is it possible to be a top notch query tuner without being a top notch
Developer? Im not a top notch Developer, but the query tuning is defiantley
on my shoulders. Ive always gotten by... but want to take these skills to
the next level.


TIA, ChrisR

Author
2 Jun 2005 4:30 PM
Rick Sawtell
Show quote Hide quote
"ChrisR" <noem***@bla.com> wrote in message
news:#Qidm24ZFHA.3596@tk2msftngp13.phx.gbl...
> I need to sharpen my performance tuning skills... fast. Does anyone know
of
> a good book for this? I don't need a book to tell me where to put Indexes.
I
> need a book that will tell me "if you see this in the Graphical Eecution
> Plan, re-write your code like this". Is there such a thing?
>
> Also, is it possible to be a top notch query tuner without being a top
notch
> Developer? Im not a top notch Developer, but the query tuning is
defiantley
> on my shoulders. Ive always gotten by... but want to take these skills to
> the next level.
>
>
> TIA, ChrisR
>
>


I don't know of any good books....

This site is excellent however.

http://www.sql-server-performance.com



Rick Sawtell
MCT, MCSD, MCDBA
Are all your drivers up to date? click for free checkup

Author
2 Jun 2005 4:37 PM
NH
I would recomment SQL Server Query Performance Tuning Distilled (orginally
from Curlingstone publishers, now from Apress I think).

I found that an excellent book. I think the way you get to the next level is
through experience, you wont get that in any book. Books can only take you so
far, they are excellent to a point.

Also, for those kind of questions "if you see this in the Graphical Eecution
Show quoteHide quote
> Plan, re-write your code like this" you'll get the best advice from forums like this one.

"ChrisR" wrote:

> I need to sharpen my performance tuning skills... fast. Does anyone know of
> a good book for this? I don't need a book to tell me where to put Indexes. I
> need a book that will tell me "if you see this in the Graphical Eecution
> Plan, re-write your code like this". Is there such a thing?
>
> Also, is it possible to be a top notch query tuner without being a top notch
> Developer? Im not a top notch Developer, but the query tuning is defiantley
> on my shoulders. Ive always gotten by... but want to take these skills to
> the next level.
>
>
> TIA, ChrisR
>
>
>
Author
2 Jun 2005 8:30 PM
Armando Prato
Great book.... it has practical examples that illustrate the material
covered.

I recommend it also!

"NH" <N*@discussions.microsoft.com> wrote in message
news:AF77B42A-4151-4611-B56A-05C3A4FA94EF@microsoft.com...
> I would recomment SQL Server Query Performance Tuning Distilled (orginally
> from Curlingstone publishers, now from Apress I think).
>
> I found that an excellent book. I think the way you get to the next level
is
> through experience, you wont get that in any book. Books can only take you
so
> far, they are excellent to a point.
>
> Also, for those kind of questions "if you see this in the Graphical
Eecution
> > Plan, re-write your code like this" you'll get the best advice from
forums like this one.
Show quoteHide quote
>
> "ChrisR" wrote:
>
> > I need to sharpen my performance tuning skills... fast. Does anyone know
of
> > a good book for this? I don't need a book to tell me where to put
Indexes. I
> > need a book that will tell me "if you see this in the Graphical Eecution
> > Plan, re-write your code like this". Is there such a thing?
> >
> > Also, is it possible to be a top notch query tuner without being a top
notch
> > Developer? Im not a top notch Developer, but the query tuning is
defiantley
> > on my shoulders. Ive always gotten by... but want to take these skills
to
> > the next level.
> >
> >
> > TIA, ChrisR
> >
> >
> >
Author
3 Jun 2005 2:37 PM
ChrisR
I think I'm gonna go with this one. I was just reading Amazon reviews on
this and several other books on this topic. A lot of reviews for this book
mention that screen prints are provided of the Exec Plan, Profiler, etc.
Therefore its not just theoretical, but practical. Too much theory puts me
to sleep.

Thanks guys.




Show quoteHide quote
"Armando Prato" <apr***@REMOVEMEkronos.com> wrote in message
news:u5dAkH7ZFHA.3400@tk2msftngp13.phx.gbl...
> Great book.... it has practical examples that illustrate the material
> covered.
>
> I recommend it also!
>
> "NH" <N*@discussions.microsoft.com> wrote in message
> news:AF77B42A-4151-4611-B56A-05C3A4FA94EF@microsoft.com...
> > I would recomment SQL Server Query Performance Tuning Distilled
(orginally
> > from Curlingstone publishers, now from Apress I think).
> >
> > I found that an excellent book. I think the way you get to the next
level
> is
> > through experience, you wont get that in any book. Books can only take
you
> so
> > far, they are excellent to a point.
> >
> > Also, for those kind of questions "if you see this in the Graphical
> Eecution
> > > Plan, re-write your code like this" you'll get the best advice from
> forums like this one.
> >
> > "ChrisR" wrote:
> >
> > > I need to sharpen my performance tuning skills... fast. Does anyone
know
> of
> > > a good book for this? I don't need a book to tell me where to put
> Indexes. I
> > > need a book that will tell me "if you see this in the Graphical
Eecution
> > > Plan, re-write your code like this". Is there such a thing?
> > >
> > > Also, is it possible to be a top notch query tuner without being a top
> notch
> > > Developer? Im not a top notch Developer, but the query tuning is
> defiantley
> > > on my shoulders. Ive always gotten by... but want to take these skills
> to
> > > the next level.
> > >
> > >
> > > TIA, ChrisR
> > >
> > >
> > >
>
>
Author
2 Jun 2005 6:45 PM
JT
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook

      Ken England


http://search.barnesandnoble.com/booksearch/isbnInquiry.asp?userid=xT7bjiZBkQ&isbn=1555582419&itm=5


Show quoteHide quote
"ChrisR" <noem***@bla.com> wrote in message
news:%23Qidm24ZFHA.3596@tk2msftngp13.phx.gbl...
> I need to sharpen my performance tuning skills... fast. Does anyone know
of
> a good book for this? I don't need a book to tell me where to put Indexes.
I
> need a book that will tell me "if you see this in the Graphical Eecution
> Plan, re-write your code like this". Is there such a thing?
>
> Also, is it possible to be a top notch query tuner without being a top
notch
> Developer? Im not a top notch Developer, but the query tuning is
defiantley
> on my shoulders. Ive always gotten by... but want to take these skills to
> the next level.
>
>
> TIA, ChrisR
>
>

Bookmark and Share