網頁

▼
2026-03-02

Filtered Index can lead to a reduction in query performance

›
This month, I faced a compelling performance challenge that I am eager to share. My client indicated that one of their older data cleanup ta...
2026-02-02

SQL Server terminated unexpectedly because of Memory exhaustion and Oracle Linked Server

›
This month, I want to discuss an incident involving one of my clients, where their production SQL server was unexpectedly terminated.  Momen...
2026-01-05

TempDB LOGBUFFER and IO_COMPLETION Waits

›
We observed numerous SQL sessions that were waiting for LOGBUFFER and IO_COMPLETION ; all of these sessions were executing an INSERT INTO #...
2025-12-02

Slow disk in Tempdb leads to unexpected failover of the Availability Group

›
A problem arose for one of my clients, as their production SQL Server availability group kept failing over back and forth. Presented below i...
2025-11-02

Gather the Usage and Size of all Indexes across every database

›
EXEC sp_MSforeachdb 'USE [?]; SELECT DB_NAME() AS DB,     OBJECT_NAME(i.[object_id]) AS [TableName],     i.name AS [IndexName],     i.in...
2025-10-03

Assessing the Latency of Availability Group Database Synchronization

›
The SQL script provided below can be utilized to assess the real-time latency in seconds of SQL Server AlwaysOn synchronization. ;WITH AG_St...
2025-09-14

Snapshot Replication Agent Profile's Parameter BcpBatchSize

›
This week, a customer of mine shared the image below, mentioning that their Snapshot Replication is experiencing bad performance. The custo...