[NO! This is NOT an April Fools joke]
On a recent episode of Office Hours (by Brent Ozar Unlimited) I couldn’t stop laughing at a comment Brent made. The team was talking about “DBA porn” and Brent said (paraphrasing), “going to DBA cubes and seeing the perfmon counter poster.” (Subscribe to Office Hours on iTunes) Continue reading “Free SQL Server Perfmon Counter Poster”
I was recently asked what the difference was between “scaling up” and “scaling out.” I thought, “why not draw a cartoon to illustrate?” So below is my attempt at drawing a cartoon to show the difference between the two. (By the way, if you haven’t figured it out, those are servers flexing their biceps. Yes, they have stick legs. I’ve been telling them to do squats but they don’t listen!) :) Continue reading “SQL Server Scale Up vs Scale Out – Cartoon”
Recently I was asked,
If you approached a SQL Server with abnormal usage (slow applications, etc,) and have a limited amount of time, how or what tools would you use to diagnose the issue?
I replied by saying I would execute a great script like sp_whoisactive, by Adam Machanic, or sp_BlitzFirst by Brent Ozar’s team.
He quickly replied, Continue reading “How To Use SQL Server Activity Monitor”