Versions Compared

Key

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

...

  • Decrease the memory being used by stopping unnecessary programs such as the Print Spooler from running on the dedicated SQL Server computer. You should also eliminate activities such as the server acting as a PDC or BDC and (as a last resort) reducing the amount of memory SQL Server may consume.
  • Add more physical memory on the computer.
  • If the computer is running multiple instances of SQL Server, then consider moving each instance to a separate physical computer.

 

SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >