asked
What is the best way to get CPU Utilization?
Hi, Please help me to get a t-SQL query for finding high CPU Usage. Regards Murali
There's an old discussion on SQL Server Central forum, for a question just as vague as yours.
http://www.sqlservercentral.com/Forums/Topic611107-146-1.aspx Don't know if that would answer your question. Please be more specific when asking questions - that way it's easier to answer them. If the discussion above is useful for you, please be aware that at least in SQL Server 2014 the first query posted by "MarkusB" won't work - you need to replace cpu_ticks_in_ms with ms_ticks.
And did you then try to run the statements in the query separately, to find out which statement caused the overflow? Since I'm not getting an arithmetic overflow on my own system, it's rather hard to guess where it might have gone wrong on yours. Run the statements separately, break out the subqueries and run them separately, run the outer query without the subquery, run the outer query with just the calculation @ts_now-[timestamp] etc. Isolate the error and find out which statement causes the error, and then work from there. You probably need to cast some value to bigint prior to using it in a calculation. But as I said: Since I don't get any errors on my own system, I can't really guess which statement is causing the error on yours.
17 People are following this question.
