WHAT I'M TRYING TO FIND OUT
How many logins/s and logouts/s I'm having on my SQL Server 2016 Standard.
WHAT I DID
SQL SERVER PROFILER
In SQL Server Profiler, I made a trace selecting only 'Audit Login' and 'Audit Logout'. The trace runned for about 10 seconds, and I had about 10000 lines of trace.
I tested this a number of times, and also with only 'Audit Login' or 'Audit Logout', and it's about 5000 each for 10 secconds, meaning about 500 logins/s.
In Performance Monitor, I selected the counters 'Logins/sec', 'Logouts/sec' and 'User Connections' in SQLServer:General Statistics Section.
I'm getting average of 3,5 logins and logouts per second.
The number of logins/logout in SQL Server observed through Performance Monitor and SQL Server Profiler differ by a large margin.
What I'm reading wrong here?
Tks in advance.