SQL Administrator Question:

Tell us how do you trace the traffic hitting a SQL Server?

SQL Administrator Interview Question
SQL Administrator Interview Question

Answer:

SQL profiler is the SQL Server utility you can use to trace the traffic on the SQL Server instance. Traces can be filtered to narrow down the transactions that are captured and reducing the overhead incurred for the trace. The trace files can be searched, saved off, and even replayed to facilitate troubleshooting.


Previous QuestionNext Question
Tell me what are the new features in SQL Server 2005 when compared to SQL Server 2000?Tell us what is a system database and what is a user database?