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 will tell you how much RAM is available on the system and how much is currently in use by the Tabular engine and other processes. Use the Processes tab to see whether any other services or applications are competing for memory. You should typically...