Production Database Administration

Brent Ozar in a tin foil hat

What Queries Does Microsoft’s CEIP Service Run On Your SQL Server?

You’ve seen the CEIP Service on your SQL Server, and you’re wondering what queries it runs and how it sends that information back to Microsoft. I was wondering too, because I started seeing queries running that I didn’t expect: sp_WhoIsActivelyRunningTelemetryQueries (click to see full size) Ah-ha, the telemetry service, also known as SQLCEIP! Starting with…
Read More

How to Log Active Queries with sp_BlitzWho

Queries are running when you’re not around. They’re wreaking havoc – maybe they’re filling up your TempDB, or causing blocking, or flushing your buffer pool out. When I wanna see what queries are running, I run sp_BlitzWho: That shows me who’s running the query, what it’s been waiting on over time, memory grants, blocking, and…
Read More
Brent getting caffeinated

How to Troubleshoot Blocking and Deadlocking with Scripts and Tools

Deadlocks, Monitoring, sp_BlitzLock
When you need to find which queries are blocking other queries, your decision comes down to when the blocking happened. Is it happening now, recently, or coming up soon? During a live emergency, start with sp_WhoIsActive. Adam Machanic’s excellent free sp_WhoIsActive replaces Activity Monitor, sp_who, and sp_who2, and it’s way more powerful. The documentation is extensive –…
Read More

“Full Stack” Means “Part Time” – or Why DBAs Might Wanna Learn DevOps

Long before the “full stack developer” phrase became fashionable, us early developers did exactly that. We didn’t do any of these full time, mind you – full stack doesn’t mean full time. Here’s a grid I use to explain the work involved in building and troubleshooting database apps: Full Stack, Part Time Developers start from the…
Read More

Book Review: Database Reliability Engineering by Campbell & Majors

Database Reliability Engineering – good buy When you see the cover of Database Reliability Engineering, the first question you’re probably gonna ask is, “Wait – how is this different from database administration?” And I’ve got good news: that’s the very first thing @LaineVCampbell and Charity Majors (@MipsyTipsy) cover in the preface. “…for a long long…
Read More

No More SQL Server Service Packs: Is CU12 the New SP1?

Starting with yesterday’s release of SQL Server 2017, Microsoft has a new servicing model: they’re only delivering Cumulative Updates, and not doing Service Packs. Pedro Lopes writes: SPs will no longer be made available. Only CUs, and GDRs when needed. CUs will be delivered more often at first and then less frequently. Every month for…
Read More