SQL server performance disgnostic tool

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » SQL server performance disgnostic tool

15 posts, Page 1 of 2

1 2 »»

SQL server performance disgnostic tool

Rate Topic

Display Mode

Topic Options

Author

Message

Amu

Posted Saturday, September 18, 2010 5:35 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 121, Visits: 383

I am Sr. DBA in one of the leading bank and we would like to buy MS SQL server performance diagnostic tool for our enterprise shop for MS SQL server 2000, 2005, 2008, 2008 R2.

What would you suggest? What should I be looking for the tool that is better than other tools (i.e. Idera Performance diagnostics better on xyz over quest tool etc).

Any help here would be helpful.

Thanks in advance.

Post #988812

winash

Posted Sunday, September 19, 2010 12:05 PM

Ten Centuries

Group: General Forum Members
Last Login: Monday, February 18, 2013 3:46 AM
Points: 1,422, Visits: 1,883

Some tools that I would recommend (which are available for free) are:

RML utilities -> 32 bit is available for download here http://www.microsoft.com/downloads/en/details.aspx?FamilyId=7EDFA95A-A32F-440F-A3A8-5160C8DBE926&displaylang=en and 64 bit is available for download here http://www.microsoft.com/downloads/en/details.aspx?FamilyID=B60CDFA3-732E-4347-9C06-2D1F1F84C342

SQL Nexus -> available on codeplex here http://sqlnexus.codeplex.com/

We've used these tools for performance diagnostics and they're pretty good.

The book Profession SQL Server 2008 Internals and Troubleshooting (by Christian Bolton et al) contains a lot of good information on trobuleshooting performance with these tools (it is also a very good book for the all other information it contains and I would recommend this book regardless of whether you're using these tools or not Smile

)

Post #988980

Amu

Posted Monday, September 20, 2010 9:12 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 121, Visits: 383

Thanks winash.

We are using RML utilities today. I will look at the SQL nexus tool as well.

We are trying to evaluate and looking at buying performance diagnostic tool that allow us to go back in time to find out what the issue was? i.e. two days ago someone feel pain on running their batch and not reported until two days later. We like to go back to history and see what was going on the server at the time.

We have very big consolidate shop for SQL server and thus we are looking at tool with historical snapshots.

thanks again for your reply.

Post #989474

Geoff A

Posted Tuesday, September 21, 2010 10:51 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:10 AM
Points: 485, Visits: 1,568

idera sql diagnostics manager (if you can afford it) Wink

Post #990550

AmolNaik

Posted Tuesday, September 21, 2010 11:21 AM

SSC Eights!

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 1:20 PM
Points: 936, Visits: 1,184

We use SQLSentry at our company. Another worth trying tool that comes free with the RedGate SQL Bundle is SQL Response. You can download the trial version, it's free to use for 15 days.

Thanks,

Amol Naik

Post #990584

Amu

Posted Thursday, September 23, 2010 8:30 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 121, Visits: 383

Thank you all who responded so far.

This is what I have
- RML Utilities
- SQL Nexus
- Idera Performance diagnostic manager
- SQL Sentry
- Red Gate SQL response

Anything else for anyone else? If you are using any of the tool, Can you also tell me what do you like about and what do you don't like or miss about it?

Thanks in advance.

Post #992071

Geoff A

Posted Thursday, September 23, 2010 8:36 AM

SSC-Addicted

Group: General Forum Members
Last Login: Monday, May 20, 2013 7:10 AM
Points: 485, Visits: 1,568

i like Idera the best. however, it is very expensive.
i would settle for SQL Response, BUT, not the current version 1.3. the new beta version 2 is looking to be very promising. (they probably will charge more for it Tongue

)

Post #992077

Igor Santos

Posted Thursday, September 23, 2010 8:51 AM

Grasshopper

Group: General Forum Members
Last Login: Yesterday @ 1:34 PM
Points: 17, Visits: 178

We have been using I3, a product from a company called Precise and it's really good.
It's able to store historical information, shows offenders, sends out alerts... It's very robust and complete.
We will be doing a POC on a Quest Analyzer tool over the next couple of weeks and I'll let you know how this goes.

Post #992091

Steve Jones - SSC Editor

Posted Thursday, September 23, 2010 8:58 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 3:30 PM
Points: 31,436, Visits: 13,751

Are you looking to track /monitor or solve issues? They are two different things. I work for Red Gate, and Response is more for tracking/monitoring/alerting. The SQL Sentry tool is more for tracking performance issues and diving in.

I have heard good things about the Idera tool, but haven't used it. Same for Nexus. Quest has some tools that can help as well (Foglight/Spotlight). Havne't used them on SQL, but they were nice products for Oracle / DB2. They are $$$$

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #992100

Amu

Posted Friday, September 24, 2010 8:38 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 6:54 AM
Points: 121, Visits: 383

We are looking at tool that tracks and keep history and allow us to dive into issue. We have current monitoring and in-house developed tool that allow us to go back about 7 days and limited way to find out what was the cause and what we should do to resolve.

But its about time where we can get professional too that allow us to track and keep history and allow us to dive into issue in past and current.

Post #992842

« Prev Topic | Next Topic »

15 posts, Page 1 of 2

1 2 »»

Permissions