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

SSAS health monitoring Expand / Collapse
Author
Message
Posted Tuesday, December 14, 2010 2:34 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 9:11 AM
Points: 1,568, Visits: 653
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 ...



Post #1034774
Posted Tuesday, December 14, 2010 2:59 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: Moderators
Last Login: Sunday, April 13, 2014 11:43 PM
Points: 1,781, Visits: 3,340
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.
Post #1034799
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse