Blog
Projects
About
Backtrack:
Blog
›
Limit memory usage of Windows …
›
Comments
Comments
Limit memory usage of Windows Internal Database
posted on August 26th 2014, at 12:13
by
lunarg
If the Windows Internal Database, used by WSUS, and which is actually an embedded SQL Server, is eating all of your memory, you can limit its memory usage the same way you would with a real SQL Server.
Open an elevated command prompt and launch the SQL prompt:
For WSUS4 (on Server 2012):
osql -E -S \.pipeMicrosoft##WIDtsqlquery
For WSUS3 (on Server 2008, 2008R2 and SBS 2008/2011)
osql -E -S \.pipemssql$microsoft##sseesqlquery
This will log you in with the current credentials (which is why it has to be an elevated command prompt). The SQL prompt (1>) is shown.
Enter the following commands to initiate advanced configuration:
exec sp_configure 'show advanced option', '1';reconfigure;
...
read more
Add a new comment
Your name:
Your e-mail:
Your comment:
Basic BBcode is supported.
Captcha:
Type the letters and numbers as shown.
Not readable?
Get another
.
Tags
computer
windows
software
vmware
microsoft
linux
exchange
hardware
network
news
mac
home
powershell
office365
msoffice
ad
server
sqlserver
dell
soaring
internet
esx
sbs
mssql
rds
events
terminalserver
powercli
hp
virtualization
Archive
«
‹
December 2024
›
»
Sun
Mon
Tue
Wed
Thu
Fri
Sat
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Links
-
@harkx
-
Cats & Dogs
-
Jargon-free Security Guide
Quote
«
Safety is not a coincidence.
»
Contact
© 2009-2024 Black Manticore – all rights reserved
code by
lunarg
, design by
SuriAmanah
, hosted at Cats&Dogs