Service · IT infrastructure

Performance tuning

Consider a twelve-person accounting firm in Kadıköy during tax return week. A client file needs ten seconds to open, e-Ledger uploads get stuck after lunch and the shared drive seizes up close to 11:00 every day. In the weekly meeting a partner suggests ordering a new server. Before anyone signs a purchase order, it pays to ask where the seconds are really disappearing. Frequently the explanation is almost comically ordinary. The accounting database has reached the 10 GB cap built into the free edition of Microsoft SQL Server. The antivirus rereads enormous files every time an entry is saved. A kinked network lead has quietly fallen back to 100 Mbit/s. We capture data during your busiest hours, find the choke point and resolve it without anyone visiting. New equipment is only discussed after every no-cost adjustment has been exhausted, and only with numbers proving the gain. We have no hardware to sell, so there is no incentive for us to recommend a bigger box.

Timestamps
instead of “it is just slow”
Free fixes first
purchases come last
Proven gains
seconds saved, shown on paper
Independent
no kit on our price list

What the work covers in practice

Slowness is investigated layer by layer, from the screen in front of the user down to the tables in the database. Each layer fails in typical ways, and the data soon tells us which one is guilty.

Agree the scope with the engineer who will do the work

The workstation

Patching and security scans that all kick in at boot, profiles that have swollen over the years, clutter running in the background, disks with no free space. Machines that are painful at 09:00 but fine by noon usually point here.

Cables, switches and wireless

Ports stuck at the wrong speed, damaged leads throwing errors, access points with far too many clients, and document traffic between branches that should never leave the building.

Hosts and hypervisors

Physical servers asked to carry too many virtual machines, databases starved of RAM, and backup or reporting jobs scheduled for 10:30 on a working day.

The database engine

Express edition limits on size, RAM and cores, indexes that are missing or fragmented, maintenance tasks never scheduled, a client upgrade out of step with the server. For Logo, Mikro or Netsis users, the biggest wins usually come from here.

Remote and branch users

VPN tunnels over thin home broadband, badly tuned packet sizes and desktop applications talking to a database hundreds of kilometres away. Often it is better to keep the program next to its data and stream just the screen.

Your shop front

Slow first byte from the hosting, heavy images, plugins hammering the database on every page view, and marketplace stock jobs colliding with the lunchtime order rush.

How we approach the job, from first call to handover

Expect the investigation to take a week or two. Fixes go in step by step, mostly after hours, so the office keeps working.

01

Symptom diary

For one week staff jot down, in a short online form, what stalled and at what time. Those precise moments are far more useful than general frustration.

02

Reference timings

We stopwatch everyday actions like pulling up a client ledger, producing a trial balance or opening a product page, and a monitoring agent captures server and network behaviour at the same moments.

03

Matching cause to symptom

The diary and the graphs are overlaid. What comes out is a ranked set of causes backed by evidence, and advice on where to begin.

04

Change, then prove it

Once you approve, we apply the changes remotely and repeat every timing. Four weeks on, a second round confirms the improvement has stuck.

SQL Server Express hits a wall without warning. Many accounting and ERP products ship with the free Express edition. It limits each database to 10 GB and restricts how much memory and processing power it may use. As the company grows, the database drifts towards that wall, and the software gets slower or stops accepting new records no matter how fast the server is. Looking up the database size and edition takes about ten minutes and can save you from buying hardware that would not have helped.

Frequently asked questions

The graphs decide. A server sitting almost idle while users complain will not be rescued by new hardware; the fault is in configuration, the database or the network. RAM that stays maxed out all day, on the other hand, may be solved most cheaply by adding memory. You see the evidence either way.

Occasionally they are right, more often only in part. We contact their support with timed measurements so the discussion rests on facts. Code changes are theirs to make; we look after everything underneath the application.

Very often, yes. We examine the VPN, packet sizing, the home broadband and whether documents that should sit in the office or SharePoint are travelling back and forth. Equipment and expense arrangements for remote staff go into the written remote working agreement; we supply the technical input.

We can help there too: Core Web Vitals and time to first byte are measured, caching, image handling and extensions are reviewed, and you learn what your present hosting is capable of. A move to another provider is only recommended when the data supports it.

Investigation runs at €55 per hour plus VAT, estimated beforehand, and we never promise a percentage improvement before measuring. If fresh hardware is justified, you get a written specification and are free to buy anywhere. A local supplier or your own staff fit it, and we migrate everything remotely.

Tell us what is dragging

Pick one concrete action that wastes your team's time and say how long it currently takes. By the next working day we will explain where our measurements would begin.

Availability
Weekdays 09:00-18:00 Turkey time (GMT+3); an answer follows by the next working day
Calls
By video, over Microsoft Teams or Google Meet

The only cookies here are the essential ones: they keep the site running and remember the city you picked. Nothing is used for advertising or tracking. See our privacy notice for more.