There are few features in SQL Server that are disabled, or turned OFF, by default that, in my opinion, should be turned on/enabled. One of those features is something called “Instant File Initialization” (You can read about the other one here).
[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?
He quickly replied, Continue reading “How To Use SQL Server Activity Monitor”