python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - sp-who2

How can I tell if a host is connecting via multiple spids using one application or running multiple instances of the application itself?

We trace our SQL Server activity for performance issues. Some applications, written in C#, look to have up to 50 individual spids connecting to the DB from a single machine. How can I distinguish if t...
test-img

cloudsafe

sql-server

sql-server-2016

sql-server-profiler

sp-who2

Votes: 0

Answers: 1

Latest Answer

Maybe you can adapt this script to your needs CREATE TABLE tbl_who2 ( SPID INT, Status VARCHAR(255), Login VARCHAR(255), HostName VARCHAR(255), BlkBy VARCHAR(255)...
test-img

GuidoG

Posts

Questions

Blogs

Jobs