Superb viewing, though only a couple of minutes long. Ideally, a first time visitor should spend a few hours going through the Dubai Mall and then evening onward see the fountains. When we went, the accompanying song and music was in Arabic, coud not understand the words, but nice on the ears. Crowds start growing before the show starts. The earlier you go, you are closer to the fountains. But if you are going to film it make sure your camera/ mobile phone is moisture reistant.
The day we went, it was very windy, and there was some moisture blown towards us though we were about 15 feet away.