I actually prefer the Apex formatter tool as it's more in depth, but I can't speak to the rest of their tools. The Redgate tool suite is awesome, but I've found you can get comparable tools from Apex. It also describes to use Oracle Performance Analyzer to tune applications using Oracle Database. Integrate SQL code complete, snippets and more into SSMS and Visual Studio. Analyze database dependencies and create SQL join relationship visualization. This tutorial describes to use SQL Tuning Advisor to tune ad-hoc SQL statements in Visual Studio. ApexSQL Fundamentals Toolkit for SQL Server. Redgate is worth checking out as is Idera, I've used the Redgate toolbelt for about 4 years now and I've only done some trial work in Idera. NET Applications in Visual Studio with SQL Tuning Advisor and Oracle Performance Analyzer. So I'd weigh it against, do you need rock solid alerting and monitoring or rock solid performance tuning? Are either of those features redundant in other tools you have in the office? I haven't seen any other tools give this well of a breakout of system / database resources utilized and who utilized what, it makes tuning and performance monitoring incredibly easy.

DPA can do this too, but not nearly as well.ĭPA is fantastic for performance tuning, what sets it apart from SentryOne is the individual breakout of wait time statistics that are not always easy to pull out or time without additional effort. SentryOne is fantastic for monitoring / alerting and replaying the seen of the crime.

They are apples and oranges, while they both do the same thing, each of them do specific things better. I've used SentryOne and DPA in excruciating depth. with access to management utilities like the SQL Server Management Studio (or Enterprise Manager and Query Analyzer in SQL Server 2000 and below). ApexSQL is a comprehensive tool set that streamlines and automates SQL Server database management and development processes.

Apex sql analyzer