Recommended Drive Size for WID Database

Boopathi S 3,806 Reputation points
2021-10-29T20:25:34.783+00:00

Hello All,

Using SCCM 2010 version. WSUS uses WID to sync from Microsoft to the CAS server. WSUS sycn happens daily for Endpoint Production definition update,
WID data is in C: Drive and it's disk space reduced on every 15 days.
145104-1.jpg

Planned to move the WSUS to different drive as per the below forums.
https://patchmypc.com/how-to-move-the-wsus-content-folder-to-a-new-location
https://techcommunity.microsoft.com/t5/windows-server-essentials-and/how-to-move-wsus-content-and-database-files-to-a-different/ba-p/397186

Please help on the below queries

  1. What is the Microsoft recommendation about the required Drive Space for the WID if it is moved to different drive
  2. How to reduce the size of the SUSDB.mdf and SUSDB_log.ldf. Because it's size is growing on everyday
  3. How does the size of SUSDB.mdf and SUSDB_log.ldf increased
Microsoft Security | Intune | Configuration Manager | Other
Windows for business | Windows Server | User experience | Other
{count} votes

Accepted answer
  1. Garth 5,801 Reputation points
    2021-11-02T10:35:16.33+00:00

    It is not recommend to use wid, instead use the Sql license for your wsus db.
    Since you have a cas and therefore over 150000 devices, you should be contacting your TAM for these type of support questions, as there maybe things that the general admin will not know about your environment that your tam would know.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. Adam J. Marshall 10,356 Reputation points MVP
    2021-10-29T20:45:30.323+00:00

    Are you performing the proper WSUS maintenance including but not limited to running the Server Cleanup Wizard (SCW), declining superseded updates, running the SQL Indexing script, etc.?

    https://www.ajtek.ca/wsus/how-to-setup-manage-and-maintain-wsus-part-8-wsus-server-maintenance/

    Occasionally you'll want to shrink the database, but mine hovers around the 13-15 GB mark with 500MB log file - and my server has 204,347 updates in it's database as it also includes the Drivers category.

    1 person found this answer helpful.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.