WSUS DB instance taking up too much RAM...


Recommended Posts

I just implemented WSUS at one of my clients, and the RAM usage of the SQL db instance is way too high.

Does anyone have experience adjusting the amount of RAM a DB can use?

I'm familiar with Enterprise Manager; unfortunately this client doesn't have Enterprise Manager available.

Any help is appreciated.

Thanks,

Matt

[edit]

Found this: http://msmvps.com/blogs/bradley/archive/20...-more-time.aspx

And this: http://msmvps.com/blogs/bradley/archive/20...that-matter.asp which makes the process easier.

After getting an access error, and performing this, I still get an access error; neither sqlcmd, osql or the GUI allow access.

Edited by brand
  bobbba said:
what versions of wsus and SQL?

SQL 2000 and MSDE ram consumption can be configured from SQL enterprise manager

SQL 2005 inc express edition have SQL Server Management Studio Express

I found this, but cannot connect to the databse.

After attempting to use SQL Server Management Studio Express to connect, I even tried osql and sqlcmd with no luck.

Any help is appreciated!

Thanks,

Matt

I assume by the fact you are running SQL Server Managment Studio that you are using SQL Server 2005.

I think you have more than 1 problem if you cant connect to your SQL Server. Try rebotting the sql server then try and login to it again.

Do you have remote desktop / physical access to the sql server. Login to Machien as an Administrator. Run the Managment Studio app, and attempt to login.

  Ryath said:
I assume by the fact you are running SQL Server Managment Studio that you are using SQL Server 2005.

I think you have more than 1 problem if you cant connect to your SQL Server. Try rebotting the sql server then try and login to it again.

Do you have remote desktop / physical access to the sql server. Login to Machien as an Administrator. Run the Managment Studio app, and attempt to login.

bobbba: Sorry for not including the WSUS version. I'm 3.0.

The SQL version is 2005 Embedded, which comes free with WSUS.

I can not reboot the server, and rebooting the server will not help.

The real question is, has anyone ever connected to the "Windows Internal Database," aka MICROSOFT##SSEE, before? If so, what are the credentials needed? The NT Auth\Network System user is running the sqlservr.exe instance, and local Administrators has full control to the ldf/mdf that is the database.

As you can see I'm kind of stuck, and, albeit not massively critical; it would be worth gaining access.

Edited by brand
This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Posts

    • That'll be it for my 2018 Mac mini then. There is, of course, OpenCore Legacy Patcher . . .
    • Support cost cutting and nudging people to upgrade for profit. Pure and simple. Nothing as noble as hardware actually becoming "obsolete" about most of the hardware requirements from Apple, Microsoft, or Android companies either. iMac 2017 with AMD running legacy Core still have native GPU support in macOS 15 and run perfectly fine. Doesn't even need any fancy patching outside of the minimum patching needed to get macOS 15 on the system to bypass Apple system requirements aking to running windows 11 on a PC that doesn't match the arbitrary CPU generation requirements that make you bypass them too. You can usually tell if hardware is truly in the realm of "obsolete" if you are having a hard time finding a major Linux distro that'll install on it.
    • >Mozilla's Firefox has been left behind over time in terms of market share, as it has not been able to keep up with Chromium-based browsers in the performance department. I have no problems with Firefox's performance whatsoever. I suspect the reason Firefox is lagging in market share is that average consumers haven't heard of it and are fine with what was installed on their systems.
    • The Expanse: Osiris Reborn is a new narrative-driven sci-fi RPG inspired by Mass Effect by Pulasthi Ariyasinghe Out of nowhere, a narrative-driven sci-fi action RPG has been announced that will take players into the universe of The Expanse TV show and novels. The reveal trailer landed today during the Future Games Showcase, offering both a cinematic look at the setting as well as snippets of gameplay. Check out the The Expanse: Osiris Reborn debut trailer above. The studio behind the project is Owlcat Games. Some may remember that name from being involved in the role-playing titles Pathfinder: Kingmaker, Pathfinder: Wrath of the Righteous, as well as the most recent hugely well-received RPG Warhammer 40,000: Rogue Trader. Now, the studio's sights are set on The Expanse universe, and it's going for the over-the-shoulder third-person gameplay route for the first time. “We’ve been dreaming about building a sci-fi action RPG of this scale for a long time, and The Expanse is the perfect universe to bring that vision to life,” says Owlcat’s Creative Director, Alexander Mishulin. “It’s a world grounded in realism and complexity, perfect for telling a story the way we like it— mature and character-driven, where your choices truly matter." The story will have players taking the role of a custom captain that can be from the Earth, Mars, or the Belt to take control of the most advanced ship currently available. There's a crew to meet and lead, tactical third-person combat, and, as expected from this franchise, a divided solar system to navigate and make decisions on. The studio was also very direct about this experience being inspired by BioWare's Mass Effect trilogy. Aside from the action-heavy gameplay seen in the trailer, Owlcat is promising plenty of political intrigue, as well as romance options for players to dive into. Game Design Producer Yuliya Chernenko added "many of us first played it in our teenage years, and it left a lasting impression," and that "we are building on that legacy and expanding what players anticipate from this experience." The Expanse: Osiris Reborn does not have a release window just yet, but it will be coming out on PC (Steam, Epic Games Store, GOG), Xbox Series X|S, and PlayStation 5.
    • I don't know of anyway other than winareo tweaker to set the font type in Win11. They took that option away!   No wonder people are staying with Win10, or 7.   It's not our computer with Win11.... it's theirs!
  • Recent Achievements

    • Conversation Starter
      Naomi723 earned a badge
      Conversation Starter
    • Week One Done
      abortretryfail earned a badge
      Week One Done
    • First Post
      Mr bot earned a badge
      First Post
    • First Post
      Bkl211 earned a badge
      First Post
    • One Year In
      Mido gaber earned a badge
      One Year In
  • Popular Contributors

    1. 1
      +primortal
      486
    2. 2
      +FloatingFatMan
      256
    3. 3
      snowy owl
      243
    4. 4
      ATLien_0
      222
    5. 5
      +Edouard
      191
  • Tell a friend

    Love Neowin? Tell a friend!