US 12,353,402 B2
Generating scalability scores for tenants using performance metrics
Alok K. Patel, Fremont, CA (US); Amol Suresh Hardikar, Greenbrae, CA (US); Paymon Teyer, San Ramon, CA (US); and Karishma Kishore Lalwani, Woodland Hills, CA (US)
Assigned to Salesforce, Inc., San Francisco, CA (US)
Filed by Salesforce, inc., San Francisco, CA (US)
Filed on Sep. 19, 2022, as Appl. No. 17/933,372.
Claims priority of provisional application 63/261,394, filed on Sep. 20, 2021.
Prior Publication US 2023/0089783 A1, Mar. 23, 2023
Int. Cl. G06F 16/23 (2019.01); G06F 11/30 (2006.01); G06F 11/34 (2006.01); G06F 16/2457 (2019.01)
CPC G06F 16/2379 (2019.01) [G06F 11/3006 (2013.01); G06F 11/3409 (2013.01); G06F 16/24578 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A method for generating scalability scores for tenants at a multi-tenant database system, comprising:
storing a set of data logs indicating performance data for a plurality of tenants of the multi-tenant database system, the performance data tracking processing times, processor resources, or both for executing actions at the multi-tenant database system;
calculating, for a tenant of the plurality of tenants, one or more aggregate performance metrics based at least in part on respective performance data for the tenant stored in a subset of the set of data logs, wherein a performance metric of the one or more aggregate performance metrics is based at least in part on design time data for the tenant, runtime data for the tenant, or both;
comparing the one or more aggregate performance metrics to one or more performance thresholds defined for the plurality of tenants at the multi-tenant database system;
generating one or more scalability scores corresponding to the one or more aggregate performance metrics for the tenant based at least in part on the comparison of the one or more aggregate performance metrics to the one or more performance thresholds, a scalability score of the one or more scalability scores indicating an ability to satisfy the one or more performance thresholds at an increased quantity of users for the tenant in the multi-tenant database system;
sending, for display at a user interface of a user device, an indication of the one or more scalability scores, the user device operated by a user associated with the tenant; and
updating, at the multi-tenant database system, a database schema for the tenant based at least in part on a predicted change to the scalability score corresponding to the update to the database schema.