Transcript Intro to Performance Tuning

Intro to SQL Server
Performance Tuning
By Robert Biddle
About Me
• Working with SQL Server for over 10 years.
• Data Architect for Hilton Grand Vacations
• Certified
• MCITP Database Administrator
• MCITP Database Developer
• Author
• http://www.mssqltips.com/sqlserverauthor/133/robert-biddle/
• Contact
• Blog: http://robbiddle.wordpress.com
• Twitter: @robert_biddle
• Email: [email protected]
Agenda
•
•
•
•
•
Locking and Blocking
Detecting Long-running queries
Things to look out for!
Find indexes that are missing
SQL Profiler
Locking and Blocking
• Normal intended behavior
• Can be a problem if durations are high
Demo
More Reading, Tools, & Contact Info
• Blog: Jonathan Kehayias (performance tuning, extended events, and more)
(https://www.sqlskills.com/blogs/jonathan/)
• Ola Hallengren’s Free SQL Server Maintenance Solution
(https://ola.hallengren.com)
• sp_WhoIsActive by Adam Machanic (free monitoring script)
(http://sqlblog.com/files/default.aspx)
• SQL Server Execution Plans by Grant Fritchey (free e-book)
(http://www.red-gate.com/community/books/sql-server-execution-plans-ed-2)
• SQL Sentry Plan Explorer (http://www.sqlsentry.com)
• Contact Info
• Blog: http://robbiddle.wordpress.com
• Twitter: @robert_biddle
• Email: [email protected]