Compare SQL Diagnostic Manager и TablePlus

Benefits:

Using SQL Diagnostic Manager, reducing business impact, the ideal tool for monitoring the physical and virtual database, proactive notification bri... Read more

Using SQL Diagnostic Manager, reducing business impact, the ideal tool for monitoring the physical and virtual database, proactive notification brings you health and performance issues on the device you use, in my desktop case.

Drawbacks:

Only software adjustment for start-up, if you need support, can have a headache.

Summary:

Benefits:

The software is simple to install and configure. Out of the box, you run the installer, add your licenses and apply the default template to start ... Read more

The software is simple to install and configure. Out of the box, you run the installer, add your licenses and apply the default template to start monitoring your SQL instances. You can then create custom monitoring templates that you can apply to specific instances and really narrow down on those things that are of the most important to you. The product supports physical and virtual instances of SQL and I've used it with SQL 2008 through to SQL 2017. You can even monitor the virtual hosts resources via their integration. The realtime capturing of queries, plans, and deadlocks is excellent. In the event of an issue, you can narrow down to a specific point in time and focus on those things impacting your SQL instance. You can see the queries that were running, the locks that were being held and so much more. This feature has saved me on more than one occasion. The dashboard provides you with a really useful visual reference that you can leave running on a dedicated screen. You get regularly updated statistics about how your server is performing. In combination with the desktop warnings, you can react quickly to any developing issues.

Drawbacks:

As with most off the shelf software, SQL diagnostic Manager is most things you need in most cases. It does come with a default template that you c... Read more

As with most off the shelf software, SQL diagnostic Manager is most things you need in most cases. It does come with a default template that you can use. Be prepared though for some fine-tuning as you get more familiar with how the software works. I've had one issue with the software since purchase. I didn't find their Tier 1 support to be very good but once escalated my issue was resolved.

Summary:

Overall, this is an excellent product and my experience with it has been very positive. The product offers real-time, meaningful insights into how... Read more

Overall, this is an excellent product and my experience with it has been very positive. The product offers real-time, meaningful insights into how your SQL instances are performing and behaving. These insights are essential in any enterprise and critical if you want to respond in a timely manner to emerging problems. Being able to go back in time and investigate situational issues is also a godsend.

Benefits:

Drawbacks:

Summary:

We have been using this tool since more than an year now... Have found following pros and cons: Pros: Gives you index fragmentation, table gro... Read more

We have been using this tool since more than an year now... Have found following pros and cons: Pros: Gives you index fragmentation, table growth , table size growth info and saves u lot of time We also use it for monitoring deadlocks or adhoc queries locking up our system. Cons: Not user friendly at all Takes lot longer to load up and start showing the graphs Half the time it times out and says no data to show.. Had issues receiving alerts which we set up User manual doesn't give complete description of metrics Overall the experience was not as smooth as we thought..

Benefits:

I have been using the diag tool for past few years now and I completely satisfy with the in-depth and detail metrics it has to keep track of all th... Read more

I have been using the diag tool for past few years now and I completely satisfy with the in-depth and detail metrics it has to keep track of all the events happening on SQL server which other wise we have to either do it thorough extended event or trace. it helps me detect the problem before the user reports it and help us to stay proactive and recover quickly if any failure.

Drawbacks:

its hard to tell what I don't like about this software.

Summary:

it was times when server was down, database is offline, jobs are timing out any issue i was able to find the root cause in the tool and was able to... Read more

it was times when server was down, database is offline, jobs are timing out any issue i was able to find the root cause in the tool and was able to fix it and this is something very useful for business to recover quick in case of failure.

Benefits:

Nice and user-friendly UI. Native support for pretty much all the popular databases. Easy to use. Quite powerful freemium functionality so you can ... Read more

Nice and user-friendly UI. Native support for pretty much all the popular databases. Easy to use. Quite powerful freemium functionality so you can try before you buy and might not have to buy at all depending on use-case.

Drawbacks:

Supporting a wide range of databases mean that it's hard to create a cohesive UI experience for all of them. The UI is probably most suited for rel... Read more

Supporting a wide range of databases mean that it's hard to create a cohesive UI experience for all of them. The UI is probably most suited for relational databases like Postgres / MySQL while simple key value stores like Redis might not be as fitting.

Summary:

Wonderful. Before discovering TablePlus I used a bunch of different database UI tools for various databases but TablePlus allowed me to have a sing... Read more

Wonderful. Before discovering TablePlus I used a bunch of different database UI tools for various databases but TablePlus allowed me to have a single go-to tool for all of them.

Benefits:

TablePlus is super easy and intuitive to use, looks good and works without issues.

Drawbacks:

Free version is a bit limited which is annoying but understandable.

Summary:

I would recommend TablePlus to anyone looking for solid database client.

Benefits:

- very aesthetically pleasing - query history is helpful - works well with local databases

Drawbacks:

when interacting with non-local databases: - all windows will randomly close. that is, even when my cpu is running fine and has more than plenty of... Read more

when interacting with non-local databases: - all windows will randomly close. that is, even when my cpu is running fine and has more than plenty of memory, and other applications have no problems at all - regardless of database, I rarely have the ability to kill a query. during times when I somehow do have the option to kill a query, it will take many minutes to 'load' the query before you have the option of killing it. making it pointless. - they have only one person to contact for support, [SENSITIVE CONTENT HIDDEN], and he just doesn't have an answer for things that are very reasonably considered to be basic features in other sql clients (like why it works for me to *near instantly* kill queries with literally any other software (data grip, postico, etc) that I've downloaded) - they thought it was best not to include the file name in the ribbon of an open file, making it hard to edit multiple things at once - you can't create a new scratch within the same workspace without first opening up the left window pane to reveal the button to do so - other bs that makes it very easy to overlook the visual appeal of this gui

Summary:

I only used this app in the first place because I hate how cluttered and ugly other apps, like data grip, are. At first I tested Tableplus on a loc... Read more

I only used this app in the first place because I hate how cluttered and ugly other apps, like data grip, are. At first I tested Tableplus on a local database and everything was awesome. I thought I had found my new sql editor and I was thrilled because this interface looks fantastic. However, when it came time to do actual work, this software is undoubtedly a pretender and not a contender. Or at this time, at least (March 2020). See reasons in the con section. Hopefully they figure it out, because they're on the right track visually, but I don't understand how other reviewers can reasonably give this software three stars given its limitations

Benefits:

It has a great autocomplete for SQL query and can manage migration really well. I also like a backup system I can use before doing a dig into a dat... Read more

It has a great autocomplete for SQL query and can manage migration really well. I also like a backup system I can use before doing a dig into a database to make sure I don't end up without data.

Drawbacks:

The free tier was really annoying to use. Also, I miss some shortcuts to switch between tabs on big projects.

Summary:

I hated the free tier as it was really limiting but paid plan works great.