September is still one of the hottest months in the UAE with temperature averaging 39 degrees in Dubai. As September progresses however, temperatures start to gradually drop back down to more manageable levels.
Seeing any rain in September is unlikely.
In the mountains the temperatures are a little lower and temperatures at night can be feel cold once the sun has set. The desert also can be very cold at night, so warm clothing is essential.