Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

General performance query for everyone using APM!

Hey everyone,

If people are happy to spend 5 minutes helping, I'm interested to see just how much 'detailed' APM Component data people have on their Orion instances.

The following query will count the rows in the NetPerfMon database:

USE NetPerfMon
SELECT COUNT(1) FROM APM_ComponentStatus_Detail

We currently have 35 million rows (our retention is 7 days for detailed), and whilst performance isn't too bad we do notice issues with this table, so I'm curious how far other people are pushing their instances.

Thanks,

Andy.

Find more posts tagged with

Accepted answers

All comments

FormerMember

Server1 - 4394182
Server2 - 807719
Server3 - 1055899
Server4 - 420875

cgregors

7,369,080

rsfh

73 million rows.. It's a pretty beefy SQL server.

FormerMember

Nice! Care to share the specs?

rsfh

Yep, it's a
Dell R710
2 x Intel(R) Xeon(R) CPU E5620 @ 2.40GHz Quad core
96gb RAM
2 x 146gb SAS 6gbps in raid 1 - OS
6 x 146gb SAS 6gbps in raid 10 -SQL
Win 2008 R2 Ent 64
SQL 2008 64

We've got 2 Orion db instances running on the server and the performance stats have been pretty good actually. The NPM/APM instance gets a 99.82 polling completion %, and the NPM/NCM/IPAM instance gets around 99.77 %. Disk queue length, Buffer cache hit ratio, latch waits/sec, etc all look very good as well.

FormerMember

Oooh interesting, we have the same server, although you have more RAM and local disks. Perhaps we should scale up a little if it can handle that many rows - we thought we'd hit a limit on SolarWind's end (for a single instance) at around 35 million rows.