Database Reference
In-Depth Information
Diagnosing performance issues
The practice of performance tuning can range from being simple to being very com-
plex, but most issues are easy to resolve through effective design and by applying
simple troubleshooting steps and techniques. Sometimes problems are obvious and
can be resolved easily. In more challenging cases, we must consider the possible
causes and then eliminate possibilities to discover the remaining options. Fortunately,
in most models, performance issues can be addressed without extensive experiment-
ation. If your models have large volumes of data, many tables, complex relationships,
or layers of complex calculation logic, you have a higher likelihood of running into per-
formance problems that you'll need to sort out.
Processing and query-related performance
The xVelocity In-Memory Analytics Engine consists of a storage engine and a query
engine that work in tandem to return query results and perform calculations. A funda-
mental understanding of these components is helpful, much like a basic understand-
ing of automotive principles is helpful to diagnose problems with a car. Some prob-
lems are discovered and corrected by reading the instrument panel or engine code
displayed by a diagnostic computer. Some problems can be discovered and resolved
by listening to the engine to find a pulley, bearing, or belt making noise. A few more
elusive problems require the expertise of a certified mechanic and can't be fixed eas-
ily by tinkering and experimenting. Troubleshooting the Tabular storage and query en-
gine is similar.
Search WWH ::
Custom Search