Fail Over, Fail Again, Fail Better - Preparing for Disaster Recovery (Dear SQL DBA)
Category:
database-administration
You’re setting up SQL Server log shipping for disaster recovery. What else do you need to do to best prepare for a failure?
Will Query Store Work in a Read Only Database?
Category:
query-performance
For static databases, it’s quite useful to set SQL Server’s “read only” database property to true. When the database is read-only, it ensures that the last backup you took is still valid… as long as nothing bad happens to that backup file.
Outside the Big SAN Box: Identifying Storage and SAN Latency in SQL Server (Dear SQL DBA)
Category:
database-administration
Dear SQL DBA, What do you say to a SAN admin when you think that the billion dollar SAN *may* be the bottleneck and you just want to look into it. What are the technical things I need to say to make them believe there might be something to my questions?
Target Recovery Interval and Indirect Checkpoint - New Default of 60 Seconds in SQL Server 2016
Category:
query-performance
Update, 6/21/2016: Be careful using indirect checkpoint with failover clusters if your SQL Server 2014 instance is not fully patched. See KB 3166902. This bug was fixed in SQL Server 2016 prior to RTM.
SQL Server 2016 introduces big new features, but it also includes small improvements as well. Many of these features are described in the “It Just Runs Faster” series of blog posts by Bob Ward and Bob Dorr.
Next Door to Derpton - When Your Fellow DBA is a Danger to Databases (Dear SQL DBA)
Category:
database-administration
What do you do when your fellow DBA is a ticking time-bomb of bad decisions, waiting to explode your production environment?
Merging Boundary Points: Does a Changing Partition_Number Indicate Data Movement?
Category:
database-administration
I received a question from a reader who was testing out a partitioning architecture:
We are testing table partitioning using one filegroup per partition. When we merge a boundary point, we see that partition_number changes in sys.partitions. Does this mean that data movement is occurring?
Lost in Performance Troubleshooting - Perf Triage for SQL Server
Category:
monitoring-troubleshooting
Psssttt – I have an updated blog post on this called the Learner’s Guide to SQL Server Performance Tuning
The SQL Server is slow, what should you do? I answer a reader question and share my strategy for performance troubleshooting.