SELECT DB_NAME(dbid) as ‘資料庫名稱’, COUNT(*) as ‘連線數’
FROM sysprocesses
GROUP BY DB_NAME(dbid)
ORDER BY COUNT(*) DESC
探索更多來自 宸宸知識庫 的內容
訂閱後即可透過電子郵件收到最新文章。
SELECT DB_NAME(dbid) as ‘資料庫名稱’, COUNT(*) as ‘連線數’
FROM sysprocesses
GROUP BY DB_NAME(dbid)
ORDER BY COUNT(*) DESC
訂閱後即可透過電子郵件收到最新文章。