I am experiencing a big difference in .Net application memory usage using the same app against two copies of the same database. The only difference is that in scenario 1 I am using a local copy of the database registered to an instance of SQL Server 2005 Express
- and in scenario 2 I am using a remote copy of the database registered to an instance of SQL Server 2008 Enterprise
.
To my knowledge, I would only expect a difference in the SQL performance and SQL memory usage (since Express has a 1GB limit).
But - what I see is an enormous difference (1GB) of memory usage between them - i.e. the SQL Express
scenario using 1GB more of memory mostly. SQL Express
also seems to be much slower particularly working with big tables and large queries - but I would expect this memory hit to be in SQL and not on my consuming/client application???
The app connects to SQL server using System.Data.SqlClient.SqlConnection
and carries out frequent SqlCommand
and SqlBulkCopy
operations.
Any helpful thoughts would be very much appreciated!