Linux Performance Counters Statistics

Monitor your Linux Performance

Performance scanning is very important when it comes to managing your network and its users. When users start complaining about things being slow, performance counters make it easier than ever to locate the cause. Identify which servers or workstations are overloaded and don't have enough resources. Additionally, migration projects can also use performance counters. Determine how much resources your servers need to so you can set the correct requirements for a cloud or virtual migration project.

This overview shows Linux machines and their performance statistics from the last 30 days along with the minimum, maximum and average values for CPU usage, RAM utilization, disk usage and network utilization.

Linux performance statistics last month

Performance Statistics Linux last 30 days Query

Select Top 1000000 a.AssetID,
  Min(a.AssetName) As AssetName,
  Min(a.Domain) As Domain,
  Min(Coalesce(os.Image, at.AssetTypeIcon10)) As icon,
  Min(a.IPAddress) As IPAddress,
  Min(ipl.IPLocation) As IPLocation,
  Min(ac.Manufacturer) As Manufacturer,
  Min(ac.Model) As Model,
  Min(ls.OSRelease) As OsName,
  Min(a.Lastseen) As Lastseen,
  Min(a.Lasttried) As Lasttried,
  Min(pcm.Name) As MetricName,
  Min(pcm.Unit) As Unit,
  Round(Cast(Avg(pcsm.Value) As float), 0) As Average,
  Min(pcsm.Value) As MinValue,
  Max(pcsm.Value) As MaxValue,
  Min(pcsmi.Name) As Identifier
From tblAssets a
  Inner Join tblAssetCustom ac On a.AssetID = ac.AssetID
  Inner Join tsysAssetTypes at On at.AssetType = a.Assettype
  Inner Join tsysIPLocations ipl On ipl.LocationID = a.LocationID
  Inner Join tblState On tblState.State = ac.State
  Left Join tsysOS os On os.OScode = a.OScode
  Left Join tblLinuxSystem ls On ls.AssetID = a.AssetID
  Inner Join tblPerformanceCountersScan pcs On pcs.AssetId = a.AssetID
  Inner Join tblPerformanceCountersScanMetric pcsm On
    pcsm.PerformanceCountersScanId = pcs.Id
  Inner Join tsysPerformanceCounterMetric pcm On pcm.Id = pcsm.Metric
  Left Join tblPerformanceCountersScanMetricIdentifier pcsmi On
    pcsmi.Id = pcsm.PerformanceCountersScanMetricIdentifierId
Where tblState.Statename = 'Active' And pcs.ScanDateTime > GetDate() - 30 And
  a.Assettype = 11
Group By a.AssetID,
  pcm.Id,
  pcsmi.Id
Order By AssetName,
  MetricName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting