Database Monitoring tool

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Database Monitoring tool

Database Monitoring tool

Rate Topic

Display Mode

Topic Options

Author

Message

fatinfzi

Posted Sunday, December 30, 2012 8:57 PM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 02, 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 BigGrin

Thanks in advance!

Post #1401281

Bhuvnesh

Posted Sunday, December 30, 2012 10:02 PM

SSCrazy

Group: General Forum Members
Last Login: Tuesday, March 26, 2013 8:41 AM
Points: 2,562, Visits: 3,451

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----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1401284

Michael Meierruth

Posted Monday, December 31, 2012 9:33 AM

SSC-Addicted

Group: General Forum Members
Last Login: Sunday, May 05, 2013 10:12 AM
Points: 480, Visits: 1,604

Have a look at this:
http://www.sqlservercentral.com/Forums/Topic409505-690-1.aspx

Post #1401421

opc.three

Posted Monday, December 31, 2012 10:41 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:27 PM
Points: 6,695, Visits: 11,711

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1401444

Scott D. Jacobson

Posted Monday, December 31, 2012 10:55 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841

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

opc.three

Posted Monday, December 31, 2012 11:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:27 PM
Points: 6,695, Visits: 11,711

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1401451

Scott D. Jacobson

Posted Monday, December 31, 2012 11:15 AM

Old Hand

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 5:17 PM
Points: 335, Visits: 841

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

opc.three

Posted Monday, December 31, 2012 12:02 PM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 9:27 PM
Points: 6,695, Visits: 11,711

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 BigGrin

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1401471

Grant Fritchey

Posted Wednesday, January 02, 2013 4:53 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 4:50 AM
Points: 13,371, Visits: 25,143

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 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software

Post #1401780

Jayanth_Kurup

Posted Wednesday, January 02, 2013 5:10 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 6:43 AM
Points: 1,785, Visits: 1,008

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 BigGrin

Jayanth Kurup

Post #1401786

« Prev Topic | Next Topic »

Permissions