nerdexam
Microsoft

70-467 · Question #96

You need to select and configure a tool for the monitoring solution. What should you choose?

The correct answer is A. Performance Monitor configured with the MSAS11:Storage Engine Query counter. The MSAS11:Storage Engine Query counter in Performance Monitor tracks the rate of storage engine queries against an Analysis Services instance, directly measuring query load for monitoring purposes.

Plan business intelligence (BI) infrastructure

Question

You need to select and configure a tool for the monitoring solution. What should you choose?

Options

  • APerformance Monitor configured with the MSAS11:Storage Engine Query counter
  • BPerformance Monitor configured with the MSAS11:Processing counter
  • CSQL Server Profiler configured with the Query Processing: Query Subcube event
  • DSQL Server Profiler configured with the Queries Events: Query Begin event

How the community answered

(46 responses)
  • A
    74% (34)
  • B
    7% (3)
  • C
    15% (7)
  • D
    4% (2)

Why each option

The MSAS11:Storage Engine Query counter in Performance Monitor tracks the rate of storage engine queries against an Analysis Services instance, directly measuring query load for monitoring purposes.

APerformance Monitor configured with the MSAS11:Storage Engine Query counterCorrect

The MSAS11 performance object exposes counters specific to SQL Server Analysis Services 2012/2014, and the Storage Engine Query counter reports the number of storage engine queries per second. This makes it the correct tool for building a monitoring solution that tracks query activity and load on the Analysis Services instance. Performance Monitor is the appropriate lightweight, continuous monitoring tool versus Profiler, which is better suited for ad-hoc tracing.

BPerformance Monitor configured with the MSAS11:Processing counter

The MSAS11:Processing counter tracks dimension and partition processing operations rather than query execution, so it does not reflect end-user query activity on the server.

CSQL Server Profiler configured with the Query Processing: Query Subcube event

SQL Server Profiler with the Query Processing: Query Subcube event captures internal subcube requests during query execution, which is useful for deep query diagnostics but is too granular and resource-intensive for an ongoing monitoring solution.

DSQL Server Profiler configured with the Queries Events: Query Begin event

SQL Server Profiler with the Queries Events: Query Begin event captures the start of MDX queries and is useful for troubleshooting individual queries, but Profiler introduces significant overhead and is not designed for sustained production monitoring.

Concept tested: Analysis Services performance monitoring with Performance Monitor counters

Source: https://learn.microsoft.com/en-us/analysis-services/instances/use-sql-server-profiler-to-monitor-analysis-services

Topics

#Performance Monitor#SSAS storage engine#MSAS11 counters#BI monitoring

Community Discussion

No community discussion yet for this question.

Full 70-467 Practice