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 ...