Sydney SQL Server Enterprise User Group – August 2010

DBA: Understanding SQL Server Memory Management

Thanks again for such a good turnout, and all your positive feedback.

Understanding SQL Server’s memory management is such a complex topic, we could easily have spent half a day on it. Apologies for going over the allotted time, I know you have work to go back to.

Hopefully this will help you in your configuration and troubleshooting of SQL Server.

One clarification, each scheduler “consumes” 2MB on a x64 architecture, and 4MB on the IA architecture. (See Slide 41.)

BTW, I passed the ITIL exam!

Congratulations to David for winning the major door prize at the last meeting, a license of the Idera SQL Admin Toolset (valued at AUD $432) that was generously provided by Idera (www.idera.com) and Tony Finnemore from SQL Tools (www.sqltools.com.au).

The content from this month’s meeting is posted below.

 

Presentation:

 

News: