SQL index

Question

I have 1 primary & 2 SUP servers.

Wsuspool & distribution point pool is getting stopped repeatedly.

Wcm.log
Remote connection failed with exception ‘system.net.webexception: the underlying connection was closed: an unexpected error occurred on a receive.

Also on SQL box – in component status we see error in reporting point, sms_mp, component server.

While opening wsus it’s giving reset node error.

Restarted wsus services. Tried increasing private limit for wsuspool.

Any suggestions on this. Also can you help with SQL reindex part.

 

 

 

 

Answer ( 1 )

  1. Without more details, we won’t be much of help here.

    For SQL reindexing my recommendation trying OLA method https://stevethompsonmvp.wordpress.com/2016/11/29/optimizing-sccm-databases-revisited/

Leave an answer

Sorry, you do not have permission to answer to this question .