Search Results for “mirroring”

  1. Home
  2. Search Results
  3. (Page 2)
Brent Ozar in a tin foil hat

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

Monitoring
83 Comments
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

From The Server To The SAN

Hardware, SQLBits, Storage
6 Comments
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…
Read More
Brent getting caffeinated

38 Blog Posts We Couldn’t Write in 2018

SQL Server
0
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…
Read More
Office Hours Podcast

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

Videos
0
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…
Read More
Office Hours Podcast

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

Videos
0
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…
Read More

Should Index Changes Require Change Control?

Indexing
9 Comments
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…
Read More
Brent Ozar reading

What’s Different About SQL Server in Cloud VMs?

Cloud Computing
7 Comments
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…
Read More
Office Hours Podcast

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

Videos
0
This week, Brent, Erik, and Tara discuss their SQL server specialization, CPU-ready time, making SSIS changes globally rather than one at a time, creating an Always On AG farm, Azure managed instances, going from log shipping to Availability Groups, tracking folks that executed queries, moving databases into Availability Groups, an exciting update to SQL Server…
Read More
Office Hours Podcast

[Video] Office Hours 2018/6/27 (With Transcriptions)

This week, Brent, Erik, Tara, and Richie discuss using SQL Server 2016 vs 2017 for production environment, reporting, reindexing jobs, Azure vs Amazon, parameter sniffing, creating custom alerts for agent jobs, activity monitor, troubleshooting SQL Server 2014, replication, turning off auto-updating stats on tempdb, and why Brent can’t get a tan. Here’s the video on…
Read More