1-) MSSQL RMOS - mssql acik olan connection sayısını getirir

SELECT

    DB_NAME(dbid) as DBName,

    COUNT(dbid) as NumberOfConnections,

    loginame as LoginName

FROM

    sys.sysprocesses

WHERE

    dbid > 0

GROUP BY

    dbid, loginame

GEÇİCİ ÇÖZÜM MAX POOL SİZE YANİ MAXİMUM AÇIK KALAN OTURUM SAYISI BELİRTMEDİR

initial catalog=KurDB;persist security info=True;user id=sa;Max Pool Size=10000;

Max Pool Size=10000 -> .net core 6.0 dada çalışır