04-11-2017 04:31 PM - edited 04-11-2017 04:31 PM
Now we have decided to grant access to some users in department. But the question is how many users would be able to connect to application at the same time without having bottleneck. On the other words how much sever can tolerate while user load increase?
I am Also wondering if the way that I coded my stored process will affect the perforemance.
Thank you in advance!
04-11-2017 04:42 PM
How much your server can handle is entirely dependent upon its specifications and difficult for us to answer. Also network speeds and other infra components will determine the user experience.
We use automated testing tools to create a predetermined work load and measure/observer the server peformance and browser response times. There are many of these products available. They take the guess work out of the task and prevent you from having to gather a large group of people to manually create a workload, from simple to complicated/advanced, from free (as in beer) to expensive. JMeter comes to mind.
In order to match the workload you can load balance your STP servers across multiple servers if need be. So you can scale out as well as up. Do keep the terms of your SAS license in mind.
Hope this helps,
04-11-2017 05:03 PM
04-11-2017 05:15 PM