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

Gallery

Contacts

411 University St, Seattle, USA

engitech@oceanthemes.net

+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
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

More Posts

Why Is It Important to Have a Robust DNS Filter?

A robust suite of cybersecurity tools is a vital necessity for any business. Failing to protect your network and devices can have huge financial consequences. DNS filters are more than just a tool — they’re an investment in your business. Here’s how having your IT team set up a DNS filter can provide big benefits across your organization.

Employee Spotlight: Mark

For this months employee spotlight we’re featuring new-again employee, Mark. He previously worked at AngelCom for 7 years and is back in the role of Director of Support.

Gear Up for 2024: 7 Ways an MSP Can Revamp Your IT Solutions

With the new year just weeks away, now is the perfect time to reflect on your IT strategies. Whether your IT solutions are due for a total overhaul or if you just want to make sure everything is fine-tuned for the start of 2024, consider partnering with a managed services provider (MSP).