Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » memory   (RSS)
Tuesday, June 02, 2009 1:20 PM

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:
Posted by grahamk | 1 Comments
Friday, March 27, 2009 4:08 PM

How to Customise SQLDIAG in SQL Server 2008 to collect DBCC MEMORYSTATUS

Although Books Online makes some mention of SQLDIAG customizations, it doesn’t any explicit examples, so here’s one for you. I documented previously here about how to customize your XML configuration file to connect to different machines, and collect
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
Thursday, September 11, 2008 6:49 PM

Non-yielding IOCP Listener - Stack Dump analysis

Here's something I was looking at yesterday which is worth a quick look. It's quite a common scenario and one that's relatively easy to address. Your SQL Server 2005 instance suddenly throws the following to the error log (apparently without warning):
Posted by grahamk | 1 Comments
 
Page view tracker