October 2012
Intermediate to advanced
238 pages
5h 17m
English
Content preview from What's New in SQL Server 2012Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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, ...