Why parallelism on one server and not on the other
Environment versions
SQL Server:
SQL Server 2008
Application:
Web
Miscellaneous
Thread ID:
01596416
Message ID:
01596416
Views:
45
I have the same query on two servers. They are configured the same against the same database with the same set of indexes. All the indexes in regards to the execution plan have been re-indexed. However, one server is showing the execution plan in parallelism mode and the other server not. What is causing this?