For our ~400 client environment, it was recommended that we go with 4 Core 16GB RAM for VM for the NS/MP with DS, NOT including SQL 2008.
For a standalone SQL box (on VM), 8-16GB RAM and 4 core was recommended for our environment.
Also, dedicated hardware for the VM's was recommended (no resource sharing).
Is it possible for your to have a separate SQL VM? If not, you may need to be prepared to allocate more resources to the NS if you see performance degradation. Also, it could help to have a second server that acts as a site server to take off some of the package server/task server load if you find that the NS can't keep up.
Symantec stressed separate controllers for SQL drives on VM's as an important factor for NS peformance since disk I/O is very high for this product w/regard to SQL. Also, VM for SQL in an NS environment is not recommended but is supported. Given this, I think it is really compelling to have a separate VM for it. Moving the DB off after the fact could be very troublesome.
In the end, though, I think it really depends on how much you do w/Altiris. If you do some imaging on occasion and minimal software deployments/policies, I'm willing to bet you'd probably be alright for the most part. If you automate a lot of things through altiris, do a high frequency of inventories, etc. then you could run into issues.