The second derivative is mainly used to find concavity. If the second derivative is positive, the function is concave up. If it is negative, the graph is concave down.
The second derivative can also be used to test critical points. If the graph is concave up at the critical point, the critical point must be a minimum. If it is concave down, the critical point must be a maximum.