Getting Data In

Predict that the sql text will consume high resources

swetar
New Member

Hi everyone,
Req# Predict that the sql text running in the system will consume high resources.
I wanted to predict this based on the temp space and undo table space used by the query.
I am thinking to use Clustering algo.
Can anyone suggest me, which algo should I use.

Thanks

0 Karma

DavidHourani
Super Champion

Are you using MLTK ?

0 Karma

swetar
New Member

yes , I am using Splunk MLTK.
Is it recommended to do it with Clustering algorithm K-means

0 Karma

DavidHourani
Super Champion

yeah that makes sense if you have multiple queries and you wish to classify them, is that what you're trying to achieve ?

0 Karma

swetar
New Member

Yes there will be multiple queries. I wanted to classify bad sql ( bad sql meaning, sql which are going to consume more than 80% temp or consuming high io)

0 Karma

DavidHourani
Super Champion

In that case try BDSCAN could be better than fitting into a set number of clusters.
https://docs.splunk.com/Documentation/MLApp/4.3.0/User/Algorithms#DBSCAN

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...