We are upgrading our database server, and I'm running into a weird performance issue.
Our old server is a dual processor system with 8-cores and 4 GB of RAM, running Win2k3 R2 Standard (32 bit), MS SQL Server 2005, and SOLR 4.2 running on Tomcat 7.0.37 all on Java 6u22. We are using MS SQL JDBC 3.0 driver to run DIH to import our records into solr. This import process is taking roughly 4.5 hours.
Our new server is a dual processor system with 16-cores and 32 GB of RAM, running Win2k12 Standard (64 bit), MS SQL Server 2008 R2, and SOLR 4.2 running on Tomcat 7.0.39 all on Java 7u17. I used the same MS SQL JDBC 3.0 driver to run DIH. The import process took over 8 hours.
I am currently running an import test using the MSSQL JDBC 4.0 driver, but if the status is consistent with what I'm seeing now this will also take 7-8 hours.
Can anyone help me figure out this performance anomaly, and help me correct it? Ideally I'd expect to see the import process shorten (the server has more resources so it should), but I'd settle for getting the same speed.