September 19, 2005 at 9:14 am
Hello, I'm looking for some resources to learn how to optimize queries. Understand how the indexes are being used. How to understand the query execution plan. How to use Profiler...etc etc.
Thanks for your help. Shawn
September 19, 2005 at 11:40 am
Try SQL Server Query Performance Tuning Distilled by Sajal Dam. It's published by Apress ISBN 1-59059-421-5.
Otto Schreibke
The future is a foreign country, they do things differently there.
(Stolen from Arthur C Clarke)
September 20, 2005 at 3:47 am
Hi Shawn,
You can maybe also have a look at the following guide ("Improving .NET Application Performance and Scalability") from the patterns & practices site from Microsoft:
There is a chapter dedicated to "Improving SQL Server Performance":
Hope this will help you...
Olivier
See us at http://www.ctg.com
September 20, 2005 at 7:06 am
Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook by Ken England, Digital Press, ISBN1-55558-241-9. Has chapters on storage, indexing, the optimizer, locking, monitoring.
September 20, 2005 at 7:13 am
This one (High Performance SQL Server DBA) is good for mapping out an overall performance strategy, plus it has a lot of good scripts/tips included:
September 20, 2005 at 8:42 am
Thank you everyone for your replies. I have ordered the first book listed and am checking into the other resources provided.
Thanks again.
Shawn
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply