- This event has passed.
IDPA-Des Moines – Dave Bland “Is my SQL Server having Memory Pressure?”
September 13, 2021 @ 5:30 pm - 7:30 pm CDT
The Des Moines associates of the Iowa Data Professionals will meet as usual on the second Monday of the month, September 13, 2021.
**This meeting will be 100% online, there will be no in person meeting **
You are welcome to join us at 5:30 PM Central Time (22:30 UTC) when our hosts will start the Microsoft Teams Meeting.
Attendees are encouraged to connect and participate in networking or general discussions. At 5:50 PM, we present Local Group Announcements.
At 6:00 PM Central Time (23:00 UTC) our featured Speaker, Dave Bland, will present “Is my SQL Server having Memory Pressure?”
Our meetings usually end by 7:30PM Central Time, followed by opportunities for Q/A to our Speaker Q/A or our Local Group Leadership.
Meeting Topic: “Is my SQL Server having Memory Pressure?”
As we all know, SQL Server loves memory and will use as much as it can get. However, when there is memory pressure, we need to use our DBA skills to identify what is causing the pressure.
During this session we will explore how SQL Server uses memory and how to properly configure memory settings. We will discuss the use of DMVs and other tools to help us find what is consuming the most memory and some potential solutions.
We will also go over a suite of 140 SSRS reports that can make doing this assessment much easier!
Dave Bland is a Data Architect at Stericycle.
Prior to Data Architect, I have supervised the Shared Services DBA team for 4 years.
I have worked as a DBA in a number of industries including casino industry, insurance industry as well as the transportation industry.
Sql Server instructor, DBA, Frequent SQL Saturday presenter, Microsoft Certified Trainer, MCSE: Data management and analytics, MCSE: Business Intelligence