Recompile Monitoring using XEvents
How recompiles can hurt you, and how you can hunt them down using sql_statement_recompile.
2016-03-07
22 reads
Simple SQL Server
I/O Baseline Comparison – Idera Diagnostic Manager
What servers need the most attention when it comes to I/O? When I increase the memory on a server what...
2016-02-29
930 reads
I/O Baseline Comparison – Idera Diagnostic Manager
What servers need the most attention when it comes to I/O? When I increase the memory on a server what effect does it have on I/O? What was it...
2016-02-29
9 reads
Wait Stats Baseline Comparison – Idera Diagnostic Manager
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes...
2016-02-22
675 reads
Wait Stats Baseline Comparison – Idera Diagnostic Manager
Database servers have to wait on different resources, and these waits are huge to the performance of SQL Server. Sometimes something changes without our knowledge and is running differently...
2016-02-22
19 reads
Shrinking Database Log Files
Files in SQL Server need to grow as the database grows, and in very specific circumstances need to be shrunk...
2016-02-15
1,277 reads
Shrinking Database Log Files
When should you shrink your log files and what does it mean to performance?
2016-02-15
55 reads
Database Log VLFs
Virtual Log Files (VLFs) split a physical database log file into smaller segments, which are required for how log files...
2016-02-08
791 reads
Database Log VLFs
Transaction logs are split into VLFs which affects performance. How large are yours and what does that mean for you?
2016-02-08
64 reads
TempDB Excessive Memory Usage Example
I see TempDB using more memory than I feel it should and found a way to resolve it. Previously I...
2016-02-05 (first published: 2016-02-01)
2,728 reads
Blogs
The Mystery of SQL Server 2025’s New Tricks – Scooby Dooing Episode 5
Every Scooby-Doo mystery starts with a haunted house, a strange villain, and a trail...
A Prompt AI Experiment
By Steve Jones
Prompt AI released recently and I decided to try a few things with the...
SQL Server Is Slow (part 1 of 4)
By Kevin3NF
How should you respond when you get the dreaded Email/Slack/Text/DriveBy from someone yelling at...
Forums
how to get notification that my database has corssed 8gb
i have sqlexpress on rds, is there any way i can get notifacation that...
SQL Server, Heaps and Fragmentation
Comments posted to this topic are about the item SQL Server, Heaps and Fragmentation
Stairway to Azure SQL Hyperscale – Level 2: Page Server Architecture Explained
Comments posted to this topic are about the item Stairway to Azure SQL Hyperscale...
Question of the Day
SQL Server, Heaps and Fragmentation
A table without a clustered index (heap) will NOT suffer from fragmentation during frequent updates or deletes. True or False?
See possible answers