Welcome to MSDN Blogs Sign in | Join | Help

February 2009 - Posts

Wednesday, February 18, 2009 6:40 PM

No SQL posts this week - skiing again!

I am fortunate enough to be contining the testing of my hypothesis that skiing in Sweden is better than SQL Server support. This week I am testing this theory in Sälen, near the Sweden - Norway border. So far it's all going very much to plan. enjoy the
Posted by grahamk | 0 Comments
Filed under: ,
Friday, February 13, 2009 9:44 AM

Kill with rollback estimation

It's always amazing when you find something new in something so common that you thought you knew so well. When resolving the compilation bottleneck issue I mentioned in the previous 2 posts, I had to use the kill command. It's actually incredibly rare
Posted by grahamk | 1 Comments
Wednesday, February 11, 2009 7:43 PM

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
Posted by grahamk | 1 Comments
Tuesday, February 03, 2009 3:33 PM

SQL Server Compilation Bottlenecks – Error: 8628, Severity: 17, State: 0. – Part 1

[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
Posted by grahamk | 2 Comments
Monday, February 02, 2009 4:48 PM

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
Posted by grahamk | 2 Comments
Filed under: , , ,
 
Page view tracker