Excessive Database Usage - What is normal?
I am trying to gather some information about what is normal database activity for Altiris and also the tempdb
What we are seeing in our environment is the SQLServer: SQL Statistics: Batch Requests/Sec Counter is peeked constantly at 100% (see attached)
Also when we look at the temp database activity via Resource Monitor (Server 2008) we can see the Read/Write is around 4,800,000 (B/sec)
However we moved the temp database from local disk to the NAS (via SLAN) and this decreased performance as the NSA disk is slower.. when the temp database was on local disk the Read/Write is around 45,000,000 (B/sec)
So I am very interested to know how this looks on other peoples installations? is this normal activity for Altiris? or perhaps do we have a miss configuration?