perf_mssql Class Reference

Inheritance diagram for perf_mssql:

Public Member Functions
	__construct (&$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://adodb.sourceforge.net/docs-adodb.htm#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 24 of file perf-mssql.inc.php.

Constructor & Destructor Documentation

__construct()

perf_mssql::__construct

(

&

$conn

)

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

References adodb_perf\$conn.

Member Function Documentation

Explain()

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

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

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

HealthCheck()

perf_mssql::HealthCheck

(

$cli = false

)

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

References adodb_perf\HealthCheck().

sp_who()

perf_mssql::sp_who

(

)

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

Tables()

perf_mssql::Tables

(

)

Definition at line 122 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 26 of file perf-mssql.inc.php.

$settings

perf_mssql::$settings

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

$sql1

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

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