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.
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.
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)## - Books Microsoft Press Microsoft SQL Server 2008 Internals, A Microsoft press release - SQL Server 2008 Internals & T-Shooting. Wrox Release. ## Query Optimizer, Execution Plans and Query Performance Tuning## SQL Server 2008 Query Performance Tuning Distilled by Grant Fritchey and Sajal Dam ## SQL Server Profiler ## Mastering SQL Server Profiler By Brad McGehee
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. :