Resource usage reporting
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, ...
Get What's New in SQL Server 2012 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
