We are big fans of performance monitoring and always happy when Microsoft add new features to enhance the utilities that already exist. SQL Server 2012 introduces the Resource Usage
event class. This new event class allows you to gather statistics on how your resources are used when processing queries.
Note
Of course, there already are some useful DMVs that allow us to look at resource usage in Analysis Services. There is a great article here to begin with:
http://dwbi1.wordpress.com/2010/01/01/ssas-dmv-dynamic-management-view
You can monitor these events using SQL Server Profiler, just as you would with your OLTP systems. SQL Server Profiler monitors the engine process events such as logins, transactions starting and stopping, and what T-SQL code is executed on the server. It captures data about these events, such as how long it took to run, so you can track both server and database events.
Using SQL Server Profiler, you can monitor the overall performance of Analysis...