asked on

MS Access 2010 / MSSQL 2012 connection painfully slow

I took an old database of mine (Backend = MSSQL 2005 / Front End = MS Access 2003 MDB file), and transferred a Dell Inspiron laptop intended for demonstration purposes. The laptop is running MSSQL 2012 SP1 (the Business Intelligence version) and MS Access 2010. It works, but it is SLOW.

Form renders on the production version of the database (which runs on MSSQL 2008 standard with Access 2007 and 2010 clients) are close to instantaneous.

Here, on the Dell Inspiron, they take 5 to 10 seconds. Reports are similarly slow.

While the Dell Inspiron, aint exactly a screaming fast machine. I've seen this database run far faster on far slower & older machines. CPU, memory, and I/O all looked reasonable when I was running the database.

The one new factor on this machine is Dell is MSSQL 2012 SP1. I'm inclined to think the slowness is associated with MSSQL 2012 either directly or indirectly.

Is running an old MSSQL 2005 database on a MSSQL 2012 server a problem?

Is it the ODBC connection between the Access file and the MSSQL 2012 server. Is MSSQL 2012 geared for OLE DB rather than ODBC?

Is Access 2010 struggling to connect an old 2003 MDB file with MSSQL 2012?

I ran out of the time with the machine and didn't check the SQL Server Error Log or the Windows Event Log. I should have.

I did a quick web search. I found some other folks with similar issues:
http://dba.stackexchange.com/questions/35579/sql-server-2012-slower-than-2008
http://stackoverflow.com/questions/10926841/sql-server-2012-slower-than-2005
http://forums.asp.net/t/1796853.aspx