Monday, March 19, 2012

How many database queries can SQL system support at a time?

How many database queries can SQL system support at a time? The system is a
dual proc with 8 gig of ram. I know that there are a ton of other questions
that should be asked (like DB size and such) but we a looking for an average
number on a typical installation.Hi,
There is no limitations in executing concurrent queries. You could run
optimized queries as much as you can. My server with 8GB RAM (AWE Enabled)
normally allow 9000 concurrent users (every one accessing the database).
Apart from your memory you should good disk controller / Processor
to give good performance.
Thanks
Hari
SQL Server MVP
"OwensZilla" <OwensZilla@.discussions.microsoft.com> wrote in message
news:9814644E-852B-424F-82F0-53B5A4B3C854@.microsoft.com...
> How many database queries can SQL system support at a time? The system is
> a
> dual proc with 8 gig of ram. I know that there are a ton of other
> questions
> that should be asked (like DB size and such) but we a looking for an
> average
> number on a typical installation.

No comments:

Post a Comment