SQL Server 11.0.3401 - CPU 100% - HELP

If on Enterprise Edition, check the 'max degree of parallelism'; it's possible that large tasks are using all cpus unless that value has been adjusted.  Also check the cost threshold for parallelism; the default is too low, which causes excessive CPU usage also.

Running Standard Edition, also noticed that its on SP1 and current SP is SP3. Worth upgrading?

Where would I locate this setting you have mentioned?

EXEC sp_configure 'cost threshold for parallelism'

That's an advanced option; if advanced options are not on, we'll have to add code to allow you to see it.

SQL Server has a standard report on "Top 10 CPU Usage", average and total.  Right-click on the instance in SSMS, select "Reports", "Standard Reports", etc.

And/or you can run this query:

SELECT TOP 50
 [Average CPU used] = total_worker_time / qs.execution_count,
 [Total CPU used] = total_worker_time,
 [Execution count] = qs.execution_count,
 [Individual Query] = SUBSTRING (qt.text,qs.statement_start_offset/2,
         (CASE WHEN qs.statement_end_offset = -1
            THEN LEN(CONVERT(NVARCHAR(MAX), qt.text)) * 2
          ELSE qs.statement_end_offset END -
qs.statement_start_offset)/2)
,[Parent Query] = qt.text
,DatabaseName = DB_NAME(qt.dbid)
FROM sys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle) as qt
ORDER BY [Average CPU used] DESC;

EXEC sp_configure 'cost threshold for parallelism'

Msg 15123, Level 16, State 1, Procedure sp_configure, Line 62
The configuration option 'cost threshold for parallelism' does not exist, or it may be an advanced option.

EXEC sp_configure 'show advanced options', 1
RECONFIGURE
EXEC sp_configure 'cost threshold for parallelism'
EXEC sp_configure 'show advanced options', 0
RECONFIGURE

name      minimum      maximum      config_value      run_value
cost threshold for parallelism      0      32767      5      5

What does this mean?