Search Results for “mirroring”

What Does a Database Administrator Actually Do?

Last Updated December 15, 2021

A DBA makes sure the databases are backed up, well-configured, patched, secure, and fast. I explain my job to acquaintances by saying, “You know how some web sites are really slow, and their checkout times out, or it loses your data? It’s my responsibility to make sure those problems don’t happen. I’m not the only…

What If You Really DO Need to Shrink a Database?

Last Updated November 2, 2022

Brent Ozar

Production Database Administration

You’ve heard that shrinking a database is bad because it introduces both external and internal fragmentation, it causes blocking, it causes transaction log growth while it runs, and it’s slow and single-threaded. You understand that if it’s just a matter of 10-20-30% of a database, and the database is only 100-200GB, you might as well…

Can I Offload DBCC CHECKDB To Another Server?

Last Updated May 13, 2020

Brent Ozar

CHECKDB and Corruption

You want to check for corruption, but you don’t want to slow down your primary production server. In this post, I’m specifically talking about offloading the corruption checking process. I’m not talking about doing corruption checking on both the primary and other servers – that’s wonderful, and if you’re doing that, you should hug yourself. You’re doing…

Three Reasons to (Temporarily) Change Max Worker Threads

Last Updated January 7, 2020

Brent Ozar

Configuration Settings

When you go to the deli, there’s a “take a number” dispenser where you tear off a number and wait for your number to be called. If you walked into a deli and you saw 50 people lined up all waiting their turn, and you went to take a number and the dispenser was completely…

SQL Server 2019 Standard Edition Feature Limitations Are Out

Last Updated October 18, 2019

Brent Ozar

SQL Server 2019

The features list by edition is out, and there’s a disclaimer at the top: This content is being updated for SQL Server 2019. The information in the article is not final. Which means if you’re really angry, and your company buys a lot of licenses, now’s your time to raise holy hell with your Microsoft…

DBA Training Plan 20: Planning Your Next Server

Last Updated September 9, 2019

Brent Ozar

Architecture, DBA Training Plan

When the business decides it’s time to give up fixing the old server because it’s not fast enough or reliable enough, stop. The worst thing you can do is jump directly to the hardware vendor’s site, check a few boxes, and order a new shiny server that ends up with exactly the same problems as…

Why That “DBA” Job Posting Sounds So Terrible

Last Updated June 2, 2019

Brent Ozar

Professional Development

What follows are just some of the highlights from an actual job posting. I’m not including the job description, just the requirements that an applicant has to have in order to even throw their hat in the ring: Requires Bachelor’s degree or equivalent experience. Experience running and maintaining a 24×7 production computing environment Hands-on experience…

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

Last Updated August 9, 2020

Brent Ozar

Monitoring

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…

From The Server To The SAN

Last Updated January 3, 2019

Erik Darling

Hardware, SQLBits, Storage

Enter SANdman When people buy SANs, it’s often quite a large investment. Whether it’s all SSD, all flash, or there are tiers of storage that different types of data live on, those disks aren’t cheap. When people visualize their SAN, it’s usually just the server and the pool of drives. But there’s some important stuff…

38 Blog Posts We Couldn’t Write in 2018

Last Updated December 31, 2018

Brent Ozar

SQL Server

Behind the scenes here at Brent Ozar Unlimited, we’ve got a place where we jot down blog post ideas. Anybody from the company can add ideas, and anybody can pluck those ideas back out and flesh them out into blog posts. We’ve got a whopping 203 ideas sitting around. So I cleaned house and deleted…

20 Questions to Ask About Your Availability Group Design

Last Updated December 26, 2018

Brent Ozar

Always On Availability Groups

Questions about the overall project: What are your RPO and RTO goals? Are there financial penalties if we miss the goals? (Like contracts, refunds to customers, etc) Does this app have regularly scheduled maintenance windows, or is it 24/7? What’s the ballpark size of the data today? In 3 years? Questions about the team: How…

Have Availability Groups Gotten Easier Lately?

Last Updated December 3, 2018

Erik Darling

Always On Availability Groups, High Availability, SQL Server

Easy Lover I don’t blog a lot about AGs. If we’re being honest (and I do try to be honest with you, dear reader), I just like performance tuning topics way more. When new features get announced for AGs, some of you may ooh and aah, but not me. I Make A Face I don’t…

[Video] Office Hours 2018/11/14 (With Transcriptions)

Last Updated November 15, 2018

Brent Ozar Unlimited Team

Videos

This week, Tara, Erik, and Richie discuss using Docker in dev environment, in-place upgrades, disaster recovery, the minimum amount of CPU and RAM for new SQL Server VMs, troubleshooting long-running SQL agent jobs, dbcc checkdb running longer than normal, and more. Here’s the video on YouTube: You can register to attend next week’s Office Hours, or subscribe…

[Video] Office Hours 2018/11/7 (With Transcriptions)

Last Updated November 11, 2018

Brent Ozar Unlimited Team

Videos

This week, Tara and Richie discuss offline file database and log backup solutions, VSS database backups, monitoring products, parameterization, page latch waits, SQL ConstantCare™, and Availability Groups on 2017 Standard Edition. 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. Enjoy the…

Index Tuning Week: Fixing Nonaligned Indexes On Partitioned Tables

Last Updated September 28, 2018

Erik Darling

SQL Server

Unquam Oblite This post will not change your life, but it will help me remember something. When you decide to partition a table to take advantage of data management features, because IT IS NOT A PERFORMANCE FEATURE, or you have an existing partitioned table that takes advantage of data management features, because IT IS NOT…

What’s New in SQL Server 2019’s sys.messages: More Unannounced Features

Last Updated September 24, 2018

Brent Ozar

SQL Server 2019

The system table sys.messages holds error messages that SQL Server needs to return to end users. When a new build comes out, I love checking this table to see what features Microsoft has coded, but isn’t quite ready to announce yet. When SQL Server 2017 came out, that’s how I unmasked snapshot materialized views, a…

[Video] Office Hours 2019/09/12 (With Transcriptions)

Last Updated September 15, 2018

Pavel Amelishko

Videos

This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on a virtual box from the desktop where the virtual box is running, and what real DBAs…

Should Index Changes Require Change Control?

Last Updated September 6, 2018

Brent Ozar

Indexing

We got a phenomenal series of questions from a client, and I wanted to encapsulate the answers into a blog post to help more folks out: Should all index changes require testing in a staging environment, no matter how big or small? What would be a reasonable timeline duration from index identification to deployment? What…

[Video] Office Hours 2018/9/5 (With Transcriptions)

Last Updated September 8, 2018

Brent Ozar Unlimited Team

Videos

This week, Brent, Tara, Erik, and Richie discuss whether you should keep autoshrink on, AG multisite failovers, next version of SQL Server, SQL Server 2017 Vulnerability Assessment, SELECT INTO vs INSERT INTO, using Node.js with SQL Server, Using PowerShell for DBA tasks, the future of SQL Server for Linux, memory gateway query compile, VB.NET, patching,…

What’s Different About SQL Server in Cloud VMs?

Last Updated August 24, 2018

Brent Ozar

Cloud Computing

When you start running SQL Server in cloud VMs – whether it’s Amazon EC2, Google Compute Engine, or Microsoft Azure VMs – there are a few things you need to treat differently than on-premises virtual machines. Fast shared storage is really expensive – and still slow. If you’re used to fancypants flash storage on-premises, you’re…

Search Results for “mirroring”

Hi! I’m Brent Ozar.