Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
markjack99
Starting Member
3 Posts |
 Posted - 2011-03-02 : 14:30:47
|
| We are developing an application which uses SQL Server 2008 R2 Express Edition. The application reads an index file, processes the lines, and inserts data into the database. On two machines, a particular import process takes 3 minutes - on two other machines, the same process takes 13 minutes. We cannot figure out what is causing the difference.We are running the same application code on all 4 machines (so it is not a code issue).We have tested each machine using a SQL Server instance installed locally on each machine (so it is not a network issue).We changed to have the machines use the same SQL Server instance on a separate server (so it is not a SQL Server version difference issue).Since we are reading a file (4000+ lines), I temporarily stripped out all the SQL statements to see how fast the application was reading and processing the lines in the file (less than 1 second) (so it is not an issue with reading and processing the lines in the file).All machines have the same version native client dll (sqlncli10.dll), which I believe deals with communication to SQL Server.All machines are comparable in processor speed and RAM.It seems to be slow when executing any code which interacts with SQL Server - but only on two machines.Does anyone know what else to check with regard to this interaction?Any help is greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Slow Connection/Interaction to SQL Server