Is there a way to enable/configure alerts for blocking and long running sessions alert on SAM for SQL server.
Is there a way to enable/configure alerts for blocking and long running sessions alert on SAM for SQL server.
Yes,deadlocks and such should be included in the out-of-the-box alert "Alert me when a component goes into warning or critical state". You can however create a more specific targeted alert for such conditions as shown below.
Similarly, you can do the same for long running queries. The below example is fairly broad, but can be made more narrowly focused to alert only on specific queries, individual hosts, etc.
thanks for your reply. I may be asking a dumb question I am new to solar winds can you provide details how to configure alert and go to the screen shot you gave
The screenshot above comes from SAM 6.2 which features a new web based alert manager. If you're not yet running SAM 6.2 I recommend upgrading by downloading the latest version from your Customer Portal. Once you're running SAM 6.2 you will find the new Web Based Advanced Alert Manager under [Settings -> Manage Alerts].
we are using 6.1.1 let me upgrade and see if that helps
Is this built into AppInsight for SQL?
Has anyone gotten alerting for blocking to work successfully? If yes, can you share your alert trigger screen showing this?
I've created a custom template to monitor and alert on blocking. Component type is "Component counter monitor", Category: SQLServer:General Statistics, Counter: Processes blocked.
Will upload the template as soon as I figure out how to do it
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK© online community. More than 180,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process.