If you missed my talk at Collaborate in Denver this year, here come some quick tips on diagnosing sub-standard performance.
Many times, people tend to balk at performance problems. They just freeze in hesitation and dwell on the problem, while many times, performance can be rapidly improved by simply going down the list of 'quick hits'. So here it comes. Roll up your sleeves and check:
- Virus scanner configuration. The number one reason for slow performance on many windows deployments. Disable your anti-virus and see if that makes a difference.
- Network problems. Unnecessary firewalls that slow down your network connections. Examine the firewall usage and eliminate or downgrade those that aren’t critical to system security. The same is true for other unnecessary network layers, routers, hubs and switches. Your best bet is to place all the components of your Web Center Content installation on the same subnet. Another important consideration here is the be bandwidth between the Content Server and its file system (when not using JDBC storage). Most deployments store files on remote file systems (SAN or NAS) yet system administrators only looking at the pipe going to the database.
- Other applications competing for resources - file system, database or web server. See if you have another applications sharing the same physical servers. This point is especially true when running on a virtual server. If too many applications are running on one physical server, response time will be slowed for all applications. Examine your server resources and adjust them accordingly.
- Bad timing of batch loading backups and archives. Make sure that all resource - intensive activities are performed at your off-peak times, when few users are on the system.
- Overly detailed logging levels - WebLogic, Content Server and External loggers
- Insufficient memory - Content Server and database. Low memory causes extensive disk activity when the system is trying to compensate for the lack of RAM by using its swap file.
- Database indexes that can be easily tuned to quickly boost your most common queries - be sure to check both - content and indexing database instances if they are separate
- Check the search queries that you running - watch for overly complex and sub-optimal ones. Are you running on Oracle but don’t have the Oracle Query Optimizer component installed?
- Running outdated software. Many times you can get a tangible boost by simply installing the latest patch or upgrading to the new version of Web Center Content