Windows Forum

Ask something
Discussion Locked

CPU Usage reaches 100%

0 helpful
5 replies

by tuando_99

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

CPU Usage reaches 100%,

When I connect to the internet, I go to Windows Task Manager, the CPU Usage reaches 100% after 2, 3 hours.

My system: OS: win pro 2000, SQL 2000, ...

The sqlservr.exe process is highest (around 95% all the time).
I have to reboot my desktop and it becomes normal again (CPU Usage is around 4% to 10%)

How could you explain this?

Thanks,
Tuan Do

5 replies

by d.walker5

Sound's like a "memory leak." This is a bug in a program that prevents it from freeing up memory that it no longer needs. As a result, the program grabs more and more memory until it finally crashes because there is no more memory left. Check the Task Manager, CPU useage to see the problem process. Also, the is a command line program Qslice.exe that will show you problem is a bar graph. Contact the offending program's support desk for a possible fix.

by ideafixer

Are people using your PC as a database when on the Internet? Depending on how much ram you have available you may need to adjust how much memory you leave available for SQL/Server.

This adjustment can be made in Enterprise Manager at the server level. Right click on the server node and go to the memory tab in properties.

This discussion is closed to new replies.