Nearly all successful applications can benefit from the performance-driven strategies outlined in this whitepaper. Many of the categories and items discussed contain easy wins that can boost SQL Server performance and scalability with far less effort than expected. The techniques outlined here can also serve as a checklist for determining whether it is time to consider throwing more hardware or other resources (such as consultants, third-party solutions, and so on) at a problem.
This whitepaper raises awareness of potential performance-boosting opportunities, provides background information and context for evaluating the effectiveness of these techniques, and outlines some fundamental approaches and performance benefits that stem from implementing these approaches where applicable.
Presenter: Mindy Curnutt Mindy Curnutt is a business owner and five-time Microsoft Data Platform Most Valued Professional and has been involved in the SQL Community for 20+ years. She has been an SME on multiple MS SQL Server Cert Exams and is the co-author of 4 books, most recently MS Press SQL Server 2017 Administration Inside-Out. She is the President of the North Texas SQL Server User’s Group, a national public speaker and active Girls and STEM volunteer and mentor. Find Mindy often in her hometown of Dallas, TX at the Sons of Hermann Hall Acoustic Picker’s Jam on Thursday nights.
Register to read the full whitepaper.
Topics: Database Performance Products: SQL Server Tools for Better Performance , SQL Diagnostic Manager for SQL Server