Stop Tuning Your Database Manually – Let SAP HANA Cloud’s Intelligent Advisors Do It

 Managing a production SAP HANA Cloud database means constantly juggling performance, cost, and complexity. Tables grow beyond limits. Indexes drift out of sync with query patterns. Workload peaks spike memory and compute. Knowing what to change – and when – has traditionally required deep expertise and hours of manual analysis.That’s changing. SAP HANA Cloud delivers a suite of built-in functional advisors that analyze your instance and surface specific, actionable recommendations – directly from SAP HANA Cloud Central.What Are the Functional Advisors?The advisors are specialized analysis engines embedded in SAP HANA Cloud Central, accessible through the Recommendations card on any instance’s Overview page. Each advisor monitors a specific domain – physical design, storage tiering, compute scaling, instance sizing – and produces recommendations with ready-to-apply actions.Partition AdvisorThe problem it solvesSAP HANA Cloud has a hard limit of 2 billion records per table. Large, unpartitioned tables also cause slow scans, data skew, and expensive delta merges. Knowing how to partition – which method, which key, how many partitions – requires deep knowledge of your data’s shape and access patterns.What the advisor doesIt examines table specifications, row counts, query access patterns, and column cardinality, then applies a rule set that covers full-table limits, full-partition limits, frequent query predicates, temporal access patterns, and dynamic partition overflow. For each table it produces a single consolidated SQL recommendation with an importance level (High, Medium, or Low) so you know where to act first.Key benefitsProactively flags tables approaching the 2 billion record limit before they cause operational incidentsRecommends the right partitioning method (HASH, RANGE, Round-Robin, multi-level) based on actual data – not assumptionsReduces the cost and risk of repartitioning large tables by getting the design right earlierWorks particularly well for very large tables, slow scan scenarios, data skew problems, and growing data volumesGetting startedEnable the Partition Advisor from the Advisors tab. Provide credentials for a dedicated technical database user (not DBADMIN) with CATALOG READ and PARTITION ADMIN privileges. Default thresholds apply out of the box, but you can tune MIN_ROWS_FOR_PARTITIONING, REPARTITIONING_THRESHOLD, and INITIAL_PARTITIONS to match your operational standards.Index AdvisorThe problem it solvesIndexes that matched your query patterns six months ago may be dead weight today. Missing indexes leave performance on the table. Building the right index coverage manually means correlating workload statistics with table structures – a time-consuming process that rarely happens on any schedule.What the advisor doesIt analyzes all tables, existing index definitions, and workload statistics to identify two types of opportunities:Create index — where adding an index on a specific column is expected to improve query performance based on observed access patternsDrop index — where an index is rarely used or provides limited benefit, reducing storage and maintenance overheadEach recommendation comes with a ready-to-execute SQL statement, so implementation is a copy-paste away.Key benefitsTurns workload statistics into concrete index changes without requiring manual query analysisReduces both performance gaps (missing indexes) and unnecessary overhead (unused indexes)Eliminates the guesswork of index selection by grounding recommendations in actual query behaviorGetting startedEnable from the Advisors tab. Requires CATALOG READ and the relevant INDEX privileges on the target schemas or tables.Note: The current version supports filter queries on single tables. Join query support is on the roadmap.NSE (Native Storage Extension) AdvisorThe problem it solvesIn-memory storage is SAP HANA Cloud’s greatest performance asset – and its most expensive one. Not all data deserves to live in memory. Large, infrequently accessed tables or partitions silently inflate your memory footprint and cost, while small, hot objects may sit on disk unnecessarily.What the advisor doesIt collects access statistics over a configurable window (up to 90 days) and calculates scan density per object – tables, partitions, and columns – to determine data “temperature.” Based on configurable thresholds, it generates two types of recommendations:Cost recommendations: Move an object to page-loadable (disk) storage to reduce memory consumptionPerformance recommendations: Move an object to column-loadable (memory) storage to improve response timesEach recommendation includes a confidence score reflecting how representative the observed workload window is.Key benefitsReduces in-memory footprint without degrading performance for hot dataSurfaces cost savings opportunities that are invisible without systematic access pattern analysisConfidence scores let you prioritize high-certainty recommendations and defer uncertain onesSupports bulk operations so you can apply changes incrementally and at scaleGetting startedClick NSE Advisor in Recommendation Card and enable the NSE Advisor in NSE Recommendations tab. Configure your collection window, hot/cold object percentage targets, and minimum object size thresholds. Requires TABLE ADMIN, PARTITION ADMIN, and CATALOG READ system privileges.ECN (Elastic Compute Node) AdvisorThe problem it solvesSome workloads are predictably periodic – end-of-month reporting, nightly batch jobs, seasonal peaks. Provisioning a coordinator large enough to handle the peak means over-paying for compute during the other 90% of the time. But manually identifying which queries to route, when to spin up an ECN, and when to tear it down is operationally complex.What the advisor doesIt analyzes past coordinator workload against configurable memory and compute thresholds to identify peak windows where query routing to a temporary elastic compute node would bring the coordinator back within threshold. The resulting recommendation specifies the ECN size (memory and compute), the workload classes to route, and a provisioning/de-provisioning schedule.You can apply the recommendation in two ways:ECN Policy (recommended): Creates an automated policy that provisions and de-provisions ECNs on your behalf – either on a fixed schedule (daily, weekly, monthly) or dynamically in response to live system load. The policy manages workload class routing automatically.Manual: Add the ECN via Manage Configuration, update workload class routing locations, and remove the ECN when the time range ends.Key benefitsEliminates the need to maintain an oversized coordinator for occasional peaksRight-sizing the coordinator for regular workload after implementing ECN routing can meaningfully reduce total cost of ownershipECN Policies fully automate the provisioning lifecycle, removing operational overheadGetting startedThe ECN Advisor requires at least 5 vCPUs and at least one existing workload class. Enable from the Advisors tab, set memory and compute thresholds, define an analysis timeframe (30 minutes to 24 hours), and generate a recommendation. Enabling expensive statement tracing during the analysis window improves recommendation accuracy.Performance Class AdvisorThe problem it solvesKnowing when your instance needs to be resized – and to which performance class – is rarely obvious until performance has already degraded. Reactive resizing means business continuity risk. Proactive resizing based on gut feel means unnecessary cost.What the advisor doesIt runs automatically every Sunday, analyzing 2, 4, or 6 weeks of historical compute and memory utilization to determine whether your current performance class and instance size are still appropriate. When it identifies a mismatch, it produces a specific recommendation – which performance class and size to move to, and why.Key benefitsAutomatically generated – switch it on once, and it runs weekly without any manual triggerGrounds sizing decisions in actual historical workload rather than estimates or guessworkProactively surfaces the need to upsize before performance degradation reaches usersGetting startedEnable from the Advisors tab and choose your analysis window (2, 4, or 6 weeks). No additional configuration required.Note: The current version supports up-sizing scenarios only. Down-sizing recommendations are on the roadmap. Getting Started with All AdvisorsAll advisors are accessible from the Recommendations card on any instance’s Overview page in SAP HANA Cloud Central:Open your instance’s Overview pageSelect the Recommendations cardGo to the Advisors tab (*NSE Advisor is located in NSE App as of today. It will be fully integrated into Recommendation App soon)Select any advisor row to view details, enable it, and configure thresholdsYou’ll need the SAP HANA Cloud Administrator role collection to enable and configure advisors, and SAP HANA Cloud Viewer to read recommendations. What’s Coming — Analytics Advisor (Q3 2026)The advisor portfolio is actively expanding. Analytics Advisor will analyze OLAP query performance across your instance, identify slow calculation views, and recommend creating MDS cubes – materialized aggregation structures that dramatically reduce response times for repeated queries.Database sizing, physical design, storage tiering, and compute management are all moving from reactive, expert-driven tasks to automated, data-driven operations. Each new advisor is a step toward a database that tunes itself. Read More Technology Blog Posts by SAP articles 

#SAPCHANNEL