What should you do?
A. Use the Usage Based Optimization wizard to design appropriate aggregations.
B. Use the Performance Counter group named Processing.
C. Use SQL Server Profiler to review session events for active sessions.
D. Use the $System.discover_object_memory_usage dynamic management view.
Answer:D
What should you do?
A. Use the Usage Based Optimization wizard to design appropriate aggregations. B. Use the Performance Counter group named Processing. C. Use SQL Server Profiler to review session events for active sessions. D. Use the $System.discover_object_memory_usage dynamic management view.