Good Day Experts!
I have been tasked with trying to find the performance issue with an existing S/P that is called from a VB.Net application. I have setup a testing app to execute the S/P from. In the S/P 6 db calls are made and cursors are used. The S/P is called numerous times in loop by AccountNumber anywhere from 1-6 times. Each AccountNumber has it's own database. I tested it 50 times and have a sample range of 1.99 to 111 seconds.
1) It is understandable that the queried table may have a large number of records that may account for a performance issue
2)Network traffic? perhaps could be a contributor
But within the S/P how can I test for performance issues based on possible poor construction when calling from my VB.Net app?