System information

In the mizuserver.ini leave the [database] settings as the main mizuserver.ini and change the [webportal] settings as follows:
mainportalreseller=RESELLER USER ID
cfg_port=WEB PORT
cfg_boundip=WEB IP
cfg_appname=app name
base_design=1
feature_loginpicture=true
loginpage_title=brandname
loginpage_footer1=any branding text
loginpage_footer2= any branding text
color_main_background=13421772
startpagelinkname=any link name
startpagelinkuri=any link uri
startpagelinkname2= any link name
startpagelinkuri2= any link uri
5.113. Database SQL fine-tune
Creare a trace table with SQL Server Profiler, then run the followings:
create column TextData2 varchar(max)
update trace12 set TextData2 = TextData
add index for cpu and duration
cpu, duration,TextData2
select top 200 * from trace12
order by duration desc
select top 200 * from trace12
order by cpu desc
select sum(cpu), applicationname