SQL Server should have no problem serving hundreds to thousands of queries per second unless the query is really pathological (which it might be!).