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)
 sql 6.5 memory usage

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-07-13 : 08:23:57
hernan writes "What determine's SQL 6.5 memory usage?

Reason why i ask is i have a production NT 4.0 Server box with SQL 6.5 running and it show sqlserver.exe memory usage to be around 200MB - 250MB. This is the production server which is constantly accessed.

I have another NT machine with 6.5 installed and it is showing that sqlserver.exe memory usage to be about 400K - 450K. This server is just the backup and is not accessed at all by any user or programs. I checked to see if there are any SQL tasks running and there are none. I've rebooted the machine but the memory usage doesn't change.

I used NT's Task Manager to determine the memory usage.

Thanks in advance."
   

- Advertisement -