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

Quarterly Maintenance Audit: Why It’s Important.

At AngelCom, we preform quarterly maintenance audits that allow us to take a deeper look into a customer’s systems, setup, and hardware to ensure everything is functioning as intended. This comprehensive overview allows us to ensure your system is functioning as intended. Learn about why it’s so important here.

How Managed IT Services Can Reduce Costly Downtime

Instead of worrying about how much a period of downtime could cost you, it’s better to have a plan in place that can reduce and prevent it whenever possible. And a managed IT partner can help you devise such a strategy.

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.