I'm wondering how executing many long-running queries simultaneously will impact SQL Server's ability to service each query in a timely fashion.

[Edit]

It wasn't my intention to be vague, it's more a hypothetical. Let's just assume the queries are select statements with some kind of predicate on tables with millions of rows.

sql-server concurrency
Edit
Report