SQL Server 2005 Error: 701, Severity: 17, State: 193

Here’s another interesting example which we worked recently in the Stockholm office, which relates also back to one of my previous entries. We had a customer whose error log was filled with a variety of critical errors such as these: Error: 701, Severity: 17, State: 193. There is insufficient system memory to run this query….


Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 2

[follow up to RESOURCE_SEMAPHORE_QUERY_COMPILE diagnosis] Last week I wrote about the initial diagnosis of this problem, and now here’s the follow up. So if you remember we had a DBCC MEMORYSTATUS and a load of other PSSDIAG data collected and we knew that the procedure cache seemed to be constantly flushing as fast as we…


Which sessionid has the most locks in a SQL Server instance

Quick post today. Was playing around with something on Friday night, thinking how to answer this question quickly whilst looking a live performance problem. I have a huge selection of ready to go DMV based queries, aimed at targetting all types of performance problems, but this was one I didn’t have. The answer of course…