Slow Linked Tables on Server 2008

[joshua A. Booker]

Hi There,

We're moving some Access 2003 apps to a new server. The linked tables are
running much slower on the Server 2008 x64 than they do on the other Server
2003 STD.

The apps are all split FE-BE. The BE is on Server 2003 ENT. The FE running
on Server 2003 STD connects with good performance while the same FE on
Server 2008 STD x64 has poor performance. Both FE servers are running
Access 2003 with Jet updates. We've ruled out network issues. I'm thinking
this is an OS thing having to do with 2008 or 64-bit.

Has anyone run into this before? Any ideas of how to narrow this down?

TIA,
Josh

 

[Sylvain Lafontaine]

One possibility here: make sure that the database is not set to autoclose
mode. Second, after upgrading or restoring a database from a previous
version, it's often a good thing to clear all caches and updates the
statistics. Re-indexing might also be a good thing.

For updating the statistics, use the sp_updatestats stored procedure (or use
UPDATE STATISTICS is you want to work on a more detailed level) and for
cleaning the caches after that:

DBCC FLUSHPROCINDB
DBCC DROPCLEANBUFFERS
DBCC FREEPROCCACHE

See
http://sqlknowledge.com/index.php?option=com_content&task=view&id=65&Itemid=41
for more info.

And for reindexing everything, if you still have some problems:
http://blog.sqlauthority.com/2007/0...abase-tables-and-update-statistics-on-tables/

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)

 

[joshua A. Booker]

Sylvian,

I'm really sorry. My post wasn't specific. These are Access 2003 FEs
running via Terminal Services on Windows Server 2008x64 linked to Access
2003 BEs shared on Windows Server 2003 ENT.

We have no problems with SQL Server.

TIA,
Josh

 

[Sylvain Lafontaine]

Well, if you were talking about Windows Server 2008 instead of SQL-Server
2008 then I have no idea about your problem. Sorry.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)