• If multiple processors being used by your system's workload is a problem, it might be indicative of badly written queries and/or missing indexes.

    On the other hand, if your system functions mainly as an OLAP/reporting environment, then parallel processing might actually be of benefit.

    __________________________________________________________________________________
    SQL Server 2016 Columnstore Index Enhancements - System Views for Disk-Based Tables[/url]
    Persisting SQL Server Index-Usage Statistics with MERGE[/url]
    Turbocharge Your Database Maintenance With Service Broker: Part 2[/url]