<div>
Well I would agree but saving from satellite office to the server not by the application is instant not lag
</div>


Well I would agree but saving from satellite office to the server not by the application is instant not lag

<div>
<div class="content wysiwyg-content">
Ok so satellite office connect to main office via 100mbs fibre line <br />
<br />
SQL 2012 box at main office runs our practice management system called ALB by a company One-advance.<br />
<br />
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?<br />
<br />
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<br />
<br />
I am at a lost as to where to start or what to suggest <br />
<br />
Is this an SQL issue or network or application?
</div>
</div>


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?

Document slow saving to SQL server

Windows Server 2012 is the server version of Windows 8 and the successor to Windows Server 2008 R2. Windows Server 2012 is the first version of Windows Server to have no support for Itanium-based computers since Windows NT 4.0. Windows Server 2012, now in its second release (Windows Server 2012 Release 2) includes Foundation, Essentials, Standard and Datacenter, and does not support IA-32 or IA-64 processors.

Windows Server 2012

Network analysis is the process of identifying and remediating the processes and systems within a network, including performance, connectivity and security. The process is performed through the use of tools developed for monitoring and analyzing network activity. Network problems that involve finding an optimal way of doing something are studied under the name combinatorial optimization. Examples include network flow, shortest path problem, transport problem, transshipment problem, location problem, matching problem, assignment problem, packing problem, routing problem, Critical Path Analysis and PERT (Program Evaluation & Review Technique).

Network Analysis

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.