Over 10 years we help companies reach their financial and branding goals. Engitech is a values-driven technology agency dedicated.



411 University St, Seattle, USA


+1 -800-456-478-23

MSDE SQL 2000 OSQL Notes

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

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

USE master
EXEC sp_configure ‘show advanced options’, 0

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

Angel Computers – Contact Us

More Posts

Is It Time to Migrate from G Suite to Microsoft 365?

Google’s G Suite (now called Google Workspace) and Microsoft 365 are the major productivity software players competing for attention, and both are worthy of consideration for entirely different reasons. However, many companies eventually leave the startup phase and outgrow G Suite. This is when you know it’s time to migrate to Microsoft 365.

The Importance and Features of KnowBe4

In light of OpenAI’s viral ChatGPT platform, users worldwide are leveraging the tool to accomplish tedious tasks, improve their workflows, or just have fun. We look at how AI tools like ChatGPT function, and then we’ll review some positives and negatives when it comes to using it at your place of work.