SSIS Package For Collecting SSAS DMV Data at http://www.codeplex.com/SQLSrvAnalysisSrvcs
This project on Codeplex includes an SSIS package along with its configuration file to collect Analysis Services Dynamic Management View data by means of a SQL Agent job and store the collected data in tables in a database called DMV. These scripts were extracted from the A Solution for Collecting Analysis Services Performance Data for Performance Analysis project in the same codeplex release and are intended to demonstrate, in a stand-alone fashion, how to periodically query your Analysis Services instance using DMVs to determine the current state of your server - collecting connection, session and command information.
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
|
