I agree with Tracy. Take the query that the client is complaining about
and create an app that runs that query from a similar workstation (not
from the server) once an hour and log the time it takes.
I had a client where the network and/or server slowed down every 8am,
12pm, and 5pm. Yep, that's when everyone was checking mail, Internet,
etc. Splitting the DB / file server from their mail server, and
improving the network really helped. Didn't really have anything to do
with my application. It just got the blame.
-Kevin
On 04/23/2015 06:36 PM, Sytze de Boer wrote:
I have a client who runs my invoicing/job centre system
He has about 6,000 clients, 15,000 stock items and 500,000 history
transactions
My client is complaining about performance.
I have other clients who have many more clients, stock items and 1.5
million history transactions where performance is not an issue.
I have asked him to upgrade his network switch, cabling, and to make sure
his AV software excludes *my* folder on the Server
(The server is a simple Win 7 pc with an SSD hdd, accessed by 5 users)
He has done so, but still thinks performance is slow
I've logged into his system via Teamviewer and all is quick and snappy
Is there a tool I can run on the workstations to see network performance?
Is there something else I can do to measure/compare the software
performance versus the hardware performance?
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
