Page History
...
- Check OS Paging to make sure that paging from/to the swap file is not causing these IOs.
- Distribute the data and logs over more disks.
- Replace disks with faster disks.
- Add more memory if the main cause is Disk Reads.
- Switch from a RAID 5 to RAID 10 solution if Disk Writes make up more than 20% of total disk access.
- Move non-SQL Server applications to another computer.
- If the computer is running multiple instances of SQL Server, consider placing each instance on a separate computer.
...
| Scroll pdf ignore |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |