Chapter 6. Managing complex query workloads in an operational warehouse environment 259
data ingest workload and Chapter 8, “Building a corporate backup and recovery
strategy” on page 289 looks at the backup strategy workload in more detail. It is
advisable that you create a separate user ID for each maintenance workload so
that you can more easily monitor, secure, and audit each maintenance workload
separately.
6.5 Improving the overall performance of an activity
A large proportion of database administrator time is spent reacting to query and
workload performance issues. There is a point of diminishing returns where the
capacity of the system and the combined unmanaged workloads do not
reconcile. A production system is not the correct place to resolve
under-performing database design structures or inappropriate concurrent
workload numbers.
To improve the overall performance of an activity, you must understand what
other processes are running in the same time frame and what options are
available in terms of introducing change. Adding an index, MQT, or changing the
structure of a table might improve the performance of a query; however, it might
also reduce the performance of an ETL or backup operation. Context is key. The
performance of an activity must be judged primarily against the service level
objective for the activity and against best practice principles for database and
query design; is the database design or query inefficient?
Consider the following when trying to improve the performance of an activity:
???? Can the activity or other activities that run concurrently be moved to another
schedule or priority?
???? Is the query inefficient?
???? Is the underlying database design structure inefficient?
???? Can more resources be assigned to the query?
???? Is the query using hot, warm, or cold data?
Optim Performance Manager integration with Optim Data Studio can be used to
record and tune an individual query or group of queries.
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.