17 Replies Latest reply on Oct 8, 2009 2:57 PM by jeff.stewart

    Monitoring Orion for Performance?

    ecornwell

      Hello,

      I opened up a case because I noticed I was missing some data and the web interface felt slow.  I've seen others post on this topic but I've never really found what I've needed.  As part of the case, I was told it looks like the problem might be because of the database.  I've seen the system requirments and we currently don't follow a few of them.

      1. The DB Server is a VM.
      2. The DB/VM was on local storage which was RAID 5
      2a. We moved the VM to our SAN. 

      Moving to the SAN seemed to help a bit but not as much as I was hoping.

      I'd like to be able to show proof that we are really running into a problem but I'm not sure what to monitor.  I'm no MSSQL expert and we don't really have anyone on staff that is a true expert in it either. 

      We have APM and I'd like to be able to use it and NPM to really show that there is a problem if there is one.  Can anyone give me a good place to start monitoring and what to look for?  

      We have the server monitored with NPM and we've used the default APM monitor for MSSQL 2005 server but I don't really know what I'm looking at and what values are important.

      Thanks!