Slow DB Access on Server2008

[spazman]

I migrated a large amount of data over the weekend to a new much faster server.

Everything is fine except for an Access DB (MDE)
They can open the applications but it is very slow.

If I repopen from the original location its fine. So it has to be the server.

OpLocks was NOT disabled on the old server 2003, nor is it on the SBS 08 box.

 

[MrDataGuy]

Just as a sanity check have you tried copying a simple large file (Say a simple text file) to/from the new server to a work station and comparing it to the times via the old server?

There could be a significant difference that has nothing to do with Access.

Of course your posting said "Everything is fine except for an Access DB" so maybe you already have confirmation that it is the database it self.

(I'm not enough of an Access expert to make a better suggestion.)




Lion Crest Software Services
Anthony L. Testi
President

http://www.LionCrestSoftwareServices.com

 

[spazman]

I transfered a 223 MB file form the new server 3 miniutes, from the old serve less than a minute.

I used PRocess Explorer and fond a tonne of "NO SUCH FILE" and "NO MORE FILES" for the ldb for the access DB. Which doesn't seem to be any help.

more background; the new server is an SBS server. I created a NetBIOS allias to the SBS server to answer to the name of the old server. using this article

http://mystyleit.com/blogs/mystylei...ng-a-unc-alias-for-a-windows-2003-server.aspx

The old server was removed form AD and renamed to servernmae-old. This same behavior wether the server is on or off

 

[MrDataGuy]

Well with a 300%+ slowdown just in copying a file it looks like there is some issue with the server or network. I'm not a server or network man myself so I guessing here.

Check the routers and switches etc. Once I found a client put a server on a 10 mbyte (mbit??) segment when the rest of the network was 100-1000 mbyte.

Do you have any way to monitor the network speeds from the server?

Anyhow again I am just throwing out guesses, hopefully someone will respone with a more intellegent answer soon for you.

Lion Crest Software Services
Anthony L. Testi
President

http://www.LionCrestSoftwareServices.com

 

[spazman]

WS is 100mb, old and new servers on same switches/routers, boith 1Gb.

 

[MrDataGuy]

Same OS? on the two servers?

Double check the harddrives? e.g. could the old one be running at 10,000 rpm and the new one at 5,400 or something? Also try sending the test file to another computer (A another server would be best of you have it) to verify the transfer speed issues. Oh what about testing moving a file back from each of the servers?

Lion Crest Software Services
Anthony L. Testi
President

http://www.LionCrestSoftwareServices.com

 

[boblarson]

Also, did the Server Role for file server get set up properly? I am using Windows Server 2008 at home and found that there are a multitude of settings for tweaking the File Server role.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[jsteph]

spazman,
I've gone through similar issues, it's almost always a network config thing.
One time the problem was that the server had two nics, and they were colliding with each other creating like a mini-storm.

Another time it was just upgrading the nic's driver.
Yet another it was downgrading the nic's driver.

And one time it was the configuration either had full-duplex but shouldn't have, or vice/versa.

Either way, when you've got that slow performance moving a file I'd look at the server's nic configuration.
--Jim