Honestly your DB does most of the work. I've not seen out Pollers or main Orion box use hardly any resources and we have 10,000 elements on each. If I was in your situation I would upgrade the DB all they way!
Are you running a 32 or 64 bit version of Orion and what modules are you running? Interestingly enough, we are running a 32 bit version of Orion on an HP DL 585 with 16 GB of RAM with PAE active and are only seeing around 4 GB utilized. While we don't have all the modules completely configured, I'd also recommend putting the horsepower into your database server.
Database server for sure. Your poller looks to be fine for whatever you throw at it.
I am quite interested in your Orion Server setup you mentioned that handles multiple Orion Applications on the same box.
As said, your Orion Server is an HP DL 585 with 16 GB of RAM with PAE active.
Can we share details about your SQL Server for:
- Processors number / type /speed
- SQL Database / Log : how they are stored / spread ? Are you usning SAS disks ? 10 or 15K RPM disks ? how many ? RAID ? or are using SAN storage instead
- if SAN storage, then FC (Fiber Channel) or Directly (DAS). What FC speed, throughput ?