I need to be able to query table in a sql database for a value less than 46. When that value is true, I want to send an alert. Are there any canned scripts available to use that will accomplish this task? Thanks in advance for any assistance.
Hello CEDee,you can use "SQL Server User Experience Monitor". Look at documentation here.
Write query that returns value you are looking for, set warning or critical thresholds appropriately and then set alert on warning or critical state for this component.
