TechQA.

Question

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

score 117 · Answer 1 · 2022-04-06T14:17:23.350000

0

Answer

117

Views

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

117 views Asked by cloudsafe At 06 April 2022 at 14:17

score 687 · Answer 2 · 2019-07-25T09:45:34.610000

sp_WhoIsActive/spwho2 - get process id

687 views Asked by w0051977 At 25 July 2019 at 09:45

score 200 · Answer 3 · 2018-12-04T11:38:55.893000

LastBatch in result of sp_who2 is set to 01/01

200 views Asked by demo At 04 December 2018 at 11:38

score 355 · Answer 4 · 2018-09-05T16:11:06.570000

Block in SQL Server (SP_WHO2)

355 views Asked by Gabriel Sarzi At 05 September 2018 at 16:11

score 427 · Answer 5 · 2018-05-28T06:56:30.403000

Delete Statement runs forever

427 views Asked by Prakash At 28 May 2018 at 06:56

score 954 · Answer 6 · 2017-11-16T09:24:45.017000

History of connected servers/clients to a SQL Server database

954 views Asked by Chester van Ree At 16 November 2017 at 09:24

score 482 · Answer 7 · 2017-06-24T08:53:59.980000

SQL Server `sp_who2` procedure shows long locks by a sleeping connection

482 views Asked by Mando At 24 June 2017 at 08:53

score 844 · Answer 8 · 2015-06-05T10:25:13.473000

SQL Server CPU Usage

844 views Asked by Rakesh At 05 June 2015 at 10:25

score 1111 · Answer 9 · 2013-05-14T09:58:12.437000

EXEC sp_who2 LastBatch showing future date

1.1k views Asked by thatthing At 14 May 2013 at 09:58

score 2782 · Answer 10 · 2013-04-02T00:56:19.667000

why does "SELECT 1 from <table>" cause a LCK_M_IX on another process doing a DELETE

2.7k views Asked by dmc2005 At 02 April 2013 at 00:56

score 9881 · Answer 11 · 2012-07-23T21:03:39.113000

SP_WHO2 conditional?

9.8k views Asked by Chris Townsend At 23 July 2012 at 21:03

score 7066 · Answer 12 · 2011-07-19T11:06:49.840000

VB.Net SQLClient Connections and SQL Server - active connections reflect even though all closed

7k views Asked by Raphael Segal At 19 July 2011 at 11:06

score 396 · Answer 13 · 2011-01-31T05:17:24.203000

Show output of sp_who2 in WPF datagrid

396 views Asked by Craig Schwarze At 31 January 2011 at 05:17

score 30456 · Answer 14 · 2010-11-18T19:29:18.880000

sp_who2 BlkBy Sleeping Process Awaiting Command

30.4k views Asked by Stefan Mai At 18 November 2010 at 19:29

TechQA.

List Question

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

sp_WhoIsActive/spwho2 - get process id

LastBatch in result of sp_who2 is set to 01/01

Block in SQL Server (SP_WHO2)

Delete Statement runs forever

History of connected servers/clients to a SQL Server database

SQL Server `sp_who2` procedure shows long locks by a sleeping connection

SQL Server CPU Usage

EXEC sp_who2 LastBatch showing future date

why does "SELECT 1 from <table>" cause a LCK_M_IX on another process doing a DELETE

SP_WHO2 conditional?

VB.Net SQLClient Connections and SQL Server - active connections reflect even though all closed

Show output of sp_who2 in WPF datagrid

sp_who2 BlkBy Sleeping Process Awaiting Command

Popular Questions

Trending Questions