SQL Database Concepts Question:
Download Job Interview Questions and Answers PDF
Tell me what is SQL Profiler?
Answer:
-SQL Server provides a graphical tool which helps system administrators to monitor T-SQL statements of Database Engine.
-SQL Profiler can capture and store data related to every event to a file or a table.
-SQL Server Profiler can be used
1. To create a trace
2. To store the trace results in a table.
3. To watch the trace results when the trace runs
4. To replay the trace results
5. To start, stop, pause, and modify the trace results
-SQL Profiler can capture and store data related to every event to a file or a table.
-SQL Server Profiler can be used
1. To create a trace
2. To store the trace results in a table.
3. To watch the trace results when the trace runs
4. To replay the trace results
5. To start, stop, pause, and modify the trace results
Download Basic SQL Server Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Explain the rules for designing Files and File groups in SQL Server? | Can you explain Full-Text Query in SQL Server? |