The question you're asking is also largely going to be determined by things other than SQL Server. What kind of disks and controllers are we talking about? How much memory does the system have? Then we need to focus on the data. 10 million rows, fine. How many columns of what kind of data? Joining tables, what indexes do we have in place? Without all that information, saying "This performance is good" is really hard.