This seminar takes place on Aug 14, 2018 (Online, 8:00 AM – 12:00 PM PDT).
Is your SQL Server under memory pressure?
SQL Server doesn’t make it easy to see if your SQL Server is under memory pressure, or if someone goofed when configuring the memory settings on your critical production instances.
What you’ll learn in this SQL Seminar
In this four-hour live seminar, you’ll learn:
- How to recognize internal and external memory pressure in SQL Server
- What it looks like when SQL Server uses the paging file, and guidelines to configure paging files, max server memory (MB), and min server memory (MB) settings in SQL Server
- When to grant the ‘Lock Pages in Memory’ privilege to SQL Server
- How to monitor buffer pool usage and predict if giving your SQL Server more memory would improve performance
- How to identify and troubleshoot query workspace memory waits
- How much memory to give Standard Edition for different versions of SQL Server – and why it can sometimes use more than you think
You’ll also get demo scripts and tools to cause memory pressure against test instances of SQL Server, so you can watch SQL Server react to memory pressure in your own environment.
This course is taught by me, Kendra Little
I’m a Microsoft Certified Master in SQL Server who loves using data to answer the question, “Do we need more memory?” In this seminar, I’ll show you the most important lessons on configuring and monitoring memory in SQL Server which I’ve learned as a DBA, Consultant, and Trainer over the years.
Can I watch the SQL Seminar later?
Yep! I’ll make the GoToWebinar recording of the session available for the class after the seminar completes. You’ll have access to the recording for a year.
What’s the experience like?
When you register for this seminar, you’ll be enrolled in an online GoToWebinar meeting scheduled for the date you select in the dropdown. The invitation makes it easy for you to block out the seminar on your calendar, and it also contains your unique information to connect.
Prior to the seminar, I’ll send you setup instructions on how you can test your connection, and where to download the sample databases we’ll be using.
The day of the seminar, you’ll join the live GoToWebinar session. I’ll be live with my webcam and shared demo environment.
We’ll take a 10 minute break every hour or so. That way, everyone can move around and stretch, etc.