Hi Mahon,
A valid question, let me explain - sometimes people argue and after a short period of time the arguement goes away and is forgotten, sometimes the arguement doesn't get forgotten so easily and sometimes it is brought up over and over again which is never a good thing and so in this example the idiom "let sleeping dogs lie" fits.....for example:
I know a couple of people who used to be very good friends, then one day they had an enormous arguement over something quite silly, now everytime they see each other they end up argueing over the same silly things, if they could just let sleeping dogs lie I'm sure that they could get back some of the friendship they had shared before.
This phrase can be used for any negativity that keeps coming back from a past action, worries, problems, fights etc...It's when we want to advise someone or tell ourselves to leave things in the past and move on. Hope this makes it clearer for you.
The second one is used when someone is doing something that we don't like in a way that it irritates and annoys us, it gets on our nerves, it makes us feel unsettled, for example: My younger son is full of energy, he doesn't stay still for a moment not even at meal times, sometimes I find it quite amusing but other times he drives me up the wall. (You can also say drives me round the bend or a simpler version is, he drives me mad or insane).
It means I can't always cope with this extreme amount of energy because sometimes I want peace and quiet and when he's like this, well, I just don't get it and so I become irritated and annoyed.