Good morning everyone.I was wondering if someone could help. I have configured Application alerts to come from SQL Server, and I am receiving lots of Full scans\sec alerts coming from one of our SQL servers.I just do not know what to look for in the SQL to troubleshoot.
On the storage array (EMC VNX 5700) using esxtop and then going to the LUN level I can see that CMDS/s value is very high. Between 450-800 CMDS/s.
This SQL server has not been optimised at all. Someone else has installed it and I have to correct and troubleshoot. As I said not optimisation has been done (I have yet to run MS SQL Analyser, and other twicks).
If someone can help with this error.
Thank you very much