Solved

Accredo saturn database slow login for user

Posted on 2014-09-23
5
237 Views
Last Modified: 2015-01-13
We have a company that has a financial App called Accredo Saturn , Its an install on the fileserver
What it uses are Database files called "PDB" and  "PNX"   Users connect to this via an exe on their local laptops/desktops win7 .

everytime a particular user (user A) logs in 1st other people are having slowness issues
Running wireshark
there are Lock requests going to the fileserver where the files are hosted but no Oplocks
Server = Server 2012
Workstations win7

I have done a lot of investigation on this and troubleshooting even seen some readups on this similar to FOX pro DB`s
What we have done was to try and patch the server with http://support.microsoft.com/kb/2957623  
1.      Remove redundant entries from your PATH statement, specifically any drive mappings that may no longer exist.
**If there were Mappings at a stage that changed or could still be mapped for Sue can we check to tidy it up
2.      Finally, and most productive for me, disable Interrupt Moderation in the advanced settings of your network card.
Reinstalled the particular App to a different Directory

Even Contemplating turning off SMB2
http://www.dataaccess.com/whitepapers/opportunlockingreadcaching.html

any HELP would be appreciated
0
Comment
Question by:JakesC
  • 4
5 Comments
 
LVL 78

Expert Comment

by:David Johnson, CD, MVP
ID: 40342705
are you saying that as long as user1 is not using the software, user2 and user3 have no problems accessing the software?  but when user1 logs in user2 and user3 suffer slowdowns?  Does it use a SQL database or a flatfile database?
0
 

Author Comment

by:JakesC
ID: 40342760
Hi there

1. Correct: RE user scenario
2. They are using a Flatfile database not SQL
0
 

Author Comment

by:JakesC
ID: 40369392
May I ask if there are any help out there ? Please ..
0
 

Accepted Solution

by:
JakesC earned 0 total points
ID: 40539387
Please note , we build a separate server for this instance , and all is working fine
0
 

Author Closing Comment

by:JakesC
ID: 40546204
Work-around  build a separate server
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

I use more than 1 computer in my office for various reasons. Multiple keyboards and mice take up more than just extra space, they make working a little more complicated. Using one mouse and keyboard for all of my computers makes life easier. This co…
Never store passwords in plain text or just their hash: it seems a no-brainier, but there are still plenty of people doing that. I present the why and how on this subject, offering my own real life solution that you can implement right away, bringin…
This video walks the viewer through the process of creating envelopes and labels, with multiple names and addresses. Navigate to the “Start Mail Merge” button in the Mailings tab: Follow the step-by-step process until asked to find the address doc…
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …

757 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now