Influence of signal-to-noise ratio and point spread function on limits of super-resolution