Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

Database Monitoring tool Expand / Collapse
Author
Message
Posted Sunday, December 30, 2012 8:57 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, May 2, 2013 9:54 PM
Points: 24, Visits: 88
Hi,

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

Thanks in advance!
Post #1401281
Posted Sunday, December 30, 2012 10:02 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 2:36 AM
Points: 2,840, Visits: 3,970
you can think try this Quest : Spot light . its pretty handy. i have used this.
see http://www.quest.com/spotlight-on-sql-server-enterprise/


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1401284
Posted Monday, December 31, 2012 9:33 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: 2 days ago @ 2:06 AM
Points: 542, Visits: 2,125
Have a look at this:
http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspx
Post #1401421
Posted Monday, December 31, 2012 10:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 7,125, Visits: 12,723
SQL Server Magazine > 2012 SQL Server Pro Editors' Best and Community Choice Awards

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1401444
Posted Monday, December 31, 2012 10:55 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:41 PM
Points: 356, Visits: 918
Isn'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.
Post #1401450
Posted Monday, December 31, 2012 11:01 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 7,125, Visits: 12,723
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...

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1401451
Posted Monday, December 31, 2012 11:15 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, October 15, 2014 5:41 PM
Points: 356, Visits: 918
opc.three (12/31/2012)
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...


I was trying to use some critical thinking skills without saying as much but I'll admit that was my suspicion as well.
Post #1401455
Posted Monday, December 31, 2012 12:02 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:51 PM
Points: 7,125, Visits: 12,723
Scott D. Jacobson (12/31/2012)
opc.three (12/31/2012)
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...


I was trying to use some critical thinking skills without saying as much but I'll admit that was my suspicion as well.

I guess I am not capable of being that subtle. Editor Picks are to be viewed and weighed appropriately


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1401471
Posted Wednesday, January 2, 2013 4:53 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 13,890, Visits: 28,285
Determining 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 Red Gate's SQL Monitor. 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.


----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server Query Performance Tuning
SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1401780
Posted Wednesday, January 2, 2013 5:10 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,786, Visits: 1,014
Depends 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

Jayanth Kurup
Post #1401786
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse