C# Class Xnlab.SQLMon.Logic.QueryEngine

Mostra file Open project: unruledboy/SQLMonitor Class Usage Examples

Private Properties

Property	Type	Description
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

Public Methods

Method	Description
GetObjectName ( object schemaName, string objectName ) : string
ParseObjectName ( string objectName, string &schemaName ) : string

Private Methods

Method	Description
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

Method Details

GetObjectName() public static method

public static GetObjectName ( object schemaName, string objectName ) : string
schemaName	object
objectName	string
return	string

ParseObjectName() public static method

public static ParseObjectName ( string objectName, string &schemaName ) : string
objectName	string
schemaName	string
return	string