Performance in SQL

anyone knows how to view performance in SQL, afaik in navision we will go into database session and take a look at the
blocking id… but at times no blocking id indicated yet userS still feedback is slow…

[:’(]

Use SQL profiler…