Solved

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

Posted on 2006-11-07
3
1,151 Views
Last Modified: 2013-11-15
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.
0
Comment
Question by:AsiaIT
3 Comments
 
LVL 5

Accepted Solution

by:
MrNetic earned 500 total points
ID: 17898686
When that happens again,

Turn on the profiler, to see what was happening, that could also be caused by DB LOCKS.

Best Regards,

Paulo Condeça.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Microservice architecture adoption brings many advantages, but can add intricacy. Selecting the right orchestration tool is most important for business specific needs.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
Viewers will learn how the fundamental information of how to create a table.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question