We have a packingstation with a weight (Windows-based touchscreen) which sends data to a SQL Anywhere 12 database. From time to time the users complain that the process of storing data is slow, and it halts the production. The actual insert-statment is executed in a stored procedure which is called in our software on the weight. The weight and the database is in separate networks (different subnets), but on the same physical network. This is unfortunately how the IT-department wants it.
Is there any tool, command or similar available to measure how much time the server uses to complete the task. That being to measure the time it takes from the call to the stored procedure is sent from our software until the row is stored in the database. We would like to prove (hopefully) that our software is not the problem, so the IT-department at our customers location can look into their infrastructure instead.
Bjarne Anker Maritech Systems As Norway
asked 30 Sep '15, 09:18