<div>
<div class="content wysiwyg-content">
I had an issue yesterday which seriously affected the performance of an application based on SQL Server running on a Windows 2000 Server cluster.<br />
<br />
clussvc.exe and lsass.exe, along with SQL were taking 100% CPU making the server so busy SQL could not respond to client requests.<br />
<br />
We have established that there was no unusual activity on in terms of things running against the database, nor are there any issues with the hardware. Nothing unusual in the Event logs either. SQL was failed-over to the other node in the cluster, but within a few minutes that was in the same state. After about 4 or 5 hours the problem vanished, which is great until it comes back and we still don't have a 'fix'.<br />
<br />
This is the only reference I could find with a Google, was this which pretty much matches our problem but there is no clear resolution.<br />
clussvc.exe, lsass.exe take over cpu...sql processing stopped<br />
<a href="http://www.dbforums.com/archive/index.php/t-308429.html" rel="ugc">http://www.dbforums.com/archive/index.php/t-308429.html</a><br />
<br />
Any help or suggestions greatly appreciated.
</div>
</div>


I had an issue yesterday which seriously affected the performance of an application based on SQL Server running on a Windows 2000 Server cluster.

clussvc.exe and lsass.exe, along with SQL were taking 100% CPU making the server so busy SQL could not respond to client requests.

We have established that there was no unusual activity on in terms of things running against the database, nor are there any issues with the hardware. Nothing unusual in the Event logs either. SQL was failed-over to the other node in the cluster, but within a few minutes that was in the same state. After about 4 or 5 hours the problem vanished, which is great until it comes back and we still don't have a 'fix'.

This is the only reference I could find with a Google, was this which pretty much matches our problem but there is no clear resolution.
clussvc.exe, lsass.exe take over cpu...sql processing stopped
http://www.dbforums.com/archive/index.php/t-308429.html

Any help or suggestions greatly appreciated.

CPU 100% on SQL Server running on Windows 2000 Server cluster

The term "Backup" means the methods and processes involved to copy computer data (system data as well as application data) to media other than the ones where the data originally live (disk, tape, optical, cloud). "Restore" in turn means the methods and processes involved in data recovery, i. e., bringing back copied computer data to their original location. Backup/Restore primarily serves as a means of protection against data loss, be it due to disaster, corruption or sabotage. It can also be used for recovering data from an earlier point in time and even for cloning machines or applications. There is a wide variety of backup/restore software available, from expensive commercial products to free or open source tools.

Storage Software

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.