search cancel

Need to get a list of all new QOS added for the last X number of days

book

Article ID: 242948

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

The database team contacted us because the UIM database is growing very quickly recently and trying to determine if it is related to the addition of new QOS items.

Environment

Release : 20.3

Component : UIM NAS

Resolution

These 4 queries build on each other, each giving a little more detail. They will give details on new QOS for the last 20 days:

select probe, count(*) from S_QOS_DATA where created > dateadd(day, -20, getdate()) group by probe;
select source, probe, count(*) from S_QOS_DATA where created > dateadd(day, -20, getdate()) group by source, probe;
select source, probe, qos, count(*) from S_QOS_DATA where created > dateadd(day, -20, getdate()) group by source, probe, qos;
select source, probe, qos, samplerate, count(*) from S_QOS_DATA where created > dateadd(day, -20, getdate()) group by source, probe, qos, samplerate order by samplerate;

This can help you determine where all the new growth of the database is coming from.

The last is helpful also in that it would give you high polling rated items. In other words if I added a bunch of items that I am polling at 30-60 seconds, would create a lot of new data in the database.

Finally this one is more targeted:

select source, probe, qos, samplerate, count(*) from S_QOS_DATA where created > dateadd(day, -20, getdate())
and probe = 'sqlserver'
group by source, probe, qos, samplerate order by samplerate;