Register now or log in to join your professional community.
Performance tuning is need more than specific or one tool, Because is affected by many things not only the database structure.
To tune database we need to understand what is the reason for bad performance:
1- Index and statistics.
2- Query and Stored procedure design.
3- Hardware and network.
4- Database Maintenance.
5- Applications connected to database
Following are major tools which i used often i provide a good article for each:
1- Execution plan
https://technet.microsoft.com/en-us/library/ms(v=sql.).aspx
2- Database Engine Tuning Advisor analyzes
https://msdn.microsoft.com/en-us/library/hh.aspx
3- Activity Monitor
https://www.mssqltips.com/sqlservertip//performance-analysis-using-sql-server--activity-monitor-tool/
4- Performance Monitor. (Windows tool)
Microsoft SQL Server provides a comprehensive set of tools for monitoring events in SQL Server and for tuning the physical database design. The choice of tool depends on the type of monitoring or tuning to be done and the particular events to be monitored.. For more details please go through the link
https://msdn.microsoft.com/en-us/library/ms.aspx
