how much time to set up replication

Does anyone know how much time (approximate) I should allocate to set up
Transactional Replication on a SQL database that is 20 gig in size?
Your question is a bit vague. What specifically do you mean by "setup"? Just
the configurations? The initial snapshot and population? Also how fast are
the boxes?
"Patrick K" <PatrickK@.discussions.microsoft.com> wrote in message
news:A254BEB1-FE2A-4C65-8466-55696C37E2A4@.microsoft.com...
> Does anyone know how much time (approximate) I should allocate to set up
> Transactional Replication on a SQL database that is 20 gig in size?
>

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.

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.

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.