Tool to Analyze SQL Server performance [closed]

Closed. This question is seeking recommendations for books, tools, software libraries, and more. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

---

We don’t allow questions seeking recommendations for books, tools, software libraries, and more. You can edit the question so it can be answered with facts and citations.

Closed 7 years ago.

开发者_开发知识库 Improve this 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

---

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

---

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.

---

If its more generic monitoring your after, such as current load, flagging jobs that take longer than usual etc, there are some pretty decent 3rd party tools, Red Gates SQL Monitor is pretty cool, demo here: http://monitor.red-gate.com/

---

You can use SQL Server Profiler (not 3rd party) to see queries/procedures/etc and how slow/heavy they are. It won't give you any recommendations but you can take further actions once you see where the problems lie.

---

In lieu of a DBA SQL Server ships with a Database Engine Tuning Advisor.

... After analyzing a workload, Database Engine Tuning Advisor can recommend that you add, remove, or modify physical design structures in your databases. The advisor can also recommend ...