SQL Server Database Administrator Question:

How to trace the traffic hitting a SQL Server?

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.

Download SQL Server DB Administrator PDF Read All 84 SQL Server DB Administrator Questions
Previous QuestionNext Question
How many layers of TCP/IP protocol combined of?How many bits IP Address consist of?