We’re up to the seventh post on the in the plan cache series. This time we’ll be talking about the last of the possible children for the Statements elements – the StmtSimple element. StmtSimple, commonly referred to as statement simple, can contain the plan information for a query plan, a store procedure, or a user … Continue reading Can You Dig It? – StmtSimple Element
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt A few posts ago in the plan cache series I discussed the children for the Statements element. I’ve gotten through two of the elements and in this post we’ll be … Continue reading Can You Dig It? – StmtCursor and StmtReceive Elements
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt A couple posts ago in the plan cache series I discussed the children for the Statements element. This next post will focus on the second of the five possible child … Continue reading Can You Dig It? – StmtCond Element
Follow the rest of this series at the Can You Dig It? - Plan Cache series introduction post. She can dig it! D Sharon Pruitt The last post in the plan cache series discussed the children for the Statements element. As I noted in that post, there are five possible children. This post will focus … Continue reading Can You Dig It? – StmtUseDb Element
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 last couple plan cache posts, I talked about a couple items that are available within the SHOWPLAN XML for an execution plan. These posts looked at how to … Continue reading Can You Dig It? – SHOWPLAN XML Structure
Just in time for Christmas, SQL Server 2005 Service Pack 4 has RTM’d. If you are using SQL Server 2005 make sure you take a look at this and the Microsoft SQL Server support lifecycle to see that you have the coverage that you need. As I mentioned a few months back, it is important … Continue reading SQL Server 2005 Service Pack 4 RTM
A client asked a co-worker to take a look at a query for reviewing RING_BUFFER_OOM messages in sys.dm_os_ring_buffers. He remembered that I’ve recently had a thing for XQuery and asked me to take a look at it. To play around with the output of this query, generate some RING_BUFFER_OOM messages in the sys.dm_os_ring_buffer. This can … Continue reading Viewing RING_BUFFER_OOM Errors
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
Strate SQL 