• subscribe
February 09, 2000 12:00 AM

I have a SQL Server process that shows as being in SPINLOOP. What does this mean?

Windows IT Pro
InstantDoc ID #14402

A. The process concerned is accessing an area of memory that SQL Server needs to protect against multiple access - typically on SMP servers. To this end it locks that area of memory (via a spin lock) so that any other access to it gets paused. In concept it is very similar to row/page locking in a database, but is used for internal memory areas within a program. There is plenty of documentation in the Win32 SDK/MSDN about spin locks and their usage.

If the SPINLOOP process does not give up control then it is very likely that SQL Server will become unresponsive. It is unlikely that you will be able to KILL a process in this state and you will probably have to kill SQL Server itself (use KILL command from the NT Resource Kit)

If you are suffering a lot of degradation due to spinloops, then you will need to raise a paid fault call with Microsoft PSS to resolve it.




ARTICLE TOOLS

Comments
    There are no comments to display. Be the first one!
You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...