SQL Server Amnesia

Speaker(s)Steven Ormrod

Duration: 60 minutes

Track: DBA 2

Losing your memory is never fun.  Well, I can't help you with that, but I can help show you how SQL Server is using its memory and some things to look at with regards to performance problems.

When I started as a DBA I didn't know much about SQL Server internals.  I inheirited quite a few servers and they were experiencing performance problems.  Over time I learned more about the internals and how to troubleshoot systems.  I'll share some stories with you and talk about some of the methods I use to look at how SQL Server is using its memory.  Then we'll look at some examples and demo code.

Accompanying Materials:

Back to Top