Optimizing the performance of database servers and databases
- Memory: Pages/sec counter is used to detect whether or not the memory bottleneck is caused by I/O overhead.
- Disk I/O bottleneck can be monitored by Physical Disk: % Disk Time and Physical Disk: Avg Disk Queue Length counters.
- The System Monitor tool is used to know the cause of slow authentication.
- The SQLServer: Buffer Manager performance object is used to check the amount of RAM used by a computer.
- The Physical Disk: %Disk Time counter measures the pressure on a physical hard disk array.
- Add more RAM if the reading of Memory: Pages/sec counter is high.
- Reduce the Maximum Worker Thread configuration settings if the value of System: Processor Queue Length counter is high.
Continue reading “MCITP 70-444 Short Notes: Exam passing Tips”