Menu
I am upsizing an MS Access 2003 app to a SQL Server backend. On my dev machine, SQL Server is local, so the performance is quite good. I want to test the performance with a remote SQL Server so I can account for the effects of network latency when I am redesigning the app. I am expecting that some of the queries that seem fast now will run quite slowly once deployed to production.
How can I slow down (or simulate the speed of a remote) SQL Server without using a virtual machine, or relocating SQL to another computer? Is there some kind of proxy or Windows utility that would do this for me?
594
How to Test Network Latency. Testing network latency can be done by using ping, traceroute, or My TraceRoute (MTR) tool. More comprehensive network performance managers can test and check latency alongside their other features. The importance of measuring and reducing latency cannot be overstated, as maintaining a high-performance ...
In the context of web applications latency is the amount of time needed for an IP packet to travel from the sender to recipient over the network. It could be measured as one-way trip time or back and forth, so-called round-trip time (RTT). We would use the term latency in the meaning of RTT.
This enables any connection speed to be simulated. The latency may also be set to any arbitrary number of milliseconds. The latency delay simulates the latency experienced on slower connections, that is the delay between making a request and the request being received at the other end.
For iOS devices, you can simulate a slow network connection from the Developer Settings. However, you need to install XCode, which means you also need to own a Mac computer. After you install it, you need to connect your device to XCode, and access the Developer Settings on the phone or tablet from the Settings menu.
I have not used it myself, but here's another SO question:
In one of the comments SQL Server has been mentioned explicitly.
136
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
