Being pretty new to SQL Server accidential DBA is what I have read, I am wondering what are some good books to read to learn about performance tuning. What are you all reading? Also how can someone like me that is new to SQL really start learning this stuff. Since I am mostly a Sys Admin my boss will not spend the money to send me to a SQL class, he would rather me go to Windows 2008 training instead. I really like the SQL stuff. It is fun and exciting, plus when someone needs some data and I can fetch it I feel like the quater back. Any help and advice.
asked Sep 30, 2010 at 04:40 PM in Default
I am currently reading
SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey and Sajal Dam
I also ordered a copy of
Performance Tuning with SQL Server Dynamic Management Views by Louis Davidson and Tim Ford
this week from Amazon. I got my email today saying it should be here Oct 4th. I can't wait. DMV's are very powerful and can tell you so much about your server and performance. Between these two books I hope to learn more than I could ever use for performance tuning.
My advice is read as much as you can, practice as much as you can in development environments and attend what training you can. Between free online webcasts, sqlsaturdays, and other PASS events such as local chapters there really is no excuse for not furthering ones SQL knowledge. If you have a local PASS chapter in your area start attending the meetings. They give away a bunch of stuff and books is one of the top items at my chapter. If you have to purchase them Amazon is your best friend.
Also get on twitter. There is a huge SQL community on Twitter. Folks post links to awesome blogs all the time. Be careful though, all this stuff is very addictive so be warned.
I wish you the best of luck in your career and look forward to seeing more of you on SSC. Keep the questions coming.
I strongly recommend getting a copy of Itzik Ben-Gan's book, Inside T-SQL Querying. If you really want to know how to write SQL code the right way, the first time, that's the book to learn it from. It'll make a huge difference in your understanding of SQL Server and how you write your code.
answered Sep 30, 2010 at 06:24 PM
Grant Fritchey ♦♦
All good answers; no surprise there. This question is really more a candidate for the main SSC site forums than here as there is no single correct answer.
That being said... I have read pretty well all the recommendations provided cover to cover (well almost - 3/4s of the way through Grant's 2008 Distiller) and enjoyed them all.
Two other sources I would suggest are Kalen Delaney and her who's who of the SQL Server world co-authors and the SQL Server Internals set of books if you really want to understand how SQL Server works - I've been a fan since the 7.0 version. This, and my next point, help you understand the other books and put it all together.
Another undervalued resource is Books Online, which can be installed on your system or perused over the 'net: BOL
And as I am fond of saying: READ, READ, READ! It's all an investment in yourself.
answered Oct 01, 2010 at 06:03 AM
There are lots of good suggestions for books out on this list, and I know that is what you were asking for, but let me point out the value of articles and periodicals.
Generally, SQL Server Magazine, SQLServerCentral.com, and simple-talk.com all have very good articles on performance tuning and I read them all regularly.
Specifically, you may want to look at An Informal Look at Database Performance (http://www.sqlservercentral.com/articles/Performance/71001/). Of course I am biased on that one since I wrote it. I also included a lot of links in there to other articles on performance.
Jeff Moden ( http://www.sqlservercentral.com/Authors/Articles/Jeff_Moden/80567/ ) has some fantastic articles about query performance that are all worth reading. I keep aspiring to bring my articles up to his level in terms of orginality, technical depth, and clarity of explanation and have not come close yet.
And finally, look at Finding the Causes of Poor Performance in SQL Server, Part 1 by Gail Shaw (http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/) and its follow up in part 2. Those two have been tremendously helpful to me. Gail Shaw also has articles on indexes and other topics that are tied in to performance that are well worth reading.
And while not about performance per se, I always recommend every database programmer read The Curse and Blessing of Dynamic SQL (http://www.sommarskog.se/dynamic_sql.html ).
answered Oct 01, 2010 at 10:29 AM
To be good in performance tuning you should have sound knowledge in the following areas
SQL Server Architecture and Internals (Storage Engine, SQL OS, Memory Management etc)