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

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