Friday, May 15, 2009

Where is My Memory? Understanding Microsoft SQL Server Memory Usage and Management

  • This session was very difficult to document because the instructor moved so quickly.  The biggest point that can out of this session was the fact that SQL Server will suck up all the memory if you allow it, but when the OS or some other program needs some memory, it will release it back to the OS or App.
  • If you have multiple instances of SQL Server on one server as we do, we may want to look at throttling each so one of the instances does not cause the other instances to perform poorly.
  • I have a copy of his power point presentation and I will distribute via email when I return to the office.

No comments:

Post a Comment