Answer Posted / Abhinav Gupta
To trace the traffic hitting a SQL Server, you can use SQL Profiler or Extended Events. They allow you to capture events related to database activities such as queries, connections, and locks.
1. SQL Profiler: It is a tool used to monitor and analyze the performance of SQL Server. You can create traces that capture specific events and actions.
2. Extended Events: It is a lightweight, highly configurable event-processing infrastructure for real-time analysis and capturing data in SQL Server.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why and when do stored procedure recompile?
What is an indexed view?
How to convert character strings into numeric values?
How to provide default values to function parameters?
What is temporary table in sql server? Why we use temp table?
What is standby servers? Explain types of standby servers.
Explain system functions or built-in functions? What are different types of system functions?
How can I check that whether automatic statistic update is enabled or not?
What is normalization and what are the advantages of it?
what is the difference between openrowset and openquery?
Why use identity in sql server?
What is self contained sub query?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
How do I start sql server 2017?
What is a view in sql?
