使用SQL Server 2014进行SQL调优 [英] SQL tuning with SQL Server 2014

问题描述

Hi Team，

我已经开始使用我们使用SQL Server 2014的项目之一，并且需要进行性能调整。需要一些帮助来设置一些脚本。 

1。上个月需要SQL查询表现不佳。

2。需要检查指数质量。

3。需要检查我们是否可以更改任何参数。

请帮助解决这些问题。

谢谢，

brijesh 

解决方案

有一些第三方工具可供执行这个。看看这个

https://www.pcwdld.com/best-sql-server-performance-monitoring-tools

Hi Team,

I have started working with one of the project where we are using SQL server 2014 and performance tuning is required. Need some help to setup some script. 

1. Need last month SQL queries which was behaving badly.

2. Need to check Index quality.

3. Need to check if any parameter can we make change.

Please can you help on those points.

Thanks,

brijesh 

解决方案

There are some third party tools available to perform this. Check this out

https://www.pcwdld.com/best-sql-server-performance-monitoring-tools

这篇关于使用SQL Server 2014进行SQL调优的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！