Tool to Analyze SQL Server performance [closed]

Question

Is there any 3rd party tool which works like another layer on top of SQL Server, which can analyze the behaviour of the database and make recommendations based on that?

Thanks

Answer 1

Qure from DBSophic does a great job at what you describe. You can also bundle it with our tools (for a much more cost effective offering), SQL Sentry Event Manager and Performance Advisor, which provide general around the clock performance monitoring and alerting (these tools are mostly for use by DBAs, and don't provide automatic optimizations the way Qure can).

http://www.dbsophic.com/

http://www.sqlsentry.net/

https://sqlblog.org/2011/04/21/using-qure-workload-optimizer-for-sql-sentry

Answer 2

Late answer but can be helpful to other readers, I hope

In addition the solutions already mentioned, I can recommend ApexSQL Monitor This tool will allow you to define custom metrics you want to track (in addition to numerous predefined metrics for the System, SQL Server and Database).

ApexSQL Monitor can also show the slowest queries executing on the SQL Server. It stores individual wait statistics for the single query, and by analyzing waits, you can detect the reasons of slow performing queries. It can also show the query execution plan at the time of execution, which will provide you even more info about slow executing queries.