Activity overview
Latest activity by Steve
How do I find Worst RPO in last 30 days
Hi,I have been looking through my estate pages and in particular, the backup page. I have noticed that my worst RPO in the last 30 days is 22hours and 42 minutes. I found this surprising as we do f...
Memory Grant Showing as 0 in monitor but 31GB in SSMS Execution Plan
I noticed a PLE drop on our production server and I narrowed it down to a query that had a 31GB memory grant:I copied the code and ran it on a test server to do some investigation (the test server ...