- 3 minute to 2 second Performance Challenge
ServiceDesk Plus is widely deployed by businesses across countries, time zones and sites. The challenge was to make ServiceDesk Plus scalable without complicating it. It was important to make sure that scalability to be implemented with the default database, MySQL. ServiceDesk Plus enables you to deliver world class performance with MySQL and MS SQL Server. ServiceDesk Plus is optimized for MySQL. However, we recommend MS SQL Server for high volume and large scale installations.
We created a simulated environment with a help of a few customer's sample data. The idea was to create a scenario exactly as customers with large scale deployments so that we have requests with text and attachments and assets with data. The simulation was configured on a system with the following configuration with more than 5000 requests.
|Operating System||Windows Server 2003|
|Total Number of Requests||5000|
|Total Number of Requests having attachments||2000|
|Average replies per request||3|
|Tables||Rows of Data|
|Technicians and Requestors||Numbers|
|Requesters accessing ServiceDesk Plus||400|
|Number of Requests created per day||100|
|Technicians accessing ServiceDesk Plus||100|
To simulate technican's operations we had also simlated random technician frequent actions such as
The simulated production environment is tuned before executing the operations,
JVM heap size is configured to 1300M
Mysql DataBase configuration are such that it uses 2GB for buffering the data
URL for /custom is excluded - to avoid context switch in tomcat framework
Database Connection is set to 150 with corresponding max-pool-size as 200
Tomcat is configured to support 180 parallel threads/requests
Expiry is set of .html files so that browser will not send request for html files.
Database cleanup - deleted unnecessary entries in aaaaccsession, auditrecord tables etc and deleted outofoffice, undeliverable mails.
|Tables||Previous Versions||Build 7019||Build 7019 after performance pack||
|Open Requests||170.4 secs||24.2 secs||1.84 secs||2.19 secs|
|OverDue Requests||160 secs||23.6 secs||2.08 secs||2.19 secs
|Custom View||159.6 secs||25.8 secs||1.96 secs||2.21 secs
|All Requests||172.2 secs||25.8 secs||1.96 secs||2.36 secs
|Request Details Page||108 secs||13 secs||4.76 secs||4.38 secs
|New Request Creation||24.8 secs||16.8 secs||5.28 secs||7.29 secs
|New Req with Attachment (150 kb)||24.2 secs||17.2 secs||5.4 secs||7.40 secs
|Edit Request||16.4||16 secs||5.14 secs||5.05 secs