1.

My Sql Query Is Running Very Slow, It Was Running Fine Yesterday What Should I Do?

Answer»
  • Check that your connection to the Greenplum cluster is still good if you are using a remote client. You can do this by RUNNING the SQL locally to the GP cluster.
  • Check that the system tables and user tables involved are not bloated or skewed. Read jetpack or Greenplum toolkit documentation about how to do this.
  • Check with your DBA that the Greenplum interconnect is still PERFORMING correctly.

This can be DONE by CHECKING for dropped packets on the interconnect “netstat -i” and by running gpcheckperf.It is also possible that a segment is experiencing HARDWARE problems, which can be found in the output of dmesg or in

/var/log/messages* (Linux) and /var/adm/messages* (Solaris).

This can be done by checking for dropped packets on the interconnect “netstat -i” and by running gpcheckperf.It is also possible that a segment is experiencing hardware problems, which can be found in the output of dmesg or in

/var/log/messages* (Linux) and /var/adm/messages* (Solaris).


Discussion

No Comment Found

Related InterviewSolutions