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

No..not that Up (although it is awesome!)

--

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, 220 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:

--

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,341 reads

Posted in Nebraska SQL from @DBA_ANDY on 18 May 2018

Get Your Own Blog

Contact the author

All Blogs

Feeds

Archives for this blog