Windows Forum

Ask something
Discussion Locked

High memory usage by SQL7 on NT4

0 helpful
3 replies

by matthias.tan 3 views

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

I have a NT4 Server running MS-SQL7, with 1.4G of memory and consisting of 2 P3 550Mhz processor.

Viewing from the Task Manager, the process, sqlservr.exe memory usage is always at around 1.2G. Very often the server will slow down tremendously hitting 100% CPU usage.

My question are, (1)is it a norm for the SQL process to be using such high memory and (2)will this be the reason for the server to encounter a 100% CPU Usage

3 replies

by karpi

Hello,

(1) maybe. It depends on your settings in the Enterprise-Manager (right-click on the Server, choose Properties and the Memory.

(2) maybe. SQL-Server tries to load all accessed Databases into RAM. It depends on the usage of the Database.Do you have many queries on non-indexed fields? How many Clients.

HTH
Karpi

This discussion is closed to new replies.