System information

peaktimebegin or peaktimebegintr: peaktime start hour. Default is 9.
peaktimeend or peaktimeendtr: peaktime end hour. Default is 19.
weekendispeak: treat weekend as peaktime (same traffic ammount). Default is false.
restartatnight: if to restart at every night. Default is false.
restartpcatfirst: don't restrart the service. Restart the pc immediately.
trafficammount: 0=after setup
all values will be altered in offpeak and weekend times after these rules:
maxnocdrmin2*=60;
maxnologival2*=3;
minasr2 = minasr2/2;
minacl2 = minacl*2/3;
minactivesims/3;
*offpeak and weekend times are calculated based on peaktimebegin, peaktimeend, weekendispeak
The following programs are controlled (configurable):
mserver_name = "mserver";
atarongk_name = "atarongk";
fvoipgsmgw_name = "fvoipgsmgw";
vsip_name = "vsip";
valert_name = "valert";
MSSQLSERVER_name = "MSSQLSERVER";
5.118. How to check the current load on MS-SQL (query list)
select
p.spid
, right(convert(varchar,
dateadd(ms, datediff(ms, P.last_batch, getdate()), '1900-01-01'),
121), 12) as 'batch_duration'
, P.program_name
, P.hostname
, P.loginame
from master.dbo.sysprocesses P
where P.spid > 50
and P.status not in ('background', 'sleeping')
and P.cmd not in ('AWAITING COMMAND'
,'MIRROR HANDLER'
,'LAZY WRITER'
,'CHECKPOINT SLEEP'