Ok so satellite office connect to main office via 100mbs fibre line
SQL 2012 box at main office runs our practice management system called ALB by a company One-advance.
Clients connects directly onto the SQL server which basically stores client information and is used to produce documents. It can take up to 40secs to save a simple word doc via the application. Is this normal?
I’ve used performance counters on the SQL box and disc access seems fine - if I perform same action on same LAN as server it also fine and fine if accessed via RDS
I am at a lost as to where to start or what to suggest
Is this an SQL issue or network or application?