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

Is there a way to query the CPU and memory utilization during business hours?

We're trying to find out which of our servers are over utilized (or under utilized) during the day. We can use performance manager in solarwinds to look server by server, but we need a way to look across hundreds of servers.

We're good at running SQL (we have a bunch of data analytics people), but we're still new at solarwinds reports.

Is there a way to pull the CPU information from each poll using a SQL query against the solarwinds database? What tables/views store this information? What about the memory information? I'm not sure what tables store the CPU and memory information coming back on each poll and it'd be awesome to be able to query it and produce some custom reports in PowerBI (or our analytics tool of choice).

Note: we're doing this analysis on servers that are used by humans, so we plan on excluding non-business hours data, hence the desire to just query the solarwinds database directly.

Thank you,

Nathan

Find more posts tagged with

Accepted answers

All comments

ctech291

I think I might have found the CPU information recorded at 5 minute increments in dbo.CPUMultiLoad_Detail . I'll keep searching for memory...

ctech291

I just found a view: dbo.CPULoad which seems to have CPU info and memory info. Unless someone says otherwise, I'm going to run with this.