InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 14:02:30 GMT20http://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxDepends on the budget i'd say . there are plenty of tools out there but for the list mentioned by the OP I would simply use CMS and write my own queries setup SSRS too if I had the time :-DWed, 02 Jan 2013 05:10:17 GMTJayanth_Kuruphttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxDetermining the "best" tool really is a part of determining what your needs are. The different tools out there are all pretty good, but they do things differently and delivery different things. You need to understand what you want out of the software and that will make choosing the best one for you easier.Full disclosure, I work for Red Gate software.I would split the tool sets into full-featured, enterprise-level monitoring, and small to mid-range monitoring. On the high end, I can't recommend SQL Sentry enough. Great piece of software written and supported by great people. But, it's expensive and if you're in a small shop, it might be massive overkill. For small shops with more limited needs, I recommend you take a look at [url=http://www.red-gate.com/products/dba/sql-monitor/]Red Gate's SQL Monitor[/url]. It's a good piece of software. You can download it and install it for free and check it out for a few days, see if it does what you want.Wed, 02 Jan 2013 04:53:32 GMTGrant Fritcheyhttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspx[quote][b]Scott D. Jacobson (12/31/2012)[/b][hr][quote][b]opc.three (12/31/2012)[/b][hr]I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of SQL Sentry ads in SQLMag. Just saying...[/quote]I was trying to use some critical thinking skills without saying as much but I'll admit that was my suspicion as well.[/quote]I guess I am not capable of being that subtle. Editor Picks are to be viewed and weighed appropriately :-DMon, 31 Dec 2012 12:02:07 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspx[quote][b]opc.three (12/31/2012)[/b][hr]I am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of SQL Sentry ads in SQLMag. Just saying...[/quote]I was trying to use some critical thinking skills without saying as much but I'll admit that was my suspicion as well.Mon, 31 Dec 2012 11:15:50 GMTScott D. Jacobsonhttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxI am not saying the SQL Sentry tool is not great because I haven't used it, and their free Execution Plan Explorer is excellent, but I see a lot of SQL Sentry ads in SQLMag. Just saying...Mon, 31 Dec 2012 11:01:41 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxIsn't it interesting the nearly inverse relationship between the Editors' picks and those of the community? Actually, Spotlight didn't even make the community list and the Editors' top pick (Gold) was only Bronze for the community. Interesting.Mon, 31 Dec 2012 10:55:48 GMTScott D. Jacobsonhttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspx[u][url=http://www.sqlmag.com/content1/topic/sql-server-pro-editors-2012-community-choice-awards-144455/catpath/awards/showprivate/1/page/6]SQL Server Magazine > 2012 SQL Server Pro Editors' Best and Community Choice Awards[/url][/u]Mon, 31 Dec 2012 10:41:07 GMTopc.threehttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxHave a look at this:http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspxMon, 31 Dec 2012 09:33:27 GMTMichael Meierruthhttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxyou can think try this Quest : Spot light . its pretty handy. i have used this.see [url]http://www.quest.com/spotlight-on-sql-server-enterprise/[/url]Sun, 30 Dec 2012 22:02:28 GMTBhuvneshhttp://www.sqlservercentral.com/Forums/Topic1401281-1292-1.aspxHi,Do anyone knows what is the best tool for database monitoring. Basically I need to monitor more than 50 database which include the log size, log space usage, job status, troubleshoot job (if fails), disk usage, mirroring and etc.Im using SQL server 2005. help me pretty pleaseeeeeeeeeeeeeeeeeeeee :-DThanks in advance!Sun, 30 Dec 2012 20:57:16 GMTfatinfzi