Browse by Tags

On Monday we released Cumulative update package 5 for SQL Server 2008 Service Pack 1, under KB975977 . Contained in this was a very interesting fix to a long running issue with regards to the option recompile syntax and its changed behaviour in SQL Server 2008. This fix has its own KB article at KB976603...

[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...

[alternative title: Memory Troubleshooting using DBCC MEMORYSTATUS] The following samples are taken from a live problem I was working on for most of last week. The steps might well help you resolve an occurrence of the above error, but the methodology might help you with some general performance and...