Table of Contents
Note: If you buy something from our links, we might earn a commission. See our disclosure statement.
I have already mentioned in my previous post, that SQL Server performance tuning is a broad topic and cannot be completed in one blog post. My previous post is all about performance data capture and analysis. In this post, I will talk about the various tools that is available for most of the SQL Server versions and releases.
Here is my list of SQL Server tools which are free to use and can help you to manage and monitor SQL Server performance.
What to do?Identify the queries taking High CPU using above toolsCheck Stats info. Check Missing Index infoCheck for DTA recommendationsManually tune the query.
Identify the queries taking High CPU using above tools
Check Stats info. Check Missing Index info
Check for DTA recommendations
Manually tune the query.
Performance monitor is used to uncover resource limits in the following:
Comments are closed.