|
What is SQL Profiler? Explain its purpose.SQL Profiler: It’s a GUI interface to SQL Server Trace and allows monitoring an instance of the database engine and even Analysis services. It enables capturing sand saving data about every event into a file or table for performing analysis later. It helps understand and read all the trace information helping in identifying performance and bottleneck resolution.Define SQL Profiler. SQL Profiler is used to diagnose a problem by capturing events in a trace file.
It is useful to step through queries to find the reason of slow performance.
You can monitor SQL server performance in order to tune workload.
SQL profiler also supports auditing of actions on the server 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
|
