WSUS 3.0, Windows Internal Database, and Memory Usage
I'm posting this here, not because I think anyone will care, but because if I ever have to do this again I want to be able to remember it!
With the release of WSUS 3, Microsoft switched from MSDE to Windows Internal Database. I did the upgrade for a client on Tuesday, and came back to finish patching some of his systems today... lo and behold, the sqlservr.exe process was eating 1.6GB of RAM. Thanks, Microsoft.
I'd seen this before with the full versions of the SQL Server product, and was pretty sure I could fix it... till I realized that it was no longer MSDE. Initially, googling showed me how to do this with OSQL... but guess what? It wasn't present in the Binn directory where sqlservr.exe was running. Thanks again, Microsoft... I mean, why would ANYONE need to reconfigure a running instance? Let's save space and not include management tools.
After more googling, here's what I found:
1) Install the management tools for SQL Server. You can find the necessary files here: Microsoft SQL Server Native Client and Microsoft SQL Server 2005 Command Line Query Utility.
2) Run the sqlcmd utility and change the config options.
Voila. No more freaking RAM for you, sqlservr.exe. :P
With the release of WSUS 3, Microsoft switched from MSDE to Windows Internal Database. I did the upgrade for a client on Tuesday, and came back to finish patching some of his systems today... lo and behold, the sqlservr.exe process was eating 1.6GB of RAM. Thanks, Microsoft.
I'd seen this before with the full versions of the SQL Server product, and was pretty sure I could fix it... till I realized that it was no longer MSDE. Initially, googling showed me how to do this with OSQL... but guess what? It wasn't present in the Binn directory where sqlservr.exe was running. Thanks again, Microsoft... I mean, why would ANYONE need to reconfigure a running instance? Let's save space and not include management tools.
After more googling, here's what I found:
1) Install the management tools for SQL Server. You can find the necessary files here: Microsoft SQL Server Native Client and Microsoft SQL Server 2005 Command Line Query Utility.
2) Run the sqlcmd utility and change the config options.
c:\Program Files\Microsoft SQL Server\90\Tools\binn\SQLCMD.EXE -S -E \MICROSOFT##SSE
1> sp_configure 'show advanced options', 1;
2> reconfigure;
3> go
Configuration option 'show advanced options' changed from 0 to 1. Run the RECONFIGURE statement to install.
1> sp_configure 'max server memory', 512;
2> reconfigure;
3> go
Configuration option 'max server memory (MB)' changed from 2147483647 to 512. Run the RECONFIGURE statement to install.
1> exit
Voila. No more freaking RAM for you, sqlservr.exe. :P
posted by xthor at 11:35 AM
45 Comments:
Thank you very much for the information. It was very useful.
I too found the OSQL method but needed an alternative solution. This is just the job, many thanks.
Great Information
I just did the upgrade from WSUS 2 to v3 and it (tried) installed the 2005 db without the above tools.
The database failed to upgrade because of a permissions problem however to change the permissions you need the tools you have listed above.
Gotta use this command with the new WSUS:
sqlcmd -S \\.\pipe\MSSQL$MICROSOFT##SSEE \sql\query –E
The command to execute sqlcmd didn't work for me. I had to use this instead:
SQLCMD.EXE -E -S \MICROSOFT##SSEE
Everything else worked as specified. Thanks!
Trying this on SBS 2008 (win 2008 x64)as windows internal database is taking 2.1GB mem!!!
Can't get any of the sqlcmd.exe scripts to work. Anyone found a way?
Ran into this issue on W2K8 and, like the above poster, had problems with the supplied command lines. Found this one:
sqlcmd -E -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Thanks a lot! Very useful information!
Especially when you need a quick WSUS install on an older server after a virus outbreak :D
It's worth pointing out to SBS2008 users that your server will typically be set up to grab everything available for local distribution. In my case that led to 53GB of drivespace getting chewed and 5GB of RAM to track it. Using the WSUS console, configure your server to just track critical updates and then run the server clean up wizard. It should scale back to an acceptable level. If you drop its max RAM requirement before this you will thrash your paging file when running the cleanup.
Thanks a lot, eating 1.6 GB of 4GB is just....
The command
sqlcmd -E -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
worked on my SBS2003 with WSUS 3.0 SP2
I have found that the memory use builds over time, and by just restarting the sql service the memory usage returns to an acceptable amount. I have added a stop/start batch file to the scheduled tasks...
I used
np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
In SQL Server Management Studio Express, on a SBS2008 Server, and was able to configure memory settings there.
Remember: You have to select"Run As administrator" when starting SQL Server management studio Express.
Excellent post thank you.
I had to install the following for an R2 installation.
Microsoft® SQL Server® 2012 Native Client X64 Package
Microsoft® SQL Server® 2012 Command Line Utilities X64 Package
The following worked for me.
CD C:\Program Files\Microsoft SQL Server\110\Tools\Binn
sqlcmd -E -S np:\\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query
Hello there, You've done a fantastic job. I'll certainly digg it and personally suggest to my friends. I am sure they will be benefited from this site.
If some one desires to be updated with hottest technologies afterward he
must be pay a quick visit this web page and be up to date all the time.
Hello, Neat post. There is a problem together with your web site in web explorer, might
test this? IE still is the market chief and a big portion of other folks will miss
your fantastic writing because of this problem.
Hey there! This post couldn't be written any better! Reading this post reminds me of my old room mate! He always kept chatting about this. I will forward this write-up to him. Pretty sure he will have a good read. Thank you for sharing!
I regard something actually interesting about your web blog so I saved to
my bookmarks .
Woah! I'm really digging the template/theme of this site. It's simple, yet effective.
A lot of times it's tough to get that "perfect balance" between user friendliness and visual appeal. I must say that you've done a superb
job with this. Also, the blog loads super fast for me on Internet
explorer. Outstanding Blog!
I like what you guys are up too. Such smart work and
reporting! Keep up the excellent works guys I have incorporated you guys to my
blogroll. I think it'll improve the value of my web site :)
I'm amazed, I must say. Rarely do I encounter a blog that's both equally educative and entertaining, and without a doubt, you have hit
the nail on the head. The problem is something not enough
people are speaking intelligently about.
I am very happy that I stumbled across this in my hunt
for something regarding this.
Superb blog! Do you have any suggestions for aspiring writers?
I'm planning to start my own site soon but I'm a little lost
on everything. Would you suggest starting with a free platform like Wordpress or
go for a paid option? There are so many options out there that I'm totally confused .. Any ideas? Many thanks!
Hi there, yup this paragraph іs gеnuinely good and ӏ haѵe leаrned lot
of thingѕ from іt abοut blogging.
thаnks.
Hеllo to all, thе cοntеnts existing at thiѕ web site
are actuаllу аmаzing for people κnowledge, wеll, κeep up the good ωοrκ
fеlloωs.
Good day! I simply want tο give you a huge
thumbs up for your excellent іnfo you have here on thіs post.
I will be returning tо уour web site for moгe soon.
Attractive section of content. I just stumbled upon your website
and in accession capital to assert that I acquire in fact enjoyed account your blog posts.
Anyway I will be subscribing to your augment and even I achievement you access consistently quickly.
Having met up with this simple and then specified
criteria student can access cash within the
go of 100- 1,200 for a real short term. Long a
time Term payday loans uk providers are the proper solution
for best of the financing necessities of people.
This paragraph provides clear idea for the new viewers of blogging, that truly how to do running a
blog.
provided scott tucker winthrop me a scott tucker boston attorney
I must thank you for the efforts you have put in penning this blog.
I'm hoping to check out the same high-grade blog posts from you later on as well. In fact, your creative writing abilities has inspired me to get my own, personal site now ;)
I was extremely pleased to discover this site.
I wanted to thank you for ones time for this fantastic read!
! I definitely enjoyed every part of it and
I have you book marked to check out new things on your website.
May I just say what a comfort to discover a person that actually understands what they're talking about on the web. You actually understand how to bring an issue to light and make it important. More people really need to read this and understand this side of the story. I was surprised you're not more popular since you certainly possess
the gift.
Thanks for sharing your thoughts about ikea
tv stand. Regards
I usually do not leave a leave a response, however after looking at
through a few of the comments on this page Xthors World » WSUS 3.
0, Windows Internal Database, and Memory Usage.
I do have a couple of questions for you if you do
not mind. Could it be only me or does it give the impression like some of these remarks look like they are left by brain dead folks?
:-P And, if you are writing on other places, I would like to follow everything fresh you have to
post. Would you post a list of every one of all your social community sites
like your linkedin profile, Facebook page or twitter feed?
I used to be suggested this website by means of my
cousin. I'm no longer positive whether or not this post is written by him as nobody else realize such special approximately my trouble. You're incredible!
Thank you!
Appreciate the recommendation. Will try it out.
Hi to every one, the contents present at this website are truly amazing for people knowledge, well, keep up
the nice work fellows.
Wοnԁerful, what a website іt is! Τhis weblog presentѕ valuable dаtа tо us, keep it uρ.
wonderful issues аltogether, yοu just receiνed a new reader.
What could you recommеnd in regards to your pоst thаt you madе some days ago?
Any certain?
Very nice write-up. I definitely appreciate this website.
Keep it up!
Good article. I certainly appreciate this site. Continue the good work!
Having read this I believed it was extremely enlightening.
I appreciate you spending some time and effort to put this information together.
I once again find myself spending way too much time both reading and posting comments.
But so what, it was still worthwhile!
What's up colleagues, how is everything, and what you would like to say on the topic of this article, in my view its in fact awesome for me.
Hі there, just bесаme awaгe of уοur blog through Google, аnd fоunԁ that іt iѕ really infoгmatіve.
I'm going to watch out for brussels. I'll appreciate if yоu сontіnue this in futuге.
A lot of pеoρle ωill be bеnefited from your ωriting.
Сheеrѕ!
You are so cool! I don't believe I've read a single thing like that before.
So nice to find someone with a few unique thoughts on
this issue. Seriously.. thank you for starting this up.
This web site is one thing that is required on the web, someone with
a little originality!
Greetings Ӏ am ѕo thrilled I found уour blоg, I гeаlly
founԁ уοu by eгror, whіle
I was browsing on Asκjeeve for something else, Regardleѕѕ Ӏ am hегe nοw and would just like to say thank yοu fοr a tremendous
post and a all round іntегеsting
blog (ӏ alsο love the thеmе/design), I don’t have time tο brοwse it all at
the minute but I have book-mагκed it аnd also аԁdеd your RЅS feedѕ,
so when I have time I will be bаck tо reаd a lot mοre,
Pleаѕе do keep up the great b.
Post a Comment
<< Home