C# 클래스 Xnlab.SQLMon.Logic.QueryEngine

파일 보기 프로젝트 열기: unruledboy/SQLMonitor 1 사용 예제들

Private Properties

프로퍼티 타입 설명
GetCpuInfo void
GetDatabaseInfo System.Data.DataTable
GetDatabaseIoInfo System.Data.DataTable
GetDatabaseStall List
GetDatabasesInfo System.Data.DataTable
GetDbLogSpace Dictionary>
GetDiskSpace Dictionary>
GetLockedObjects System.Data.DataTable
GetLockedProcesses System.Data.DataTable
GetMemoryInfo void
GetOsInfo void
GetServerInfo Xnlab.SQLMon.Logic.ServerInfo
GetServerVersion int
GetSessionSql string
GetSessions System.Data.DataTable
GetSizeLong long
GetSpScripts System.Data.DataTable
GetTableInfo System.Data.DataRow

공개 메소드들

메소드 설명
GetObjectName ( object schemaName, string objectName ) : string
ParseObjectName ( string objectName, string &schemaName ) : string

비공개 메소드들

메소드 설명
GetCpuInfo ( Xnlab.SQLMon.Logic.ServerInfo server, int &sqlProcess, int &systemIdle, int &otherProcesses ) : void
GetDatabaseInfo ( Xnlab.SQLMon.Logic.ServerInfo server, string database ) : DataTable
GetDatabaseIoInfo ( Xnlab.SQLMon.Logic.ServerInfo server ) : DataTable
GetDatabaseStall ( Xnlab.SQLMon.Logic.ServerInfo server ) : List
GetDatabasesInfo ( Xnlab.SQLMon.Logic.ServerInfo server ) : DataTable
GetDbLogSpace ( Xnlab.SQLMon.Logic.ServerInfo server ) : Dictionary>
GetDiskSpace ( Xnlab.SQLMon.Logic.ServerInfo server ) : Dictionary>
GetLockedObjects ( short sessionId, Xnlab.SQLMon.Logic.ServerInfo server ) : DataTable
GetLockedProcesses ( Xnlab.SQLMon.Logic.ServerInfo server ) : DataTable
GetMemoryInfo ( Xnlab.SQLMon.Logic.ServerInfo server, long &physicalMemory, long &availableMemory ) : void
GetOsInfo ( Xnlab.SQLMon.Logic.ServerInfo server, System.DateTime &serverStartTime ) : void
GetServerInfo ( Xnlab.SQLMon.Logic.ServerInfo server, string catalog ) : Xnlab.SQLMon.Logic.ServerInfo
GetServerVersion ( Xnlab.SQLMon.Logic.ServerInfo server ) : int
GetSessionSql ( string sessionId, Xnlab.SQLMon.Logic.ServerInfo server ) : string
GetSessions ( Xnlab.SQLMon.Logic.ServerInfo server ) : DataTable
GetSizeLong ( DataTable table, DataRow row, int>.Dictionary columns ) : long
GetSpScripts ( Xnlab.SQLMon.Logic.ServerInfo server ) : DataTable
GetTableInfo ( Xnlab.SQLMon.Logic.ServerInfo server, string tableName ) : DataRow

메소드 상세

GetObjectName() 공개 정적인 메소드

public static GetObjectName ( object schemaName, string objectName ) : string
schemaName object
objectName string
리턴 string

ParseObjectName() 공개 정적인 메소드

public static ParseObjectName ( string objectName, string &schemaName ) : string
objectName string
schemaName string
리턴 string