Using performance tools

Your design and management tool belt will contain several tools that will help you with troubleshooting, optimization, and performance tuning. These may consist of:

  • SQL Server Management Studio
  • DAX Studio add-in for Excel
  • Windows Task Manager and Resource Monitor
  • SQL Server Profiler

Task Manager and Resource Monitor

The most convenient method to check system resources and activity is that of using performance tools in the Windows Task Manager. You can access the Task Manager in any version of Windows using Ctrl + Alt + Delete or by right-clicking on the Windows task bar. Use the Performance tab to view a summary of CPU and memory usage on the computer. Memory use is typically the most important factor to consider first. This ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.