Solved

Accredo saturn database slow login for user

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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

Recently, Microsoft released a best-practice guide for securing Active Directory. It's a whopping 300+ pages long. Those of us tasked with securing our company’s databases and systems would, ideally, have time to devote to learning the ins and outs…
Invest in your employees with these five simple steps to improve employee engagement and retention.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …

717 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