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!
