Class perf_mssql
Description
Located in /adodb5/perf/perf-mssql.inc.php (line 22)
adodb_perf | --perf_mssql
Variable Summary
Variables
mixed
$createTableSQL
= "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
)" (line 24)
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
)" (line 24)
mixed
$settings
= array(
'Ratios',
'data cache hit ratio' => array('RATIO',
"select round((a.cntr_value*100.0)/b.cntr_value,2) from master.dbo.sysperfinfo a, master.dbo.sysperfinfo b where a.counter_name = 'Buffer cache hit ratio' and b.counter_name='Buffer cache hit ratio base'",
'=WarnCacheRatio'),'prepared sql hit ratio'=>array('RATIO',array('dbcc cachestats','Prepared',1,100),''),'adhoc sql hit ratio'=>array('RATIO',array('dbcc cachestats','Adhoc',1,100),''),'IO','data reads'=>array('IO',"select cntr_value from master.dbo.sysperfinfo where counter_name = 'Page reads/sec'"),'data writes'=>array('IO',"select cntr_value from master.dbo.sysperfinfo where counter_name = 'Page writes/sec'"),'Data Cache','data cache size'=>array('DATAC',"select cntr_value*8192 from master.dbo.sysperfinfo where counter_name = 'Total Pages' and object_name='SQLServer:Buffer Manager'",''),'data cache blocksize'=>array('DATAC',"select 8192",'page size'),'Connections','current connections'=>array('SESS','=sp_who',''),'max connections'=>array('SESS',"SELECT @@MAX_CONNECTIONS",''),false) (line 33)
'Ratios',
'data cache hit ratio' => array('RATIO',
"select round((a.cntr_value*100.0)/b.cntr_value,2) from master.dbo.sysperfinfo a, master.dbo.sysperfinfo b where a.counter_name = 'Buffer cache hit ratio' and b.counter_name='Buffer cache hit ratio base'",
'=WarnCacheRatio'),'prepared sql hit ratio'=>array('RATIO',array('dbcc cachestats','Prepared',1,100),''),'adhoc sql hit ratio'=>array('RATIO',array('dbcc cachestats','Adhoc',1,100),''),'IO','data reads'=>array('IO',"select cntr_value from master.dbo.sysperfinfo where counter_name = 'Page reads/sec'"),'data writes'=>array('IO',"select cntr_value from master.dbo.sysperfinfo where counter_name = 'Page writes/sec'"),'Data Cache','data cache size'=>array('DATAC',"select cntr_value*8192 from master.dbo.sysperfinfo where counter_name = 'Total Pages' and object_name='SQLServer:Buffer Manager'",''),'data cache blocksize'=>array('DATAC',"select 8192",'page size'),'Connections','current connections'=>array('SESS','=sp_who',''),'max connections'=>array('SESS',"SELECT @@MAX_CONNECTIONS",''),false) (line 33)
mixed
$sql1
= 'cast(sql1 as text)' (line 23)
Methods
Documentation generated on Sun, 09 Mar 2008 23:52:45 -0300 by phpDocumentor 1.4.0
