What is SQL Profiler? Explain its purpose.

A SQL server profile is used to capture server events of the SQL server.

It helps you find out what is exactly going on in the SQL server. It is used to monitor and analyze SQL server events. It has a GUI for such activities.

SQL profiler is used when:

• When some queries are performing slowly
• To trace and monitor events of the SQL server
• When indexes need to be fie tuned
• When security is a concern, it can be used to audit and review security activities
• It can be used when troubleshooting to find root cause of an issue

Query optimization tips.

• Use indexes.
• Specify only the columns necessary while using select query.

If join queries are used, indexes that match the join column must be used