Solved

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

Posted on 2006-11-07
3
1,155 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

Question has a verified solution.

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

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
Microsoft will be releasing the Windows 10 Creators Update in just a matter of weeks. Are you prepared? Follow these steps to ensure everything goes smoothly and you don't lose valuable data on your PC.
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

719 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