REG: Monitering Tools

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » REG: Monitering Tools

REG: Monitering Tools

Rate Topic

Display Mode

Topic Options

Author

Message

m.rajesh.uk

Posted Wednesday, January 23, 2013 10:20 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:49 AM
Points: 113, Visits: 280

Hi Friends,
Which is the best monitoring tool for monitoring the Sql Server 2008 R2

If possible can any one send the links of those monitoring tools for analyzing

Thank You

Post #1410892

Bhuvnesh

Posted Wednesday, January 23, 2013 11:01 PM

SSCrazy

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

there are couple of good tools provided by redgate http://www.red-gate.com/products/dba/ (Disclaimer: i am not paid by redgate for this BigGrin

).

i have used spotlight too , and found is quite handy

-------Bhuvnesh----------
While 1 = 1 (Learning SQL....)
Click to get fast response of your post

Post #1410904

m.rajesh.uk

Posted Thursday, January 24, 2013 12:34 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:49 AM
Points: 113, Visits: 280

Thanks for your reply. Any one having working experience in solar winds (monitering tool)

Post #1410936

anthony.green

Posted Thursday, January 24, 2013 1:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

http://www.sqlservercentral.com/Forums/Topic1410348-391-1.aspx

While Solarwinds now does application monitoring, it will be up to you to investigate if it does what you need it to do.

I would seriously recommend, getting trial editions of software, like SQL Monitor from Red-Gate, Spotlight or Foglight from Quest (now Dell), SQL Sentry, Solarwinds, sure there are many more, cant rattle them off the top of my head. Install them, configure them and evaluate which one meets your needs and your companies needs.

As detailed on your original post, when I did the above task, Solarwinds wasn't mature enough as a product for application monitoring, while the website sure does speek the lingo that it now is, I would still need to re-evaluate it, and I would still probably dismiss it as I am sure dedicated companies like Red-Gate and Quest who have many years expereince with RDBMS monitoring software have already thought of it and done it in a previous version.

But with the current economic situation, I guess you are limited on cost, so you will need to also factor that into your evalutations.

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1410982

m.rajesh.uk

Posted Thursday, January 24, 2013 5:07 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 5:49 AM
Points: 113, Visits: 280

What about SCOM

Post #1411069

anthony.green

Posted Thursday, January 24, 2013 5:09 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

Ruled that out as well, the management pack at the time didnt do everything we needed.

Again get a copy install it, configure it, evaluate it, if it does what you want great, if not leave it behind.

Post #1411070

« Prev Topic | Next Topic »

Permissions