Ever think to yourself, “hmm, I wish I could generate me some RING BUFFER_OOM errors”? This request happened to come up tonight. Of course, the person asking for this was myself, but an answer was found nonetheless. Below are a couple scripts that can be used to generate RING_BUFFER_OOM errors in sys.dm_os_ring_buffers. Setup For RING_BUFFER_OOM … Continue reading Generating RING_BUFFER_OOM Errors
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt When I started using XQuery to dig into the plan cache, it was just searching for some parallelism and I really wasn’t aware that I was using XQuery. I just … Continue reading Can You Dig It? – Missing Indexes
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In the lead in to this post, I talked about how the plan cache can be a gold mine of information. There are a number of places that one can … Continue reading Can You Dig It? – Parallelism in the Plan Cache
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt In this new series of posts, I plan to investigate the SQL Server plan cache. We’ll start with a little introduction of the plan cache and move into ways in … Continue reading Can You Dig It? – The Plan Cache
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server Microsoft Certified Master. Second, I failed said exam. While that might be a circumstance for pity, we should all be glad. Where’s the bar? First off, the exam is tough. Anyone that thought that the … Continue reading Cry, Baby, Cry! Failing the MCM Test
One thing that stuck out for me at the PASS Summit was the changes announced for the SQL Server Microsoft Certified Master (MCM) Program. The MCM program is Microsoft’s upper tier database administration certification. It is aimed at providing a validation of skills and knowledge for those with 5 or more years experience with SQL … Continue reading The SQL Server MCM Training Has Changed
Last week, a new white paper was released that discusses supportability roadmaps for ISVs. The white paper is Testing and Developing Supportability Roadmaps for Independent Software Vendor Applications. What a mouthful… aren’t you glad you aren’t working at an ISV? Well, even if you aren’t I’d recommend reading this white paper because it applies to … Continue reading White Paper of Supportability Roadmaps
Finally up to the last post of this series resurgence. Time to update the Index Analysis Custom Report that I developed last year. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find … Continue reading Return of the Index Analysis Report
Alright, up to the last of the changes I’ve made to the index analysis query that I had planned. This makes the fifth post in the series on this query. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output … Continue reading Return of Index Analysis Part 5
We’ve got through the first three parts of this continued series on the Index Analysis query last week. The previous posts in this complete series are: Analyze Your Indexes Part 1 – Combine existing index statistics and missing indexes into a single output Analyze Your Indexes Part 2 – Find existing duplicate and overlapping indexes … Continue reading Return of Index Analysis Part 4
Strate SQL 