SQL Server Profiler:-
It shows how the SQL Server resolves queries internally. This allows administrator to see exactly what T-SQL statements or multi dimensional expressions are submitted to the SQL server and how the server access the data base to return result sets.
The following things can be done with SQL Profiler:-
It shows how the SQL Server resolves queries internally. This allows administrator to see exactly what T-SQL statements or multi dimensional expressions are submitted to the SQL server and how the server access the data base to return result sets.
The following things can be done with SQL Profiler:-
- Create a trace that is based on reusable templates.
- Watch the trace results as the trace runs.
- Store the trace result in a table.
- Start, Stop, Pause and Modify the trace result as necessary.
- reply the trace result.
No comments :
Post a Comment