Trace events will give you more details while Performance counters give you an aggregate view. To learn more about how to create and run traces, see Create Profiler traces for replay (Analysis ...

In SQL Server Management Studio, you can invoke DBCC using either an MDX or XMLA query window. Additionally, you can use either [!INCLUDEssCurrent] Profiler or Analysis Services xEvents to view DBCC ...