Search Results for &#8220;tech triage&#8221;

Production Database Administration

Not all of the questions y’all post at https://pollgab.com/room/brento require long, thought-out answers. Some are just one-line specials, like these: F’legend: Hi Brent, in reply to a question talking about database restores for 1TB+ you also touched on scrubbing or synthetic data as a way to populate dev environments. Are there any resources/tools you would…

What’s It Like to Have a Live Class Season Pass?

Last Updated September 15, 2019

Company News

I don’t usually post product reviews here on the blog, but Vadim Kulikov (aka BlondeDBA in Slack) recently finished all of the Mastering classes, and he took the time to write a really detailed review. Here it is, unedited: I heard some folks refer to Brent’s training as “Brent Ozar’s Full Experience”. I really like…

[Video] Office Hours 2018/1/10 (With Transcriptions)

Last Updated January 18, 2018

This week Brent, and Richie discuss validating backups using the backup set table, how to figure out if you’re a Mid-Level or Senior DBA, rollbacks, compatibility modes while upgrading SQL Server versions, MAXDOP settings, and Brent’s car purchasing tip. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our…

[Video] Office Hours 2017/06/07 (With Transcriptions)

Last Updated June 11, 2017

This week, Brent, Erik, and Richie discuss running SQL Server 2017 CTP on Linux, receive side scaling on servers and VMware, query tuning, nested roles vs. assigning roles to users, hierarchical data type, apps and scripts for automating restores, and learning Azure and AWS. The audio’s kinda rough this week because Brent & Erik were…

[Video] Office Hours 2017/04/19 (With Transcriptions)

Last Updated April 22, 2017

This week, Brent, Tara, Richie, and Erik discuss SQL Server 2017 CTP 2, quorum configuration for a 4-node availability group, database sharding, premature optimization, parameter sniffing, tracking query plans within cursors, and what’s coming up in the new version of Paste The Plan. Here’s the video on YouTube: You can register to attend next week’s Office Hours,…

[Video] Office Hours 2016/07/06 (With Transcriptions)

Last Updated April 9, 2017

This week, Brent, Jessica, Richie, Doug, and Angie discuss snapshot replication, file and table-level restores, whether you should enable lock pages in memory, redistributing data across files or a database, and Doug’s new video class. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on…

[Video] Office Hours 2016/06/15 (With Transcriptions)

Last Updated June 19, 2016

This week, Brent, Angie, and Tara talk through your questions about monitoring tools, transactional replication, configuration management, source control software suggestions and much more! Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go. Office Hours Webcast – 2016-06-15 Why did some of…

In Review: SQL Server 2005 Waits and Queues

Last Updated February 13, 2017

Jeremiah Peschka

Wait Stats

Back in November of 2006, Microsoft released “SQL Server 2005 Waits and Queues” as a best practices article. Many people in the SQL Server community have referenced this article as a great place to get started with understanding waits in SQL Server. Heck, I’ve recommend it on a regular basis. The last time I recommended…

How to Measure SQL Server Workloads: Wait Time per Core per Second

Last Updated January 23, 2017

When I ask you how fast your car is, there’s a two common metrics for answers: How fast it can go How much horsepower or torque its engine can deliver If I ask you how hard your car is working right now, you’d probably answer with: Its current speed (in MPH or KPH) Its current engine workload…

The Very First Concern with SQL Virtualization: Licensing

Last Updated February 9, 2017

Licensing, SQL Server, Virtualization

Every single thing you do with a virtual SQL Server starts with one very important concern: how are you going to license it? The 3 Common Ways to License Virtual SQL Servers The software licensing section of my local library Developer Edition, by the guest – Developer Edition has all the power of Enterprise Edition,…

Career Planning for DBAs: Your Next Two Years

Last Updated May 10, 2017

Professional Development

You’ve been doing this database thing for a while, and you’re ready to get serious about it. What’s the next step? Step 1: Define your specialty in one sentence. If you say you do everything, you compete with everyone. You want to be the only one they want. That means you’re: Actively sought-after Uniquely qualified A…

Do Lots of Connections Slow Down Your SQL Server?

Last Updated May 23, 2014

Threads are important. I sometimes hear database administrators say, “This database must be involved in our performance problem: it has too many connections.” Lots of connections might cause a problem for your SQL Server, or it might not. The good news is that there’s a way to clearly tell if they’re dragging down performance or…

How to Tell if You Need More Tempdb Files

Last Updated November 4, 2020

SQL Server, TempDB

You may have read that you need to have more than one data file in SQL Server’s tempdb. This can happen even if you’re using blazing fast storage. If you create a lot of tiny objects in tempdb you may hit a bottleneck on special pages that SQL Server uses internally to allocate all those objects. For certain workloads, adding…

RECOMPILE Hints and Execution Plan Caching

Last Updated April 2, 2021

Execution Plans, Parameter Sniffing

The DBA version of an XKCD classic. When you identify that parameter sniffing is a problem, you need to test whether implementing ‘recompile’ hints will help plan quality. (Not sure what parameter sniffing is? Learn from this blog post or this 50 minute free video.) You must decide: what hint or command do you use,…

Implementing Snapshot or Read Committed Snapshot Isolation in SQL Server: A Guide

Last Updated September 26, 2022

Locking, Blocking, and Isolation Levels, SQL Server

145

How to change isolation levels without losing your marbles. A client said the coolest thing to me the other day. He said, “We talked before about why we would want to start using optimistic locking in our code. How do we get there?” If you’re not a SQL Server geek, that comment probably doesn’t even…

Want to Work With Brent, Jeremiah, and Kendra?

Last Updated February 9, 2017

Company News

We’re looking for a few good database professionals. Well, actually, right now we’re just looking for one. Things are going really well here at Brent Ozar Unlimited®, and it’s time to grow our family. We’re hiring our first full time employee, and just like everything else we do, we figured we’d blog about it. We…

SQL Server First Responders Kit Video

Last Updated January 11, 2012

When your SQL Server is critically injured you need a first responder kit to help you diagnose the problem and apply emergency aid. In this session, Kendra Little introduces you to invaluable tools and techniques for triaging an emergency. If you have one year’s experience with database administration, this half-hour session will set you up…

What People are Finding with sp_Blitz®

Last Updated March 26, 2014

My new sp_Blitz® stored procedure helps you take over SQL Servers, identify risks, and build an inventory of what needs to be fixed. Here’s the video from our Tech Tuesday Triage webcast series this week when I explained how to use it: https://www.youtube.com/watch?v=OUdIe_eLpco In the sp_Blitz® output, I include a link to learn more about…

PASS Summit Tips and Tricks

Last Updated October 4, 2011