licensing is by processor not core I believe

http://www.microsoft.com/sql/howtobuy/multicore.mspx

Hi Matt,

I think you are looking in the right place. All I do is open SS Management studio right click the instance in question and look at the processor...

I work in a development shop, all of our SQL boxes have multiple instances of SQL Server. On the larger one we run 7 instances, a mix of 2000...

thanks for the response, unfortunately I don't think I have made myself clear in my orginal post.

I understand locking and how to generate the dead lock trace output in SQL...