Using loadrunner to execute an Update on MS-SQL DB
I have a test were I need to update column in Micorsoft DB and this update will trigger sending a file to another application. I need to send 50,000 updates in an hour. Is there a way using load runner to execute this SQL? Your assistance is greatly appreciated.
Re: Using loadrunner to execute an Update on MS-SQL DB
LR can communicate with MSSQL DB in two different ways: “ODBC” protocol and “.NET” protocol with ADO.NET kind of script.
Regarding the performance criteria mentioned (50000 update/hour) – it is not possible to prove or disprove that it will happen – it depends on multiple parameters of software and hardware environment where such LR script could run.