The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Sometimes the problems aren't your code. Here a few places where re-examining your assumptions can help improve software development.
2026-04-06
1,772 reads
Troubleshooting
The Devil is in the Details
The story of an engineer solving a problem is a good one that shows technical skills and a passion for the work.
2021-01-05
132 reads
Network Issue or THREADPOOL waits?
Tara Kizer talks identifying THREADPOOL waits and what you can do about them.
2018-01-30
3,043 reads
TroubleShooting SQL Server Memory Consumption
Satnam Singh walks through the steps he took to troubleshoot a recent issue with memory consumption on a staging server.
2017-03-10
6,023 reads
SQL Server Performance Troubleshooting with SQL Monitor 5
Any SQL Server monitoring tool must gather the metrics that will allow a DBA to diagnose CPU, memory or I/O issues on their SQL Servers. It should also provide a set of accurate, reliable, configurable alerts that will inform the DBA of any abnormal or undesirable conditions and properties, as well as specific errors, on any of the monitored servers. This article provides an in-depth guide to the monitoring and alerting functionality available in one such tool, Redgate SQL Monitor. It focuses on the latest edition (5.0), which includes several key new features, such as performance diagnosis using wait statistics, the ability to compare to baselines, and more.
2016-02-29
3,147 reads
Free eBook: Troubleshooting SQL Server: A Guide for the Accidental DBA
Three SQL Server MVPs (Jonathan Kehayias, Ted Krueger and Gail Shaw) provide fascinating insight into the most common SQL Server problems, why they occur, and how they can be diagnosed using tools such as Performance Monitor, Dynamic Management Views and server-side tracing. The focus is on practical solutions for removing root causes of these problems, rather than "papering over the cracks".
2020-11-04 (first published: 2013-08-07)
103,660 reads
Pascals Triangle, Home Work and Root Cause Analysis
A lively comparison of Pascal's triangle to root cause analysis from David Poole.
2011-10-19
4,519 reads
Troubleshooting Performance Problems in SQL Server 2008
This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.
2009-07-31
4,809 reads
Troubleshooting
New author Mike Walsh brings us an interesting analogy on troubleshooting skills that might get you to think differently about how you attack problems.
2009-04-02
6,285 reads
Blogs
Did You Really Name That Default?
By alevyinroc
Ten years (and a couple jobs) ago, I wrote about naming default constraints to...
Monday Monitor Tips: A New Analysis Page
By Steve Jones
We have multiple teams (8) working on Redgate Monitor. Some work on the Standard...
Case Studies: Real-World Success Stories of FinOps Implementation
By HeyMo0sh
Learning any kind of theory is easy, but adapting FinOps and watching it rescue...
Forums
The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI
Comments posted to this topic are about the item The day-to-day pressures of a...
The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions
Comments posted to this topic are about the item The Problem Isn't Always Your...
Identity Defaults
Comments posted to this topic are about the item Identity Defaults
Question of the Day
Identity Defaults
What happens when I run this code?
CREATE TABLE dbo.IdentityTest
(
id int IDENTITY(10) PRIMARY KEY,
somevalue VARCHAR(20)
)
GO
See possible answers