January 20, 2005 at 1:28 pm
Sporadically, our MS SQL Server 2000 database server hangs. Only error message we found is the following:
Operation
Debug print: "2005-01-20 12:10:49.74 getspinlock pre-Sleep(): spid 64, 10000 yields on lock type MEM_MGR (adr 0xa63af8)\n"
Process
sqlservr.exe:3064:1352
Causality ID: {FC336258-60C6-4395-8129-767CFADF7402}
Module
sqlservr.exe
When the database hangs, no connections of any type can be made. SQL Server needs to be stopped and restarted in order to use it again.
A search of Microsoft, yielded bug #17149 with similar "hang" symptoms but it is related to 6.5 and was fixed.
Any ideas?
January 24, 2005 at 8:13 am
Are you running perfmons against the machine? If not add some counters for memory, both OS and SQL related, see if this gives you any ideas.
January 25, 2005 at 9:57 am
Yes. No excessive use of memory, cpu, etc. All we know for sure is that some time within a couple of hours of running transaction log backups, sql server freezes and can only be stopped and re-started using Services.
January 25, 2005 at 10:00 am
is SQL using all of the available free memory on the system (or that you have allocated to it)?
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply