• SQLJay (7/2/2015)


    We have a 2 physical CPUs that are 4 cores each with hyper threading enabled. When looking through the task manager, under the performance tab, I see 16 CPU threads.

    Don't use Task Manager to monitor SQL Server.

    That said, yes, you'll see 16 threads there. That's the 16 schedulers that SQL Server has created, one for each of the cores, 8 physical and 8 from hyperthreading. This has nothing to do with MAXDOP, which is the number of concurrently running threads a query may have.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass