Chris Harshman (11/16/2016)
to find out what's hurting your CPU is a different problem, you'll probably want to examine the dynamic management views to see what queries are causing the most CPU, such as the worker columns in sys.dm_exec_query_statshttps://msdn.microsoft.com/en-us/library/ms189741(v=sql.110).aspx
I have been looking through the dmvs but there is not one specific thing im pretty sure its the number of adhoc requests and compilations required due to no existing plans thats driving up the CPU.