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: Friday, October 10, 2014 11:06 AM
Points: 1,570, Visits: 680
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: Yesterday @ 1:48 PM
Points: 1,824, Visits: 3,496
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