Check the total number of active connections on the MSSQL Database server

Please use the query below to check the total number of active connections at a time, on the MSSQL database server :-

#################################################################

SELECT
    DB_NAME(dbid) as elitemoving,
    COUNT(dbid) as NumberOfConnections,
    loginame as LoginName
FROM
    sys.sysprocesses
WHERE
    dbid > 0
GROUP BY
    dbid, loginame
#############################################################

Shubham Wednesday 03 June 2015 - 8:30 pm | | Default
Used tags: , , , , ,

No comments

(optional field)
(optional field)

Comment moderation is enabled on this site. This means that your comment will not be visible until it has been approved by an editor.

Remember personal info?
Small print: All html tags except <b> and <i> will be removed from your comment. You can make links by just typing the url or mail-address.
« Check space for a par… | Home |