Solved

Accredo saturn database slow login for user

Posted on 2014-09-23
5
248 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
[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
  • 4
5 Comments
 
LVL 81

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

All of the resources available today make learning a new digital media easier than ever-- if you know where to begin. This is a clear, simple guide to a few of the basic digital art mediums and how to begin learning them on your own.
There are many software programs on offer that will claim to magically speed up your computer. The best advice I can give you is to avoid them like the plague, because they will often cause far more problems than they solve. Try some of these "do it…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

738 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