Abstract: Some implementations of the disclosed systems, apparatus, methods and computer program products may provide for determination of resource usage by tenants in a multi-tenant server system. Tenants may provide resource requests to a database of the multi-tenant server system and such resource requests may include context data. Periodic snapshots of the database may be performed to determine the pending resource requests received by the various tenants and, based on the snapshots and the context data, the resource usage of the various tenants, as well as the system as a whole, may be determined and forecasted for the future.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating early detection and warning for system bottlenecks in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes detecting waits during processing of a query within a processing pipeline, wherein the waits include one or more of application-specific waits and database-specific waits; diagnosing the waits to identify a wait that has turned into a bottleneck; classifying one or more types of issues causing the wait to turn into the bottleneck; generating an alert having associated information detailing the issues based on the one or more types and a location of the wait within the processing pipeline; and transmitting the alert to facilitate correction activities.

Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating early detection and warning for system bottlenecks in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes detecting waits during processing of a query within a processing pipeline, wherein the waits include one or more of application-specific waits and database-specific waits; diagnosing the waits to identify a wait that has turned into a bottleneck; classifying one or more types of issues causing the wait to turn into the bottleneck; generating an alert having associated information detailing the issues based on the one or more types and a location of the wait within the processing pipeline; and transmitting the alert to facilitate correction activities.

Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating early detection and warning for system bottlenecks in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes detecting waits during processing of a query within a processing pipeline, wherein the waits include one or more of application-specific waits and database-specific waits; diagnosing the waits to identify a wait that has turned into a bottleneck; classifying one or more types of issues causing the wait to turn into the bottleneck; generating an alert having associated information detailing the issues based on the one or more types and a location of the wait within the processing pipeline; and transmitting the alert to facilitate correction activities.

Abstract: In accordance with embodiments, there are provided mechanisms and methods for facilitating early detection and warning for system bottlenecks in an on-demand services environment according to one embodiment. In one embodiment and by way of example, a method includes detecting waits during processing of a query within a processing pipeline, wherein the waits include one or more of application-specific waits and database-specific waits; diagnosing the waits to identify a wait that has turned into a bottleneck; classifying one or more types of issues causing the wait to turn into the bottleneck; generating an alert having associated information detailing the issues based on the one or more types and a location of the wait within the processing pipeline; and transmitting the alert to facilitate correction activities.

Abstract: Mapping of database partitions to available nodes. Metric information related to the partitions of the database are stored. One or more metrics associated with the partitions are gathered. A plurality of potential mappings of partitions to nodes are evaluated. One of the potential mappings of partitions to nodes to result in improved metric distribution among the nodes and the partition moves are within a pre-selected move constraint is selected. The selected potential mapping is implemented by moving one or more partitions between one or more nodes.