Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
Page 1 of 1 (3 items)