In general, applications need to be specifically written to take a advantage of the cluster. However, some applications known as embarrassing parallel can take advantage of the cluster directly. Embarrassing parallel applications don't share any data; many instances of the application run on different nodes of the cluster working on their on set of data. You should first check with your ISV to see if their applications are available for Windows HPC Server 2008.
Pedro Manfredi