perf_mssql Class Reference

Inheritance diagram for perf_mssql:

Public Member Functions
	perf_mssql (&$conn)
	Explain ($sql, $partial=false)
	Tables ()
	sp_who ()
	HealthCheck ($cli=false)
Public Member Functions inherited from adodb_perf
	_CPULoad ()
	MemInfo ()
	CPULoad ()
	Tracer ($sql)
	Explain ($sql, $partial=false)
	InvalidSQL ($numsql=10)
	_SuspiciousSQL ($numsql=10)
	CheckMemory ()
	SuspiciousSQL ($numsql=10)
	ExpensiveSQL ($numsql=10)
	_ExpensiveSQL ($numsql=10)
	DBParameter ($param)
	PollParameters ()
	_DBParameter ($sql)
	WarnCacheRatio ($val)
	clearsql ()
	UI ($pollsecs=5)
	Poll ($secs=5)
	HealthCheckCLI ()
	HealthCheck ($cli=false)
	Tables ($orderby='1')
	CreateLogTable ()
	DoSQLForm ()
	SplitSQL ($sql)
	undomq ($m)
	OptimizeTables ()
	OptimizeTable ( $table, $mode=ADODB_OPT_LOW)
	optimizeDatabase ()

Public Attributes
	$sql1 = 'cast(sql1 as text)'
	$createTableSQL
	$settings
Public Attributes inherited from adodb_perf
	$conn
	$color = '#F0F0F0'
	$table = '<table border=1 bgcolor=white>'
	$titles = '<tr><td><b>Parameter</b></td><td><b>Value</b></td><td><b>Description</b></td></tr>'
	$warnRatio = 90
	$tablesSQL = false
	$cliFormat = "%32s => %s \r\n"
	$sql1 = 'sql1'
	$explain = true
	$helpurl = "<a href=http://phplens.com/adodb/reference.functions.fnexecute.and.fncacheexecute.properties.html#logsql>LogSQL help</a>"
	$createTableSQL = false
	$maxLength = 2000
	$_lastLoad

Additional Inherited Members
Static Public Member Functions inherited from adodb_perf
static	table ($newtable=false)

Detailed Description

Definition at line 22 of file perf-mssql.inc.php.

Member Function Documentation

Explain()

perf_mssql::Explain	(		$sql,
			$partial = false
	)

Definition at line 77 of file perf-mssql.inc.php.

References $rs, $sql, and adodb_perf\Tracer().

HealthCheck()

perf_mssql::HealthCheck

(

$cli = false

)

Definition at line 152 of file perf-mssql.inc.php.

References adodb_perf\HealthCheck().

perf_mssql()

perf_mssql::perf_mssql

(

&

$conn

)

Definition at line 68 of file perf-mssql.inc.php.

References adodb_perf\$conn.

sp_who()

perf_mssql::sp_who

(

)

Definition at line 146 of file perf-mssql.inc.php.

Tables()

perf_mssql::Tables

(

)

Definition at line 120 of file perf-mssql.inc.php.

Member Data Documentation

$createTableSQL

perf_mssql::$createTableSQL

Initial value:

= "CREATE TABLE adodb_logsql (
          created datetime NOT NULL,
          sql0 varchar(250) NOT NULL,
          sql1 varchar(4000) NOT NULL,
          params varchar(3000) NOT NULL,
          tracer varchar(500) NOT NULL,
          timer decimal(16,6) NOT NULL
        )"

Definition at line 24 of file perf-mssql.inc.php.

$settings

perf_mssql::$settings

Definition at line 33 of file perf-mssql.inc.php.

$sql1

perf_mssql::$sql1 = 'cast(sql1 as text)'

Definition at line 23 of file perf-mssql.inc.php.