Home
.. About WSUS Wiki

RSS

WSUS
.. WSUS FAQ
.. WSUS on SBS
.. WSUS Troubleshooting
.. WSUS News Groups
.. Known WSUS Issues
.. WSUS Links
.. WSUS Wish List

WSUS Documents
.. WSUS Deployment Guide
.. WSUS Installation Guide
.. WSUS Release Notes
.. WSUS Best Practice

SUS
.. SUS FAQ
.. What Is SUS
.. SUS Troubleshooting
.. SUS Links
.. SUS Known Issues
.. SUS FAQ
.. What Is SUS
.. SUS Troubleshooting
.. SUS Links
.. SUS Known Issues

Wiki Community
.. Wiki Contributors
.. I Love WSUS
.. WSUS Wiki Diary
.. Wiki Statistics
.. To Do Page

Miscellaneous Stuff
.. Other Resources
.. Do You Know?


Site Meter


Terms of Use
Trademarks
Privacy Statement

 

SQL Server App Compat Best Practices


You can use an existing SQL server to host the database of WSUS. However here are some thigns that you should be aware of:

Benefits:

  • A single backup process and tools can take care of all the databases in the SQL server including the WSUS database.
  • Patching one SQL server is easier to keep track of than multiple SQL servers on multiple machines.
  • You can consolidate your SQL server onto a single beefy machine.

Concerns:

  • During Synchronization WSUS generates a heavy load on the SQL server. If the other applications using SQL server are sensitive to SQL server being under heavy load then you can run into problems.

    Workaround: You can schedule the WSUS synchronization job for a time that SQL server is under least amount of load.


Last Modified 3/21/05 4:50 PM

Hide Tools