As Helen mentioned, just because you have two CPU doesn't mean that they will be used by SQL Server every time. If the DB engine determines that it can accomplish the task using one CPU, then there's no need for it to split the task across the two CPUs.

One thing you might try is to run a union query on one of the larger tables in the database. Generally the query optimiser will split the union into to seperate queries that run on each CPU.