• Regarding the waits, SQL server performance dashboard shows below (taken at 11:20 today)

    Wait Category..................Number of Waits..........Wait Time (sec)..........% Wait Time

    Parallelism...........................724065872.................6319246.421...............28.06%

    Other................................1232197629................5075559.493...............22.54%

    Sleep.................................425224734..................4091093.732...............18.17%

    Latch................................1642991523.................3378139.014...............15.00%

    Buffer IO............................148173427...................2212876.593..............9.83%

    I am not sure whether that seems good bad or normal! Apologies for the dots....