Whitepaper : 6 SQL Server Performance Boosters for Your Hardware
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.
This whitepaper 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.
- Whitepaper: 5 Reasons Your SQL Server is Slow
- Whitepaper: Performance Enhancements Made with SQL Server 2014
- Whitepaper: The Top 4 Performance Makers and Breakers for SQL Server
- Webcast: How to Catch SQL Server Performance Troublemakers
- Webcast: Kick Start SQL Server 2016 Performance Tips and Tricks
- Webcast: SQL Server Performance Made Easy
- Webcast: Top 10 SQL Server Performance Makers and Breakers
- Webcast: Dealing with Network Latency Issues and the impact on SQL Server Performance
- Webcast: Maximizing Microsoft SQL Server Performance
- Webcast: Performance in 60 Seconds – SQL Tricks Everybody MUST Know
- Webcast: SQL Server Constraints for Integrity and Performance
- Webcast: SQL Server Performance and Scalability
- Webcast: What You Need to Know About Managing Your SQL Server Performance
Mindy Curnutt is a business owner and 5X Microsoft Data Platform MVP 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. You can often find Mindy in her hometown of Dallas, TX at the Sons of Hermann Hall Acoustic Picker’s Jam on Thursday nights.
24X7 SQL performance monitoring, alerting and diagnostics
- Monitor performance for physical, virtual, and cloud environments.
- Monitor queries and query plans to see the causes of blocks and deadlocks.
- Monitor application transactions with SQL Workload Analysis add-on.
- View expert recommendations from SQL Doctor to optimize performance.
- Alert predictively with settings to avoid false alerts.
- View summary of top issues and alerts with the web console add-on.