How to write a query to identify common combinations of parameters used to call a stored proc?
You need to find all of the distinct groups of parameter values for a given proc, and then sort by the count of those groups.  Something like this:

SELECT 
    spc.Param1,
    spc.Param2,
    ...,
    spc.Param99,
    COUNT_BIG(*)
FROM dbo.StoredProcedureCall spc
WHERE
    spc.StoredProcedureName = 'sp_YourProc'
GROUP BY
    spc.Param1,
    spc.Param2,
    ...,
    spc.Param99
ORDER BY
    COUNT_BIG(*) DESC;


That would give the different parameters that sp_YourProc was called with, ordered from most common to least common.

If you don't care about the values, and you just want to know that certain combinations of parameters are being used, you could substitute static values like this:

SELECT 
    CASE WHEN spc.Param1 &lt;&gt; '' THEN 1 ELSE 0 END,
    CASE WHEN spc.Param2 &lt;&gt; '' THEN 1 ELSE 0 END,
    ...,
    CASE WHEN spc.Param99 &lt;&gt; '' THEN 1 ELSE 0 END,
    COUNT_BIG(*)
FROM dbo.StoredProcedureCall spc
WHERE
    spc.StoredProcedureName = 'sp_YourProc'
GROUP BY
    CASE WHEN spc.Param1 &lt;&gt; '' THEN 1 ELSE 0 END,
    CASE WHEN spc.Param2 &lt;&gt; '' THEN 1 ELSE 0 END,
    ...,
    CASE WHEN spc.Param99 &lt;&gt; '' THEN 1 ELSE 0 END,
ORDER BY
    COUNT_BIG(*) DESC;