I have several stored procedures which queries several tables to look for given primary key value.
The stored procedures are called from the.NET desktop application.
This part of sql queries are running extremely slow.
Is there any tool I can use to analyze the performance of the sql queries and find a way to improve them?
I have several inner joins in the query.