Hi Ash,

By the looks of the queries I'd guess you're using SQL server as a session state provider and, unfortunately, that comes with a performance cost. In the first instance I'd look at whether you really need to store sessions in SQL server. Presumably you've gone down that route because you're running your site on load balanced servers? If so, maybe you could look at using session affinity rather than round-robin load balancing which would allow you to switch to the in-memory session state provider which is much faster (though be aware that your traffic will be less evenly distributed between servers).

You could also consider your use of session state in your application. If you don't need it or can remove your reliance on it, you can switch it off entirely.

If neither of those options are viable, maybe consider using a faster out-of-process session storage mechanism like Redis or the session state service.

Thanks, Paul.

Can you please tell me in little more detail why my system using this query again and again?

You probably have your site configured to use database provider for session. it works with multiple-servers scenario, but as Paul mentioned, it comes at a cost, in this case, performance. You can think about cookie session, or even Redis one (more work is needed)

https://docs.microsoft.com/en-us/previous-versions/appfabric/ee790859(v%3dazure.10) 

Thanks Quan,

But can i use sticky session(Inproc) instead of cookie session.