patternsqlModerate
Does SQL Server execute queries in parallel?
Viewed 0 times
sqlparalleldoesserverqueriesexecute
Problem
Does SQL Server execute queries in parallel?
In other words, if I run a heavy query that takes 10 seconds to execute, and at the same time start another heavy query that takes 10 seconds, will the second query actually start after 10 seconds, or will they start both at the same time?
In other words, if I run a heavy query that takes 10 seconds to execute, and at the same time start another heavy query that takes 10 seconds, will the second query actually start after 10 seconds, or will they start both at the same time?
Solution
You mean "concurrently". The answer is yes, with caveats that are too broad to discuss here.
In fact, the whole point of RDBMS is concurrency.
"Parallel" has a precise meaning in SQL Server: "a single query is distributed over more than one processor core".
In fact, the whole point of RDBMS is concurrency.
"Parallel" has a precise meaning in SQL Server: "a single query is distributed over more than one processor core".
Context
StackExchange Database Administrators Q#13650, answer score: 15
Revisions (0)
No revisions yet.