Any suggestions on the performance issue.
please find the Server hardware configuration and the software details attached.
Intel Pentium 2.8 Ghz - 2 proc
RAM : - 2 Gb
HDD : - 2*300 Gb
Os : - windows 2003 SP1
Only OTRS running in this machine.
SQL Bench MARK Result (this is varying based on the CPU utilization, by the time i am taking this bench mark the CUP utilization is more than 80%). When more than 6-8 agents are working the cpu is taking more.
Please suggest any tips to increase the performance.
SQL benchmark
Multiplier:
Please select a multiplier and press start button.
Result: SQL
Key Value Time Comment
Insert Time: 10000 9 s
Should not take more than 5's on an average system.Update Time: 10000 24 s
Should not take more than 9's on an average system.Select Time: 10000 12 s
Should not take more than 6's on an average system.Delete Time: 10000 16 s
Should not take more than 5's on an average system.Multiplier: * 1 s
Configuration file : -
Database
• OK Check "System Time" vs "Current Timestamp".
There is no difference between application server time and database server time.
• OK Size of the current database.
Database size is 0.210 GB.
• OK Check "max_allowed_packet" setting.
Your configuration setting is 20 MB.
• OK Check "query_cache_size" setting.
32 MB
• OK Check existing framework tables.
81 tables checked.
• OK Check if the client uses utf8 for the connection.
Your client connection is utf8.
• OK Check if the database uses utf8 as charset.
Your database character setting is utf8.
• OK Check database utf8 support.
Your database version supports utf8.
• OK Check the utf8 table charset collation.
Your charset collation is set to utf8_general_ci.
• OK Check database version.
MySQL 5.1.51-community-log
OS
• OK Shows the used distribution.
Windows Server 2003 R2 Standard Edition Service Pack 1 is used.
• OK Check Perl Version.
Perl 5.12.3 (MSWin32) is used.
• OK Check Perl Modules installed.
All Perl modules needed are currently installed.
OTRS
• OK Check if Ticket::Frontend::ResponseFormat contains no $Data{""}.
No $Data{""} found.
• OK Check default SOAP credentials.
You have not enabled SOAP or have set your own password.
• OK Check if root@localhost account has the default password.
There is no active root@localhost with default password.
• Failed Check if the configured FQDN is valid.
Invalid FQDN '192.168.2.90'.
• OK Check if file system is writable.
The file system is writable.
• OK Search for invalid user with locked tickets.
There are no invalid users with locked tickets.
• OK Check log for error log entries.
• OK Check open tickets in your system.
You have 97 open tickets in your system.
• OK Check deployment of all packages.
All packages are correctly installed.
• OK Check if the configured SystemID contains only digits.
Your SystemID setting is 10.
• OK Check Ticket::SearchIndexModule setting.
You are using "Kernel::System::Ticket::ArticleSearchIndex::RuntimeDB", that's fine for 259 articles in your system.
• OK Check Ticket::IndexModule setting.
You are using "Kernel::System::Ticket::IndexAccelerator::RuntimeDB", that's fine for 111 tickets in your system.
• OK Check orphaned StaticDB records.
No orphaned records found.
• OK Display a general system overview
General information about your system.
Item Value
Agents 56
Articles 259
Articles per ticket (avg) 2.33
Attachment size (avg) 14.00 KB
Attachments per ticket (avg) 0.49
Customers with at least one ticket 32
Groups 17
Months between first and last ticket 1.00
Operating system MSWin32
Product OTRS 3.1.11
Roles 5
Tickets 111
Tickets per month (avg) 111.00
Webserver
• OK Check if the system uses Apache::DBI.
Apache::DBI
• OK Check if the system uses Apache::Reload/Apache2::Reload.
Apache2::Reload
• OK Display web server version.
You are running Apache/2.2.22 (Win32) mod_apreq2-20090110/2.7.1 mod_perl/2.0.4 Perl/v5.12.3.
• OK Check for CGI Accelerator.
mod_perl/2.0.4
Regards,
Madhu