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 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.
The 14-page whitepaper “Six SQL Server Performance Boosters with Your Existing Hardware” raises awareness of potential performance boosting opportunities, provides background information and context for evaluating the effectiveness f these techniques, and outlines some fundamental approaches and performance benefits that stem from implementing these approaches where applicable.
The authors are:
- 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.
- Eric Blinn is the Senior Database Architect at Squire Patton Boggs, an international law firm with 47 offices in 20 countries, based out of Cleveland, Ohio. He is a content creator and facilitator for the data track at DriveIT, an IT training firm based in Akron, Ohio. Eric is an active member of the SQL Server community and currently serves as the Vice President of the Ohio North PASS Local Group. He has spoken on SQL Server topics at some technology conferences and training events. When not working on SQL Server Eric enjoys smoked meats and going fishing with his family.
- Daniel Janik is an independent consultant from Austin, TX and a two-time Microsoft Data Platform Most Valued Professional. He has been supporting SQL Server solutions in many roles from database administrator to developer over his 20-year career. Daniel is also former Microsoft and was a Premier Field Engineer for six years. He speaks regularly at SQL Saturday events and user groups. Find him on his blog SQLTechBlog.com.
Monitor the performance of SQL Server for physical, virtual, and cloud environments with SQL Diagnostic Manager with proactive alerting, prescriptive analysis, and comprehensive reporting.
View the infographic “Why Use SQL Diagnostic Manager”, read a case study, browse the datasheet, download a fully functioning 14-day trial, request a one-on-one demonstration, and request a price quotation.