OS: Windows 2008
SQL: SQL 2008 Standard
We're building a SQL database that records transactions for reporting. The transactions are submitted to a SOAP interface from a variety of external systems which are in turn dumped into the database. The database then runs a variety of statistical analysis routines to produce management reports. This system is expected to handle 1,000,000 tp 5,000,000 transactions daily.
We're getting ready to order to production servers for the system and are wondering if SQL performs better on one Intel processor vs. the other. Example: Intel Xeon, AMD Opetron, etc.
Any comments are appreciated.