SSAS Monitoring Scripts For Management Data Warehouse at http://www.codeplex.com/SQLSrvAnalysisSrvcs
This project on Codeplex includes scripts for creating a custom collection set in Management Data Warehouse for collecting performance counter data specific to Analysis Services operations. These scripts were extracted from the A Solution for Collecting Analysis Services Performance Data for Performance Analysis project in the same codeplex release.
These scripts were updated on 3/6/2009 to fix bug related to named instances - namely, Performance Monitor counters for Analysis Services named instances must be entirely in capital letters in order to work in the Management Data Warehouse performance counter data collector.
About CarlRabeler
Carl is a Senior Program Manager on the SQL Server Customer Advisory Team, and is an Extended Customer Program Manager with the Reporting Services and Integration Services product groups. Carl works closely with internal and external customers to develop solutions and validate SQL Server business intelligence best practices for working with large scale and complex BI solutions. Carl has worked with Microsoft SQL Server for over 13 years as a consultant, mentor, writer, speaker and trainer. Carl has written several SQL Server books and numerous technical white papers, has presented at many SQL Server conferences, and has provided mentoring and consulting services for numerous companies around the world.
|
sql, server, best practices, whitepapers, analysis services, data mining, olap, datawarehouse, datawarehousing, availability, clustering, capacity, collation, data types, data warehouse, database, design, index, mirroring, optimization, partitions, performance, precision, processing, querying, scalability, security, reporting services, integration services
|
