I am just wondering what would the best computer specifications for running a perfect transactional replication. The database would have around 50 transactions per second.
Pentium 4 2.4GHz Dual Processor
2 GB RAM ECC
33.6 GB HDD X 5 @. 10,000 RPM
Windows Server 2003
Anyone with any suggestions or maybe I left out some settings to configure?
Thanking you people in advance.
In article <ECB8346D-41BB-422D-BB04-0FD41E3F12A1@.microsoft.com>, "=?Utf-8?B?Q1c=?=" <anonymous@.discussions.microsoft.com> wrote:
>I am just wondering what would the best computer specifications for running a
> perfect transactional replication. The database would have around 50
> transactions per second.
>Pentium 4 2.4GHz Dual Processor
>2 GB RAM ECC
>33.6 GB HDD X 5 @. 10,000 RPM
>Windows Server 2003
>Anyone with any suggestions or maybe I left out some settings to configure?
>Thanking you people in advance.
Across what connection?
WAN? 10Mbps? 1000Mbps?
How large are the transactions?
How many table do they affect?
How well normalised is the data?
Are these inserts, updates, or deletes?
|||In a LAN environment, across 100Mbps.
It has about 50 transactions per second.
It affects about 15 tables, about 5 are heavy ones. These five are constantly updated.
It has reached third-normalised form.
It has all three types of inserts, updates and deletes operations.
Thank you.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment