公开(公告)号：US20210311938A1

公开(公告)日：2021-10-07

申请号：US17353009

申请日：2021-06-21

Applicant: salesforce.com, inc.

Inventor： Pratheesh Ezhapilly Chennen ,  Vishwajit Kumar ,  Siddharth Samant

IPC: G06F16/2453 ,  G06F11/34 ,  G06K9/62 ,  G06F11/30 ,  G06F11/32 ,  G06F16/25

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.

公开(公告)号：US11061894B2

公开(公告)日：2021-07-13

申请号：US16176992

申请日：2018-10-31

Applicant: salesforce.com, inc.

Inventor： Pratheesh Ezhapilly Chennen ,  Vishwajit Kumar ,  Siddharth Samant

IPC: G06F17/30 ,  G06F16/2453 ,  G06F11/34 ,  G06K9/62 ,  G06F11/30 ,  G06F11/32 ,  G06F16/25

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.

公开(公告)号：US20210406242A1

公开(公告)日：2021-12-30

申请号：US17469739

申请日：2021-09-08

Applicant: salesforce.com, inc.

Inventor： Robert Weber ,  Prateek Mathur ,  Pratheesh Ezhapilly Chennen ,  Sachin Mody ,  Ganesh Maganti

IPC: G06F16/22 ,  G06F16/21

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.

公开(公告)号：US11126608B2

公开(公告)日：2021-09-21

申请号：US15885654

申请日：2018-01-31

Applicant: salesforce.com, inc.

Inventor： Robert Weber ,  Prateek Mathur ,  Pratheesh Ezhapilly Chennen ,  Sachin Mody ,  Ganesh Maganti

IPC: G06F16/22 ,  G06F16/21

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.

公开(公告)号：US20190236174A1

公开(公告)日：2019-08-01

申请号：US15885654

申请日：2018-01-31

Applicant: salesforce.com, inc.

Inventor： Robert Weber ,  Prateek Mathur ,  Pratheesh Ezhapilly Chennen ,  Sachin Mody ,  Ganesh Maganti

IPC: G06F17/30

CPC classification number: G06F16/2291 ,  G06F16/21

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.