一、ＭＳＳＱＬ中可以用sp_Who擷取串連的使用者名稱資訊，
二、Oracle也有類似的系統函數
Code
SQL> select count(*) from v$session #串連數
SQL> Select count(*) from v$session where status='ACTIVE' #並發串連數
SQL> show parameter processes #最大串連
SQL> alter system set processes = value scope = spfile;重啟資料庫 #修改串連
三、Access下有以下幾種思路：
第一：直接看ldb檔案，有幾行就有幾個串連
格式基本上是
hostname workgroupUserId
第二： 用vbscript
有兩段代碼可以參考：
Microsoft:
VBScript
Sub ShowUserRosterMultipleUsers()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim i, j As Long
Set cn = CurrentProject.Connection
' The user roster is exposed as a provider-specific schema rowset
' in the Jet 4.0 OLE DB provider. You have to use a GUID to
' reference the schema, as provider-specific schemas are not
' listed in ADO's type library for schema rowsets
Set rs = cn.OpenSchema(adSchemaProviderSpecific, _
, "{947bb102-5d43-11d1-bdbf-00c04fb92675}")
'Output the list of all users in the current database.
Debug.Print rs.Fields(0).Name, "", rs.Fields(1).Name, _
While Not rs.EOF
Debug.Print rs.Fields(0), rs.Fields(1), _
rs.Fields (2), rs.Fields(3)
rs.MoveNext
Wend
End Sub
Access Web:
VBScriptCode
' This code was originally written by Dev Ashish.
' It is not to be altered or distributed,
' except as part of an application.
' You are free to use it in any application,
' provided the copyright notice is left unchanged.
'
' Code Courtesy of
' Dev Ashish
'
Private Declare Function apiGetUserName Lib "advapi32.dll" Alias _
Function fOSUserName() As String
' Returns the network login name
Dim lngLen As Long, lngX As Long
Dim strUserName As String
strUserName = String$(254, 0)
lngLen = 255
lngX = apiGetUserName(strUserName, lngLen)
If (lngX > 0) Then
fOSUserName = Left$(strUserName, lngLen - 1)
Else
fOSUserName = vbNullString
End If
End Function
'******************** Code End **************************
四、MySql
mysql> show processlist;
或
Code
./mysqladmin processlist
例：
C:\Documents and Settings\administrator>mysqladmin processlist
更詳細的，查看當前所有串連的詳細資料:
./mysqladmin -uadmin -p -h10.140.1.1 processlist
只查看當前串連數(Threads就是串連數.):./mysqladmin -uadmin -p -h10.140.1.1 status
