MSDE SQL 2000 OSQL Notes

In Knowledge Base Blog by angeladmin

Adjust Memory SQL uses:
I noticed that my 2K3 Server just recently was becoming unresponsive. After taking a look at task manager it showed that sqlservr.exe was taking up 1.5 GB of the total 2.0 GB of RAM. I then did the following to set the memory usage of WSUS to just 512 MB:

osql -E -S SERVERNAMEwsus-i setchecksqlmemory.sql

where ‘setchecksqlmemory.sql’ consisted of:
USE master
EXEC sp_configure ‘show advanced options’, 1
RECONFIGURE WITH OVERRIDE

USE master
EXEC sp_configure ‘max server memory (MB)’, 512
RECONFIGURE WITH OVERRIDE

USE master
EXEC sp_configure ‘show advanced options’, 0
RECONFIGURE WITH OVERRIDE

It is showing less memory used (512), but the server is still very slow. Any possibilities of a memory leak that you are aware of? There are no other applications on this server, just WSUS. Specs are dual 3.6 xeons with 2 GB ram.

EXEC sp_changedbowner ‘sa’

Show Databases
use master
sp_databases
go

Angel Computers – Contact Us