performence between application server and database server
Hi to all,
Any one of u, pls tell me the process of finding out the performence between application server and database server using loadrunner
Re: performence between application server and database server
When you speak of application server versus database server, in many cases you are speaking traditional client server computing and the difference between two and three tier architectures. PeopleSoft can be used as a classical example.
The rich PeopleSoft client can communicate with the backend data store in a number of ways. It can communicate directly to the database, such as DB2, Oracle or SQL Server. Or it can communicate via a middleware application server, such as Tuxedo. SAP's architecture is three tier as standard. Sometimes a fourth tier is added to each, having a web user communicate via a web server to a middleware tier.
From a loadrunner perspective, the communication mechanism from the desktop client is what dictates whether you will use a middleware protocol, such as PeopleSoft-Tuxedo, versus a database protocol, such as DB2, for recording purposes. Some protocols have idiosyncracies in development and playback as well. But, in the end, your LoadRunner protocol API choice is dictated by the client architecture and LoadRunner's architectural ability to replace the end user keying in data at their desk (hence the moniker, Virtual User)
As for determining the difference in performance between a two tier and three tier architecture, one must have an application that can operate in both forms. Record the same business processes. Use the same data. Use the same scenarios with the same number of users, iterations, ramp up, ramp down, etc... The only item which changes is the architecture. Compare the average, min and max as well as the variance (measured in the form of standard deviation) of the response times for your key transactions. Every architecture is slightly different, but this should provide a basis for deciding which way to go in your deployment.
Replace ineffective offshore contracts, LoadRunnerByTheHour
. Starting @ $19.95/hr USD.
Put us to the test, skilled expertise is less expensive than you might imagine.
Twitter: @LoadRunnerBTH @PerfBytes