question

Sagar Bhargava avatar image
Sagar Bhargava asked

3rd Party SQL Server management tools

HI,

I am interested to know which are the most popular 3rd Party tools used by DBA's around the world to manage SQL Server in the day to day tasks - from backup to health monitoring.

sql-serverclient-tools
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

It's pretty arbitrary and you'll get a different list from everyone. I'll toss mine in. I love Red Gate. I use a number of tools in their tool belt on a daily basis. SQL Prompt, SQL Compare are open on my desktop most of the time. (Disclosure, I rave about Red Gate so much, I'm a member of the "Friends of Red Gate" program). I also use Idera's Diagnostic Manager on a regular basis. Finally, I've been using a new tool called Confio Ignite. It's a pretty special little monitoring tool that mainly collects data on wait stats and uses those to identify the worst performing queries on your system.

Those are my principal tools. I have a few others that I use occasionally, but those are the ones that are worth mentioning.

1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I'm a big fan of the Redgate bits that I've tried, and would love to have the budget to buy a few more of their tools (heck, just to upgrade the one I've already got...)
0 Likes 0 ·
DaniSQL avatar image
DaniSQL answered

currently I use Idera's Diagnostic Manager and Admin toolset. I have also tried for a while tools from Quest(spotlight) and Redgate and SQL Sentry.


Edit: Never tried 3rd party backup tool before but Quests light speed and Red-gate backup pro seems the industry standard.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

Pretty unsurprisingly, I use the ones I wrote... :)

2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Hey Matt, Do you have monitoring tools too or just tools for development/deployment?
0 Likes 0 ·
I was going to make a monitoring tool - but I don't think I could do anything better than Confio Ignite, so I'm not seeing the point right now :)
0 Likes 0 ·
AlexTheDeveloper avatar image
AlexTheDeveloper answered
Hi, I have built free SQL Server 2008/2012 tool [**SQL Hunting Dog**][1]. SQL Hunting Dog is not an alternative to Red Gate Search or SSMS Toolpack. It is more a productivity addin which give your fast and smooth search inside SQL Server Management Studio (2008 or 2012). See an independent review [here][2] [1]: http://sql-hunting-dog.com [2]: http://sqlraid.wordpress.com/2013/08/05/sql-hunting-dog-search-tool-for-ssms-quick-test/
2 comments
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

You should add a disclaimer that this is your own product, otherwise this could be removed as advertising spam
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.