c# - Performance evaluation of Web API calls with Database LINQ queries -

i have ui calls webapis (webapi 2.0), web api linq queries (to ms sql database) , processing logic data. want performance evaluation of complete flow (click ui api, ui display data) upon huge db 30k - 60k records in it.

how can done? let me know methods/tools used this.

currently tracking time-taken in chrome debug window, shows total time each network call.

wow. subject in own right here's approach:

the bits independent break down. measure linq queries without of logic or web api stuff getting in way. if linq against stored procedures measure first. measure cost of logic, measure cost of sending x rows of data using webapi. should avoid including cost of retrieving rows database you're checking connectivity. i'd consider writing browserless test client (i.e. gets/posts or whatever) eliminate browser variable.

now you've got picture of time gets spent. know if you've got db issues, query issues, network issues or application server issues.

assuming goes well, add bunch of instances test harness you're testing concurrent access, load testing , like. if wrong can't surface single user important.

break down chunks , have data set can consistently bring known state.

as tools, depends on use. vs comes bunch of useful things there tons of third party ones too. if have dedicated test team might part of setup. sql server has huge chunk of monitoring capability. ask dbas. if you've got find own way, keep in mind want able pressing button, not setting complex environment.