Hi
Hi Bharath,
Daily Developers are reporting to us, like jira is getting very slow.

can you give us some more tips ( DB related ( load or connection ) to diagnose and resolve the issue ?

Note
Under logs i found the following error

(/Data/ispdeployapps/atlassian-jira-enterprise-2.6.1-standalone-tomcat/logs)

2004-06-29 03:25:26,453 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:25:26,454 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:27:26,356 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:27:26,357 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:27:26,740 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:27:26,741 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:29:26,265 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:29:26,266 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:29:26,469 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:29:26,470 ERROR [velocity] ASTMethod.execute() : exception from introspection : java.lang.NullPointerException
2004-06-29 03:33:44,157 ERROR [atlassian.jira.servlet.QuickLinkServlet] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD=? AND OLDSTRING=? ORDER BY groupid desc ([Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.)
2004-06-29 03:33:47,879 ERROR [atlassian.jira.servlet.QuickLinkServlet] org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:SELECT ID, groupid, FIELDTYPE, FIELD, OLDVALUE, OLDSTRING, NEWVALUE, NEWSTRING FROM changeitem WHERE FIELD=? AND OLDSTRING=? ORDER BY groupid desc ([Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.)
2004-06-29 03:35:17,928 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Object has been closed.
2004-06-29 03:35:17,929 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor