Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alert/Monitor Notfication for SSRS/SSAS Expand / Collapse
Author
Message
Posted Wednesday, March 12, 2008 1:09 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 6:37 PM
Points: 700, Visits: 821
Does anyone know of any 3rd party tools to monitor SQL Server Reporting Services, Analysis Services, etc...? I know of tools to monitor the database server and hardware, but I am unable to find information on monitoring SSRS or SSAS. I would prefer to buy a solution and not build a solution. We have a data center, and when Subscriptions fail, or querys take too long, then email goes to the first responder. I want to find a product that specifically monitors SSRS. I know I can get quite a bit of information from the SSRS database catalog, but it would be nice for our tech-support engineers to escalate properly.

Questions:
Did the subscription(s) fail?
How long (max, min, avg.) do individual reports run?
What datasources failed? What reports failed due to data source issues?

Does anyone know of any tools to help with this?

Greg



Post #468348
Posted Wednesday, March 12, 2008 3:31 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 3:00 PM
Points: 83, Visits: 108
I am not sure about any 3rd party tools but we use the built in RSEXECUTIONLOG db/admin reports for monitoring the executions.

More details at http://technet.microsoft.com/en-us/library/aa964131.aspx
Post #468418
Posted Monday, August 11, 2014 7:44 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, August 11, 2014 7:43 PM
Points: 1, Visits: 118
In case anyone is still searching for this, my company wrote a tool for monitoring SSAS - have a look at www.minidba.com
Post #1602124
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse