Nebraska SQL from @DBA_ANDY
I’m a forty-something Microsoft SQL Server DBA of 15+ years, a devoted husband, and a father of three young boys. I have been a DBA at a public university, at a major bank, at a healthcare system, and I now work as a remote DBA with customers across the United States. I write and speak primarily about the tips and tricks that I discover along my SQL Server journey.
Archives: May 2018
Toolbox - How Long Has My Server Been Up?
https://imgflip.com/i/2axp6y |
--
As a remote service provider a common request is to follow up after a server restart (or investigate a possible server restart). A question that inevitably comes up is "When did the server restart?"
If all you need to know is…
0 comments, 254 reads
Posted in Nebraska SQL from @DBA_ANDY on 24 May 2018
When Good Query Plans Go Bad
Today's story starts again with a page escalation:
--
I connnected to DistServer01…
--
We are seeing very high CPU usage on DistServer01. Could you please take a look and do a health check on this server? Please let us know if there is anything we can do to help.--
I connnected to DistServer01…
0 comments, 2,400 reads
Posted in Nebraska SQL from @DBA_ANDY on 18 May 2018