Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Access database on server 2008 r2 x68

Posted on 2013-02-05
5
Medium Priority
?
391 Views
Last Modified: 2013-05-15
Morning

we have a client who was running an old bespoke access (2000 – 2003) database on SBS 2003 which runs their optometrists software. They were complaining of performance issues so we recommended upgrading the server.

we talked to the tech of the access database authors who gave us a couple of changes to be made during the migration, and that was it.

we migrated the sbs2003 server to sbs2011 (server 2008 R2 x64) over a weekend and immediately hit performance issues with the access database.

Their tech indicated that it might be a SMB 2.0 issue so we disabled SMB 2.0 on the server, and while that did help, and allowed the database to at least run the performance is well below that of the previous server, over 10x slower.

Found a thread on Microsoft forums that indicates that it’s a problem, and that unless you upgrade the access 2010 (which they aren’t going to do) there no fix.

http://social.technet.microsoft.com/Forums/en/officeitpro/thread/3aac9bc7-51db-4ff6-b8c5-e85faaae6b38

I’d be grateful for any tips, tricks or solutions.

We’re preparing to re-instate the 2003 to put the access on, while wiping the egg from our faces.

Thanks – Murray
0
Comment
Question by:t2s
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 58
ID: 38855838
Murray,

  Problem is, there doesn't seem to be any real "fix".  Some have had issues with SMB 2.0.  Some with IPv6. Some with NIC settings.   But it doesn't seem to be any one specific thing.

 However one thing you can try is setting maxbuffers to the highest possible value at app startup:

dbEngine.SetOption "MaxBuffers", 65535

and see if that helps with the performance issue.

 Also, is it performance in general, just when starting up, etc?

 And were any other changes made at the same time as the server?

Jim.
0
 

Author Comment

by:t2s
ID: 38859788
Thanks jim i'll try that.

in reply, it's a straight, new installation of SBS 2011 - no other chnages made at installation - i'm a one thing at a time guy.

Murray
0
 

Accepted Solution

by:
t2s earned 0 total points
ID: 39155318
Finally re-cut the old server and put a less up to date OS on it - works fine.

there's something about Windows 2008 R2 x64 and Access but i still havnt been able to identify what it is - so i've avoided it.
0
 
LVL 58
ID: 39155402
Did you try the maxbuffers setting?  One thing known for sure that under a 64 bit OS on a multi-core CPU, JET has a problem with it's cache cleanup process.   A2010 had a hot fix come out to address that.

 Setting maxbuffers to it's maximum setting in some cases does work to get around that.

Jim.
0
 

Author Closing Comment

by:t2s
ID: 39167394
There has been no real solution - this is just a work around.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question