Debco website is slow / Solomon is slow / SQL CPU is running high.

Issue:

Complaints are coming in that Solomon is slow or not working and the website is slow.

Check:

Check DEBCOSQL CPU percentage. If its running high perform the following:

If the CPU is not running high, this is not the solution for your problem.

Solution

Step 1 - Stop DEBCOWEB in IIS

a. Sign into DEBCOWEB

b. Launch Internet Information Services (IIS)

c. Right click DEBCOWEB

d. Click Stop

Step 2 - Reload Website Catalogue (if you need help with this, Eli, Natasha or Billy are familiar with the process)

a. using ScreenConnect connect to DEBCOSOL which will have an active user session under for 'SolAdmin'

a. Open Solomon

b. Click on Inventory

c. Under Web Site, Launch Web Catalog

d. Click on Re-Load Catalogue

Step 3 - Start DEBCOWEB in IIS

a. Sign into DEBCOWEB

b. Launch Internet Information Services (IIS)

c. Right click DEBCOWEB

d. Click Start