Login Issues From Jiwa Web Api

[Mike.Sheen]

A quick way of counting SQL connections for a particular DB and Application - just edit the WHERE clause as required:

Code: Select all

DECLARE @WhoTable TABLE(
        SPID INT,
        Status VARCHAR(MAX),
        LOGIN VARCHAR(MAX),
        HostName VARCHAR(MAX),
        BlkBy VARCHAR(MAX),
        DBName VARCHAR(MAX),
        Command VARCHAR(MAX),
        CPUTime INT,
        DiskIO INT,
        LastBatch VARCHAR(MAX),
        ProgramName VARCHAR(MAX),
        SPID_1 INT,
        REQUESTID INT
)

INSERT INTO @WhoTable EXEC sp_who2

SELECT  *
FROM    @WhoTable
WHERE DBName = 'ApiJiwaComAu'
AND ProgramName = 'Jiwa Financials'

[SBarnes]

There are 75 open api sessions and 111 from sp_who2

[Mike.Sheen]

There are 75 open api sessions and 111 from sp_who2

75 api sessions seems excessive. Are you using username + password auth, api key auth or a mix?

[SBarnes]

It uses username and password only, there is a JsonServiceClient per user of the site which is used to avoid the slowness of the login process of the api.