SSAS health monitoring

  • We have an in-house system to monitor the health and status of all our SQL Server instances. We also have several SSAS instances that we'd like to monitor. Does anyone know if we can query an OLAP instance for metadata, for Server name, database names, etc, as opposed to a data query?

    Thanks in advance ...

  • You can definitely query the management views (DMV) and there's also (from 2008) the MDW. A few articles on that here and on using it with SSAS here.

    Steve.

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

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