SQL 2005 Performance tuning supporting 3rd party application
-
I have been so focused on supporting our current SQL 2000 environment that I am falling behind on my SQL 2005 skillset to support a high end SAN. We will be upgrading to 2005 on this clustered environment soon. I am worried that my troubleshooting techniques might not work the same for 2005. Can anyone recommend any articles or books based upon my dillemma? Thanks.
-
I would recommend Microsoft Press Inside Microsoft SQL Server 2005 T-SQL Querying.
ISBN: 0735623139
That will help you tremendously in getting up to speed on SQL 2005 as well as your troubleshooting techniques.
Christopher Ford
-
I don't have anything specifically on SAN or clustered environments, but here are some links to get you started. I have found them, especially the 1st one, to be very useful:
SQL Server - Uncover Hidden Data to Optimize Application Performance:
http://msdn.microsoft.com/msdnmag/issues/08/01/SqlDmvs/default.aspx
SQL Server 2005 Waits and Queues - SQL Server Best Practices Article:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/performance_tuning_waits_queues.mspx
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url] -
Christopher Ford (2/19/2008)
I would recommend Microsoft Press Inside Microsoft SQL Server 2005 T-SQL Querying.ISBN: 0735623139
That will help you tremendously in getting up to speed on SQL 2005 as well as your troubleshooting techniques.
Great book!
Chapter 3 deals specifically with query tuning.
Chapter 5 - Joins and Set Operations - is loaded with useful info.
Also, Kalen Delaney has published a book in the same series recently, specifically on performance tuning and optimization.
__________________________________________________________________________________
SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
Persisting SQL Server Index-Usage Statistics with MERGE[/url]
Turbocharge Your Database Maintenance With Service Broker: Part 2[/url] -
it depends exactly what it is you're looking for. The microsoft blogs are probably your best bet although 2005 is starting to be old stuff now. the sql cat team publish / list a wide range of white papers I'd suggest this is the best place to start. I have a number of sql 2005 books but I'm not sure there's any one book I'd recommend, the inside books were always a great point of reference but expanding to 6 or 7 volumes for 2005 sort of invalidated the usefulness - takes too long to figure out which one has what you need.
http://sqlcat.com/Default.aspx
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/ -
If this is your first foray into the SAN world, get ready for disappointment and frustration. Each of my last 3 primary clients jumped onto the SAN bandwagon and were EXTREMELY unhappy with performance! There are SOOOO many ways you can do things suboptimally.
The Query Tuning and Optimization book in the Inside SQL Server 2005 series is pretty good.
Get familiar with the Dynamic Management Views. BOL has some good stuff here, including a cross-reference to the 2000 tables/functions they replace. Many of the DMVs though expose information that simply wasn't available in earlier versions.
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply