This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

SQL script

hello- first time using solarwinds SAM and running into problem with creating alerts for my SQL server to get notification regarding problems with sql databases, sql backups,etc. the alerts comes through but not getting the full detail information IE objects that are trigger,etc.

any help would be appreciated.   see alerts notification email below.

An issue on an object you are monitoring occurred at Tuesday, May 12, 2015 1:30 PM.

AppInsight for SQL: Database paragon_test_hold
Critical

All Databases(Critical), Top Active Sessions with Statistics(Up), Top Expensive Queries(Up), SQL Agent Job Info(Critical), SQL Server Events(Up), SQL Server(Warning), SQL Server Agent(Up), SQL Server VSS Writer(Up), SQL Event Log Monitor(Up), Buffer Cache Hit Ratio(Up), Cache Used/Min(Up), Page Splits/Batch Request(Up), Lazy Writes/sec(Up), Free list stalls/sec(Up), User Connections(Up), Active Sessions(Up), Inactive Sessions(Up), System Sessions(Up), User Sessions(Up), Logins/sec(Up), Logout/sec(Up), Lock Requests/sec(Up), Lock Waits/sec(Up), Lock Timeouts/sec(Up), Average Latch Wait Time(Up), Average Lock Wait Time(Up), Deadlocks/sec(Up), Lock Wait Time(Up), Total Server Memory(Up), Target Server Memory(Up), SQL Cache Memory(Up), Lock Memory(Up), Optimizer Memory(Up), Connection Memory(Up), Memory Grants Pending(Up), Workfiles Created/sec(Up), Worktables Created/sec(Up), Cache Hit Ratio(Up), Page Reads/sec(Up), Page Writes/sec(Up), Page Splits/sec(Up), Page Life Expectancy(Up), Free pages(Up), Total Pages(Up), SQL Compilations/sec(Up), Full Scans/sec(Up), Batch Requests/sec(Critical), Average Disk sec/Write(Up), Average Disk sec/Read(Up), Physical Disk Time(Up), Page Faults/sec(Up), Pages/sec(Up), Available MBytes(Up), Page Usage(Up), Database Pages(Up), Longest Transaction Running Time(Up), Granted Workspace Memory(Up), Probe Scans/sec(Up), Range Scans/sec(Up), Auto-Param Attempts/sec(Up), Failed Auto-Params/sec(Up), Cache Object Counts(Up), Cache Objects in Use(Up), Memory Grants Outstanding(Up), Page Lookups/Batch Request(Up), Compilations/Recompilations/Sec(Up), Plan Re-Use(Up), Forwarded Records/Batch Requests(Up), Total Latch Wait Time/Latch Waits(Up), Recompilations/Compilation(Up), Target - Total Server Memory(Up)All Databases(Critical), SQL Agent Job Info(Critical), SQL Server(Warning), Batch Requests/sec(Critical)