Like any good DBA, I’ve got a checklist I go through when I get a new SQL Server. I’ve got standard jobs I install, standard configurations for the model database to set, steps to take to add the new server into my automated monitoring jobs, etc. The more experience I get, it seems the longer […]
So there you are, sitting at your desk, idly clicking in SSMS, admiring your little kingdom of SQL Servers. Everything looks good. Jobs are running correctly. No performance problems to be seen. Everything is humming along smoothly. It’s tempting to relax a little and perhaps take some time to peruse a few blogs or check […]
It’s Two For One day here at shaunjstuart.com! That’s right! Today only, you get TWO tips for the price of one! One of the things I routinely do when setting up a new SQL Server or adding one to the flock that I already manage is to set up a job to maintain the job […]
A couple years ago, I was interviewing for a new job and one of the interviewers I met with asked me how I would go about tuning a query to improve performance. One of the options I mentioned was to run the query through the Database Engine Tuning Advisor, although, I added, its results should […]
I’ve written in the past about the need to create a baseline of your SQL Server’s performance and how to do that. The list of Perfmon counters I used was from a list that Brent Ozar recommended in one of this videos. I saw something last week that made me add a couple. Paul Randal […]