Tag: Shared Disks

SQL Server FCI or AG?

What’s the Difference in SQL Server FCIs and AGs?

“What’s the difference in SQL Server FCIs and AGs?” That question comes up frequently when talking High Availability and Disaster Recovery (HADR). It’s especially important when “Everything stops and people can’t do their jobs if SQL Server is unavailable.” There are a lot of how-to articles on the internet for setting up Always On Failover…
Read more

SQL Server disk IO traffic jam

Identifying SQL Server Disk Latency

When SQL Server is not as fast as users think it ought to be, how can you tell where the slowdown is? Where’s the performance bottleneck? Where’s the traffic jam? Is it waiting on CPU? Does it needs memory? What about the disks? Could SQL Server be slow because of disk latency? Could be. But…
Read more

Learning SQL Server

Learn SQL Server with PluralSight’s FreeApril

“I want to learn [a technology]. Where should I start?” Since I’ve spent the last 25 year working with SQL Server (no exaggeration, see footnote), the question is usually about learning SQL Server. Sometimes it’s about learning related technologies such as data analytics and visualization, scripting languages such as Python or PowerShell, or the burgeoning…
Read more

some things in sql server are scary but not dangerous

Scary and Dangerous Things in SQL Server

Some things are scary. Other things are dangerous. And in SQL Server, you can have both scary and dangerous at the same time. Scary, that we can deal with. But dangerous, particularly things that are deceptively dangerous, is bad. Scary things Let’s start with scary. Some things give us pause. We see them, think about…
Read more

Stop doubting your sql server environment

Five Goals for Your SQL Servers in the New Year

We’ve made it! The start of a new year. Now is a great time to reflect on what you’d like to accomplish over the next 12 months at work, and more specifically, what you would like to do with your SQL Server environment this year. To help with that, here are five activities or goals…
Read more

Avoid working without a net; implement a SQL Server HADR option

High Availability and Disaster Recovery in SQL Server

We’re often asked about SQL Server High Availability and Disaster Recovery (HADR) options to help customers protect their data and improve their uptime. No surprise there. When a SQL Server provides a critical component of your daily operations you need those databases to be available. Simply put, when a user needs information from the database…
Read more

A properly configured SQL Server is like a well tuned race engine.

Identify Disk I/O Performance Issues for Your SQL Server Using DiskSpd

“We need faster storage.” Sound familiar? Or what about “No, the storage is good; we need to tune the database.” Often teams will have very different opinions about the root cause of a performance issue. Microsoft’s free DiskSpd utility can help identify disk I/O performance issues for your SQL server systems. Here’s a short introduction…
Read more

Azure shared disks – Failover Clustered Instance – SQL Server 2016

In my last post, I wrote about a new option in Azure – shared disks. Have you ever needed to build a Failover Cluster Instance (FCI) in Azure? This post will provide a few steps to get you started. To follow along with the demo, you’ll need an Azure account (available for free here )…
Read more