[Video] Office Hours: I Don’t Have All the Answers

When I went through the top-voted questions at https://pollgab.com/room/brento, I didn’t have all the answers today:

Here’s what we covered:

00:00 Start 00:48 MyTeaGotCold: I increased my RAM from 16 GB to 32 GB and my buffer pool has grown, but my PAGEIOLATCH_SH waits went up by two percentage points. What might that indicate? 01:46 DavDBA: Hey Brent, Sp_Blitz is recommending that I change the target recovery interval from 0 to 60. I want to implement this, but I read in the Microsoft documentation that it can cause extra I/O activity on certain systems. Have you