My Oracle Support Banner

E1:DB: Frequently Asked Questions on SQL Server Database Performance (Doc ID 1529641.1)

Last updated on SEPTEMBER 20, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.


This document consolidates frequently asked questions on SQL Server database performance when working with JD Edwards EnterpriseOne software.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 Question 1: How can you update the index statistics for SQL Server 2005?
 Question 2: Can a command modifier in a sql statement cause a performance problem?
 Question 3: What are the effects of CursorType parameter in performance?
 Question 4: Is there any official document with considerations for E1 with Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2?
 Question 5: Is there a method to proactively detect and record database events and notify the DBA of a problem?
 Question 6: What is the correct value for Rowset Size in the enterprise server JDE.INI so performance is not affected?
 Question 7: Is table partitioning supported for SQL Server 2008?
 Question 8: Where should I reach for further information on performance?
 Question 9: When using JD Edwards EnterpriseOne with an RCSI Implemented SQL Database, what are the guidelines and best practice?
 Question 10: Can the Legacy Cardinality Estimator setting be enabled in MS SQL 2016? (It is disabled by default.)
 Question 11: What could be reason for SQL Server TEMBDB file growth?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.