It can depend on the DreamScene. Some can use more resources than others. You can tell by looking in Task Manager under the Performance tab to see how much the CPU Usage is.
Another issue is that DreamScene needs to be installed first along with the DreamScene content packs in Windows Updates before the Vista SP1 is installed. Otherwise, they will not be available to install.