January 25, 2018 at 9:08 am
I couldn't find enough documentation around perfmon counter SQLServer: General Statistics – User Connections . I got some baseline done , for the same process i see significant jump in user connections. I am pretty sure SQLServer: General Statistics – User Connections is same as number of threads because the sproc was executed manually through SSMS in theory should only be one spid, would like to confirm.
January 25, 2018 at 10:09 am
No. It's not the same as measuring threads. It's just the users connected to the database. Generally, there's probably a 1:1 correlation a lot of the time. However, it won't always be so, and you can't count on that.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
January 25, 2018 at 11:01 am
Hmmmm...That is really interesting. I have nothing else running on this server but this one sproc opened in SSMS which only creates one spid. Wondering why it shows 22.
January 25, 2018 at 12:12 pm
System processes and other threads.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply