2

Microsoft's Windows Server Update Services product (WSUS) makes use of a database, which unfortunately performs very poorly. There is a third-party script available that modifies the database (I believe simply by adding additional indexes) and my experience is that it improves the performance of WSUS by orders of magnitude, but it is no longer available free of charge.

My guess is that any professional DBA could easily improve the performance of the WSUS database, but I'm not sure this is an appropriate place to look for this kind of assistance.

Would asking a question about how to improve the performance of the WSUS database be on-topic on Database Administrators?

(For reference, this is the original Server Fault question I'm trying to help with.)

1 Answer 1

Reset to default
2

To be helpful we would need the table definition(s), query and query plan. Are you sure your license terms allow you to share these details with internet randoms?

Asking if your license allows you to share product details with internet randoms is definitely off topic.

2
  • I figure most Windows DBAs already have access to a WSUS server, so I was vaguely hoping to find someone who had already solved the performance problem at their own site. That may of course be overly optimistic.
    – Harry Johnston
    Sep 21, 2019 at 12:19
  • OK, I think I'll take that as a "no". Thanks.
    – Harry Johnston
    Sep 25, 2019 at 22:52

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .