Solved

Accredo saturn database slow login for user

Posted on 2014-09-23
5
246 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 80

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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

Suggested Solutions

Healthcare organizations in the United States must adhere to the guidance of both the HIPAA (Health Insurance Portability and Accountability Act) and HITECH (Health Information Technology for Economic and Clinical Health Act) for securing and protec…
Shadow IT is coming out of the shadows as more businesses are choosing cloud-based applications. It is now a multi-cloud world for most organizations. Simultaneously, most businesses have yet to consolidate with one cloud provider or define an offic…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Viewers will learn how to use the Hootsuite Dashboard.

820 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