There are many methods you can achive this.

1) Go to run, type "perfmon". Add counter for CPU. This will give a graphical representaion of load on CPU.

2) If you want to check load of specific query on server, you can use profiler and check the CPU column.

3) You can also use DBCC SQLperf

HTH

sachin