ServiceDesk Plus Database Performance Tuning

MySQL Performance Tuning Script

——————————————-

If you feel ServiceDesk Plus is slow, here are a couple of performance tweaks to make SDP’s MYSQL database more responsive.

You need to make changes to the startDB.bat present under your installation directory (AdventNet\ME\ServiceDesk\bin) to start SDP uses all the RAM in the dedicated server.

Replace your existing StartDB.bat with this Modified StartDB.bat file then change the performance parameters.

http://blogs.servicedeskplus.com/files/startdb_186.zip

There are two parameters that needs to be changed in the script. The key buffer size and innodb buffer pool size to make sure it make the most of the dedicated RAM

– key_buffer_size=100000000

– innodb_buffer_pool_size=350000000

For 1 GB RAM, you can try values

innodb_buffer_pool_size to be from 350000000 to 400000000

For 3 GB RAM, you can try values

– key_buffer_size=200000000

– innodb_buffer_pool_size=9500000000

(You can also try playing around the memory size number till you get the right performance)

Note:After you edit/ replace the startDB.bat file. You have to shutdown and restart the ServiceDesk Plus server for the changes to take effect.

For Heaven’s Sake: PLEASE TRY THIS OUT ON YOUR STAGING SERVER OR TEST SERVER ONLY. AFTER IT MEETS YOUR EXPECTATION MOVE IT TO YOUR LIVE SERVER

——————For those who care to know why—————————–

Why is ServiceDesk Plus slow?

Even if you have installed ServiceDesk Plus on dedicated server, there is a very good chance that you might feel that SDP is not very responsive. As ServiceDesk Plus uses only fixed amount of memory from the installed workstation, so even if you install it on a server with 4GB, it will consume only limited memory. And so, it is bound to be slow.

Why does ServiceDesk Plus use only limited memory?

SDP consumes limited memory as it optimized for evaluation. You can install and run SDP in just about any regular workstation. It is designed to run even on a workstation with minimal configuration so that you can get started your evaluation even if you don’t have a dedicated resource. In an environment where there a multiple applications running, SDP uses only limited memory and makes sure that it does not choke the workstation.

What Next?

We’ll make sure all the performance enhancements are rolled into SDP. You’ll have screens to configure SDP’s performance parameters based on the resources you have.

If you have tried out any performance tweaks on your own, please feel free to share. If your tweak works, get ready to collect your rewards!