How to rectify SQL performance for developed dashboards?

After the creation of dashboards, if we get a problem from the SQL side it means Custom SQ. How to Rectify the SQL performance from custom SQL.