Alert/Monitor Notfication for SSRS/SSAS

  • 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

  • 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

  • In case anyone is still searching for this, my company wrote a tool for monitoring SSAS - have a look at http://www.minidba.com

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply