Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How could i find the client? Expand / Collapse
Author
Message
Posted Thursday, May 2, 2013 9:01 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 10:24 AM
Points: 130, Visits: 272
I have a consolidated SQL Server Machine, and none of application are running on this. But I have an error like below:

The server will drop the connection, because the client driver has sent multiple requests while the session is in single-user mode. This error occurs when a client sends a request to reset the connection while there are batches still running in the session, or when the client sends a request while the session is resetting a connection. Please contact the client driver vendor.

How can i find the client driver? With Which events of Server Side Trace or Profiler trace?
Post #1448846
Posted Thursday, May 2, 2013 9:47 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:14 PM
Points: 12,952, Visits: 32,476
session is single_user mode, or the database?
if it's the database,

you can look in sys.databases for any databases with user_access_desc = 'single_user', and then compare the results to who's currently in it via sp_who2:


this worked for me, when i moved a database into single_user mode.

     declare @RESULTS TABLE( 
[WHORESULTSID] INT IDENTITY(1,1) NOT NULL PRIMARY KEY,
[SPID] CHAR (5) NULL,
[INSERTDT] DATETIME NULL DEFAULT(GETDATE()),
[STATUS] VARCHAR(30) NULL,
[LOGIN] VARCHAR(30) NULL,
[HOSTNAME] VARCHAR(30) NULL,
[BLKBY] VARCHAR(30) NULL,
[DBNAME] VARCHAR(30) NULL,
[COMMAND] VARCHAR(30) NULL,
[CPUTIME] INT NULL,
[DISKIO] INT NULL,
[LASTBATCH] VARCHAR(30) NULL,
[PROGRAMNAME] VARCHAR(200) NULL,
[SPIDINT] INT NULL,
--column added in SQL 2008--REMOVE FOR sql2005
[REQUESTID] INT NULL
)
INSERT INTO @RESULTS(SPID,Status,Login,HostName,BlkBy,DBName,Command,CPUTime,DiskIO,LastBatch,ProgramName,SPIDINT,REQUESTID)
EXEC sp_who2

select * from @results where dbname in(select NAME from sys.databases where user_access_desc = 'SINGLE_USER')



Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1448871
Posted Monday, May 6, 2013 12:05 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, November 6, 2014 10:24 AM
Points: 130, Visits: 272
I can look at concurrent sessions like above.

But, i want to trace these events with like a profiler tool. I can't catch the missed event.
Post #1449589
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse