Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

What are best tools to tune the Performance of Query in MS Sql Server?

user-image
Question ajoutée par Bhanu Pratap Singh , LEAD DATA ENGINEER , SYVEN GLOBAL SERVICES PVT. LTD.
Date de publication: 2016/02/12
Belal AL-Hifawi
par Belal AL-Hifawi , Technical Team leader , PIONEERS TECH SOFT

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)

 

 

 

Utilisateur supprimé
par Utilisateur supprimé

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

More Questions Like This