I’m currently running TPC-C (1000 userload) with MS SQL 2008. The whole mixed transaction testing only took 5 minutes, but the job (including re-loading all the tables) would take more than 3 hours. This is very frustrating.
I ran the same test on an Oracle 11g and it took about 40min. which is less than 1/3 of the time. It’s still a long time, but I can live with that.
As I searched thru the Knowledge Base, there’re some recommendations as:
- Increasing the initial database size.
- Using the SQL Server Native driver.
I’ve tried both of those and it didn’t help either.
Any other advise would be appreciated.