I have searched the previous thwack discussions about monitoring your SQL instance with SAM and with large servers or instances the default thresholds threw critical alerts with the out of the box thresholds. I believe I'm having the same issue but unsure how to check. I'm looking to find a way to calculate what I should set my thresholds without set false alerts that the SQL is having issues. As the company does not have any actual SQL admins on payroll and I'm acting as an incidental SQL admin to insure our SW products function properly.
The flags that are coming up as critical that I'm concerned about are "Workfiles Created/sec" and "Worktables Created/sec" under the memory tab. Considering the VM has 900GB memory it is surprising that these are the alerts that triggered off the bat. There is only one instance on my SQL server and databases for Orion, NTA, and LA for running the following modules LA, NTA, NPM, NCM, SAM, SCM, UDT, VMAN.
