Dispel Magic

Is a wall an object? Let's say there is a stone wall 20' high and 200' long. It's filled with hundreds of glyphs. Would one casting of Dspel Magic wipe them all out?

Quote from Itap88 >>

It's known how this affects spells. But what about magical effects that have a non-instantenous duration but are specifically not spells? Say, a druid is under the effect of wildshape or a twilight cleric is under the effect of steps of night. What if such effect is targeted?

Magical effects that aren't spells aren't affected by Dispel Magic.

It's important to keep in mind that the description, not the name, of a spell is what defines what the spell can do.

Quote from Damonies >>

Tried to use this to destroy a construct. Did not go well. 

 If a construct has some weakness to anti-magic it is usually just action restriction and not dismantling.

Quote from Caladrel >>

Quote from Lazuli1925 >>

Could this spell work on a permanent version of major image?

 Major Image states "At Higher Levels. When you cast this spell using a spell slot of 6th level or higher, the spell lasts until dispelled, without requiring your concentration." 

This explicitly states that it can be dispelled, which includes Dispel Magic. Most permanent effects (all if I'm not mistaken) have a duration of either Instantaneous, in which case they can't be dispelled, or Until Dispelled, such as the upcasting of Major Image or True Polymorph after an hour of concentration.

Could you give an example of a spell with a duration of Instantaneous that has a long-lasting spell?

Quote from MarsExplorer >>

Quote from Caladrel >>

Quote from Lazuli1925 >>

Could this spell work on a permanent version of major image?

 Major Image states "At Higher Levels. When you cast this spell using a spell slot of 6th level or higher, the spell lasts until dispelled, without requiring your concentration." 

This explicitly states that it can be dispelled, which includes Dispel Magic. Most permanent effects (all if I'm not mistaken) have a duration of either Instantaneous, in which case they can't be dispelled, or Until Dispelled, such as the upcasting of Major Image or True Polymorph after an hour of concentration.

Could you give an example of a spell with a duration of Instantaneous that has a long-lasting spell?

A good example is animate dead, where the spell ends instantaneously but the effect of the spell (i.e., animating a dead body) can last much longer.

DC 19 spellcasting check and you kill someone's wish. That's crazy. 

Quote from DVision >>

Does having proficiency with arcana help the DC?

It does not, from the source I looked into.

 You have proficiency with your spellcasting ability. 

Is this a way to get rid of Heat Metal?

The latter half of your question. 

As pointed out by some others the wording of "Any" can mean all that is currently buffing and/or debuffing ends.

However I want to bring your attention to how it's written. It says at the start to choose one, then you have a full stop at the end of the sentence. Then going on to say Any spell 3rd level instantly ends. This does not mean every spell 3rd level or lower. You are essentially getting to pick one spell if there are multiple on that creature. And if it is a 3rd level or below that you choose, it ends automatically. 

Counterspell is similar where cause the spell is 3rd level anything equal or below is ended/prevented without you having to make a Arcana check. 

If I can use an example. If I ask you to pick any colour you will most likely pick 1 colour. You are given a wide range of choice, but only can pick 1. As has been established with the first sentence. The Second sentence is merely letting you know how powerful Dispel Magic is that it can end 1/3 levels in an instant. 

Notice the second paragraph for up casting. It words "Spell" and "Spell's" but not the plural "Spells". 

As a side note, a DM or yourself if you are going to run a game may very well interpret Dispel to target all spells and that is your prerogative to do so. My explanation is an alternative answer for you.