Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Monitoring tool


Database Monitoring tool

Author
Message
fatinfzi
fatinfzi
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
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 :-D

Thanks in advance!
Bhuvnesh
Bhuvnesh
SSCrazy
SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)SSCrazy (2.9K reputation)

Group: General Forum Members
Points: 2928 Visits: 4076
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;-)
Michael Meierruth
Michael Meierruth
SSChasing Mays
SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)SSChasing Mays (647 reputation)

Group: General Forum Members
Points: 647 Visits: 2508
Have a look at this:
http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspx
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8243 Visits: 14368
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
Scott D. Jacobson
Scott D. Jacobson
Old Hand
Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)

Group: General Forum Members
Points: 390 Visits: 1000
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.
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8243 Visits: 14368
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
Scott D. Jacobson
Scott D. Jacobson
Old Hand
Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)Old Hand (390 reputation)

Group: General Forum Members
Points: 390 Visits: 1000
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.
Orlando Colamatteo
Orlando Colamatteo
SSCrazy Eights
SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)SSCrazy Eights (8.2K reputation)

Group: General Forum Members
Points: 8243 Visits: 14368
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 :-D

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Grant Fritchey
Grant Fritchey
SSCoach
SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)SSCoach (17K reputation)

Group: General Forum Members
Points: 17597 Visits: 32267
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 and SQL Server Execution Plans
Product Evangelist for Red Gate Software
Jayanth_Kurup
Jayanth_Kurup
SSCrazy
SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)SSCrazy (2.1K reputation)

Group: General Forum Members
Points: 2093 Visits: 1351
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 :-D

Jayanth Kurup
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search