You’re the administrator of your company network. And SQL Server 2008 has been deployed on your computer. Now you use SQL Server 2008 to design a Business Intelligence (BI) solution.
There is a SQL Server 2008 Analysis Services (SSAS) cube which contains 110 million Fact rows and 750 dimension attributes. The cube reads data from a remote data source and increases several measure groups by 1 million rows everyday. You intend to deploy this SQL Server 2008 Analysis Services (SSAS) cube. You want to increase the total number of users by 180 percent
for the cube. During cube processing, you have to capture the baseline performance on the overall system. So what should you do?
A.
You should use the sp_monitor system stored procedure to monitor cube processing events.
B.
You should use the sp_trace_setfilter system stored procedure to monitor cube processing events.
C.
You should configure the data collector to collect Query Activity statistics during cube processing.
D.
You should configure the data collector to collect Performance Counters statistics during cube processing.