Share This:

In this session, Rajeev will cover database considerations for the Remedy Platform Solution in July’s monthly webinar.

 

This presentation will discuss various database considerations based on your Remedy deployment to optimize performance.  The following topic areas will be included:

 

  *   Oracle Case Insensitivity and the LIKE operator

  *   Oracle cursor_sharing & Remedy 9.x/18/x versions

  *   Oracle SQL Plan Directives, 12c optimizer features & Remedy

  *   Oracle optimizer_features_enable parameter and Remedy

  *   MSSQL’s PARAMETERIZATION & Remedy 9.x, 18.x, and 19.x versions

  *   MSSQLs Maximum Degree of Parallelism and the Cost Threshold for Parallelism parameters for tuning

  *   MSSQL’s Schema Binding and Indexing of Views

 

Rajeev Patel is a Lead Product Developer

 

Below is the recording from the live webinar including Q&A asked during the event.  The recording is also available as a podcast on iTunes.

 

 

Additionally, you can find questions discussed during the webinar session in an attachment or on this online document.

 

Presentation References

 

Subscribe to the BMC Helix Remedy & Discovery Youtube Channel

https://www.youtube.com/c/BMCRemedyandDiscovery

 

Oracle – “Linguistic Indexes not used for LIKE :BIND Predicates (DOC Id 1451804.1)

 

Tuning the MSSQL Server

 

Tuning the Oracle Server

 

For more information, or if you have questions, please contact Gregory Kiyoi or Jeff Hudson

Remedy AR System  Remedy ITSM  CMDB  Discovery  Digital Workplace BMC Helix