Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Performance

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2000-08-24 : 08:22:43
Frank writes "After a few days of running the SQL Services (mssqlserver and the sql server agent) the two processors on the server show about 50% CPU usage. We run SQL Server 7.0 and NT4 with SP6.

This is strange because at those times (at night) there are no clients connected to the server and there are no jobs that are running. The minimum processor load is always at least 50% busy doing nothing.

When we restart the services the problem is gone for a few days and then it comes back. When we reboot the server the problem stays???

I also tested this on another server with 4 processors and here everything works just normal.

Does anybody have suggestions for this problem?"

   

- Advertisement -