My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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



Purpose

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
Purpose
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?
References

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