Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • 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 for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse