SQL Server 2012 SP2 Enterprise Edition. Users complaining of slowness. Monitoring tool shows highest wait event is
- MAXDOP: 8
- Cost Threshold for Parallelism: 175
sp_BlitzCache (from the Brent Ozar toolset, those guys rock) for further diagnosis and results show queries with cost under 175 going parallel.
Anyone ever see Cost Threshold for Parallelism being ignored?