100% on single cpu in SMP host


  • Hi

    Have a host with 16 cpu's, but at any one time, sql server is only using 100% cpu on one of the available 16 rather than sharing amongst all the processors.

    Database resides on san drives and has primary + another filegroup. Do not see this as io bottleneck because of database file structure as its a san environment.

    SQL version is 2008.

    Thanks for any advise on how to resolve this issue

    26 กุมภาพันธ์ 2555 13:16