Where do you start with SQL Server performance tuning?

Performance tuning is the methodology of systematically identifying bottlenecks in applications, and improving performance. There are some places to start with performance testing. Performance for an application can be a problem on various dimensions: Operating system, deployment (such as physical and virtual), platform (such as web server and frameworks used), database, and configuration settings. It is possible to tune each of the above dimensions in different ways and configurations. However, in essence, performance tuning is fundamentally about proper planning. Also, performance tuning is an art. Most often we are pushed to explore new ways to do performance tuning and testing.

Read the 10-page whitepaper “Beginning performance tuning with Pinal Dave to learn about performance tuning, its process, and the top six SQL Server tools. It looks at a possible approach to performance troubleshooting. Start from essential tools to find a high-level problem area, and then dig deep into solving the problem. The idea is to make the primary initial diagnosis, perform proper tests, and finally find what would be a proper solution to performance problems in SQL Server databases.

Click here to download the whitepaper.

The author, Pinal Dave, is a developer evangelist and technology enthusiast. He has authored 11 SQL Server database books, taught 11 Pluralsight courses, and has written over 2900 articles on database technology on his blog at “blog.sqlauthority.com”. Along with more than nine years of hands-on experience, he holds a Master’s of Science degree, and some certifications, including Microsoft Certified Technology Specialist (MCTS), Microsoft Certified Database Administrator (MCDBA), and Microsoft Certified Solutions Developer (MCSD) for the .NET framework.

SQL Doctor

SQL Doctor tunes SQL Server performance, security, and disaster recovery via expert recommendations in physical, virtual, and cloud environments - including managed cloud databases. Unlike its competitors, it displays the health of all SQL Servers, generates ready-to-run SQL scripts to optimize and undo optimization, limits the analysis to specified databases, applications, and performance categories, and provides real-time, as-needed, and scheduled checkups.

For SQL Doctor:

Save almost 40% off the regular price when you purchase online. Take advantage of this limited time offer and pay only $400 per user with the first year of maintenance included! Hurry, this offer ends November 30th! Save Now!

 

Anonymous