April 7, 2014 at 3:09 pm
I would like to know best tools for monitoring SSIS, SSRS and SSAS.
Thanks.
April 8, 2014 at 4:52 am
There is no right answer for this. It's very subjective. Also, you'll not find any tool that monitors all those services equally well. Further, some of the best tools for monitoring the SQL Server relational engine don't have any tools at all for SSRS or SSAS.
That said, I'll make two recommendations. If you're looking to monitor small to medium size servers in a small to medium sized enterprise, I'd suggest using Red Gate SQL Monitor. It's a great tool and doesn't cost much. If you're extremely high volume or have thousands of servers, I'd suggest using SQL Sentry. It's a fantastic tool, but is overkill for smaller systems.
DISCLAIMER: I work for Red Gate.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 8, 2014 at 5:52 am
As mention by Grant first decide what would you like to monitor? And then look for tool which suits your requirement.
Both the tool mention (Redgate and SQL Sentry) are very good and popular among SQL DBA.
HTH
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 10, 2014 at 1:39 pm
Thank You so much for your valuable Suggestions. I will do some research on both the tools and move on with any one of them.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply