Backups & the Buffer Pool
As we know with Microsoft SQL Server everything is processed from disk and loaded into the buffer pool for processing by the query engine. So what happens to the buffer pool when backups are taken? The answer is that nothing happens to the buffer pool. When SQL Server is backing up data from the disk, […]
Performance Tuning a Spotlight for SQL Server Query
The other day I was looking at parallel query plans on a customers system and I noticed that the bulk of the parallel queries on the system where coming from Spotlight for SQL Server. The query in question is used by spotlight to figure out when the most recent full, differential and log database backups […]
A week of using my Surfii (when you have more than one Microsoft Surface)
So while at the TechEd North America conference Microsoft gave the attendees, speakers and booth staff the ability to purchase some Microsoft Surfii (surf-I) at some major discounts. The Surface RT was available for $99 US and the Surface Pro was just $399 US. Needless to say I purchased both of them. I’ve been using […]
Read Only Routing Configuration UI
One of the big downsides to using the SQL Server 2012’s AlwaysOn Availability Group feature is that there is no UI to help you configure read only routing. Thankfully there is a fix for this. Denny Cherry & Associates Consulting is happy to announce the first of or AlwaysOn Tools which is the Read Only […]