Solved

Accredo saturn database slow login for user

Posted on 2014-09-23
5
244 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 79

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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
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…

823 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