Troubleshooting SQL Server Issues

If SQL Server process or Oracle process consumes excess CPU in a web server environment, the serialized objects for the web server are stored in either SQL server or the Oracle database. The web server must access these tables frequently when running an application. Indexes may be missing, which can cause severe performance problems.

Ensure that all existing JD Edwards EnterpriseOne indexes are created for tables F989998 and F989999. You should have one index for F989998 for columns WBJOBID and WBOID. You should also have one index for F989999 for columns WBUID, WBOID, WBLNGPREF. If these indexes do not exist in the database, generate them using Object Librarian.

Add a new index to the F989999. This index should include columns WBOID, WBUID, and WBJVER. Generate this index over the F9899999 table.

Update statistics on both tables as follows:

• For Oracle, issue these commands in SQL *Plus:

  ANALYZE TABLE owner.F989999 COMPUTE STATISTICS
  

• For SQL Server, issue these commands:

  UPDATE STATISTICS owner.F989999
  

  UPDATE STATISTICS owner.F989998
  

Improvements vary depending on the number of users accessing the serialized database.