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