0 Replies Latest reply on Feb 11, 2014 3:30 AM by vmotion

    Application Monitor

    vmotion

      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