Early Versions (SQL Server 2000 – 2008)
ITPro Today logo
Early Versions (SQL Server 2000 – 2008)Controlling MAXDOP of executing queriesControlling MAXDOP of executing queries
Your savior on Enterprise Edition is resource governor in SQL Server 2008. With this you can define different buckets (called workload groups) that connections are dropped into when they connect (or a connection is reset when using connection pooling).
Sign up for the ITPro Today newsletter
Stay on top of the IT universe with commentary, news analysis, how-to's, and tips delivered to your inbox daily.