Return
-
Title
After upgrade to version 12.4 the network traffic is much higher. -
Description
After upgrade to Spotlight on SQL Server 12.4 the network traffic become significantly higher than in previous version. -
Resolution
Reduce the amount of collected information. setting the minimal duration you are interested in.
The data is correct, it can be treated as a filter condition, it will filter insignificant statements. I.e. if you set duration > 200, then the following events
wait_info,wait_info_external,sp_statement_completed,sql_statement_completed duration < 200will be filtered out, and only more significant statements will be captured.