Multiple choice technology databases

SQL Profiler tool is used for?

  1. (a) Configuring Services

  2. (b) Detecting slow running queries

  3. (c) Troubleshooting

  4. (d) All of the above
Reveal answer Fill a bubble to check yourself
B,C Correct answer
Explanation

SQL Profiler is primarily a diagnostic and performance monitoring tool. It's used to detect slow-running queries by capturing trace events, and for troubleshooting database issues by analyzing query patterns, deadlocks, and performance bottlenecks. It doesn't configure services directly - that's done through Configuration Manager or Surface Area Configuration.

Keep practicing — related questions