search

amachanic / sp_whoisactive

sp_whoisactive
GNU General Public License v3.0
1.18k stars 290 forks source link

CheckCPUPercent/Capture WhoIsActive Data #74

Closed jdgleason01 closed 3 years ago

jdgleason01 commented 3 years ago

I installed the newest release of sp_WhoIsActive, but it broke an existing Capture WhoIsActive Data job triggered by the CheckCPUPercent Alert.

amachanic commented 3 years ago

I have no clue what a CheckCPUPercent Alert is. That sounds like something on your end. Can you share some more information on what, exactly, broke? Did you get an error? Invalid data? Etc?

jdgleason01 commented 3 years ago

Yes...sorry... I thought this was one of your processes but it obviously is not. I worked with another consultant who created an alert called CheckCPUPercent. Whenever the CPU gets over a certain percentage, this alert triggers a job that calls sp_WhoIsActive and loads into a WhoIsActive table. It errored with "Column name or number of supplied values does not match table definition.". I'm assuming you added one or more columns to the result set which caused the issue. I will fix this on my end so this can be closed. Thank you for all the work you put into sp_WhoIsActive... it is very helpful!