A couple weeks ago I was asked to look at system performance for a customer, and as part of my investigation I found a high read query. I had run a trace and filtered for anything over 10,000 reads and saw a query that required around 32,000 reads, and it was running at least once…
Backups and Disk Space
I was in Phoenix last week to visit a customer, and I saw an email come through regarding a customer who contacted support because they discovered they were missing data from a table. The customer contacted support on Friday morning and our team was engaged almost immediately. The data loss had been discovered on Thursday…
Introducing the 2012 Performance Virtual Chapter Team
In late November I wrote a post asking for volunteers for the Performance Virtual Chapter. There was a great response, and many thanks to those who replied! Without further ado, let me introduce the Performance VC team for 2012: Speaker Wrangler: Carlos Bossy ( b | t ) I briefly met Carlos at the SQLSaturday…
Page Allocation: Dedicated vs. Mixed Extents
When I was at a SQLSaturday a few months ago, I attended a session that hit upon SQL Server Internals, one of my favorite topics. During the session the presenter was talking about page allocation, and mentioned that pages for a table and its indexes will reside in the same extents. Now, I remember immediately…
