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

    • Grab Motorola's Razr Ultra 2025 at 15% off and ditch your slab phone by Paul Hill Motorola is currently selling the Razr Ultra 2025 on Amazon at a discount of 15%, meaning you can pick it up now for $1,099.99 instead of the usual $1,299.99. This is a notable saving on a premium foldable smartphone, but it still remains a high-end purchase. Any Prime members out there can get free overnight delivery and if you have an old device to trade in, then you can get up to $725 in Amazon.com Gift Card credit that you can use towards your upgrade. One of the main perks of this device is that it’s universally unlocked, meaning you can use it on all major US carriers. It’s powered by the Snapdragon 8 Elite and comes with 16GB RAM and 512GB storage. With these specs, this device should be able to run any apps you throw at it. The Pantone Scarab color, a soft, velvety suede-like texture, is the result of a collaboration with the Italian brand Alcantara, known for its premium materials, giving the phone a very unique look. As a flip phone, you also get an intelligent and interactive external display that lets you access apps without opening your phone. Even with this external display, Motorola says you can expect over 36 hours of battery life and when you do need to recharge, you have fast charging. The main display on this device is 7 inches and features a Super HD resolution which is 2992 x 1224, the refresh rate is 165Hz. The external display has a resolution of 1272 x 1080. This phone could be a good pick for fashion-conscious users with its unique materials. It’s also a great device for anyone after a compact form factor or who is a fan of Motorola devices. The style, compact design, external display, fast performance, and improved camera system (50MP) are all positives on this device. There’s also IP48 rating for dust and water protection, adding durability. Motorola Razr Ultra 2025: $1,099.99 (Amazon US) / MSRP $1,299.99 This Amazon deal is US-specific and not available in other regions unless specified. If you don't like it or want to look at more options, check out the Amazon US deals page here. Get Prime (SNAP), Prime Video, Audible Plus or Kindle / Music Unlimited. Free for 30 days. As an Amazon Associate, we earn from qualifying purchases.
    • Lots of people want a world where everything is personal and nothing is ever discussed rationally. List me as one of the people who doesn't think that's a good approach.
    • I think it's great that we're learning more about the early universe through observation. Knowing that our assumptions were off is a good thing. Once space based gravitational wave detectors exist, we may be able to "see" into the period where the universe was still condensed before matter formed. That'll be cool
    • yeah, the "but X had it first" comments rarely add any value. Sometimes it is interesting that a feature gap for a seemingly simple feature can last for years or decades, but in this case, it is such a minor feature that I doubt anyone really cared.
  • Recent Achievements

    • One Month Later
      BA the Curmudgeon earned a badge
      One Month Later
    • First Post
      Doreen768 earned a badge
      First Post
    • One Month Later
      James_kobe earned a badge
      One Month Later
    • Week One Done
      James_kobe earned a badge
      Week One Done
    • Week One Done
      macomen earned a badge
      Week One Done
  • Popular Contributors

    1. 1
      +primortal
      654
    2. 2
      ATLien_0
      253
    3. 3
      Xenon
      168
    4. 4
      neufuse
      147
    5. 5
      +FloatingFatMan
      128
  • Tell a friend

    Love Neowin? Tell a friend!