STRDBMON field qq1000 is blank

[jj_dahlheimer]

We are running into performance issues with our website and they want to blame our system so we have been using the plan cache to look at a few things and today we did a DBMON and I was trying to get a count of which statements they are running the most and the most run sql statement is blank. I am assuming I am doing something wrong. I guess the question is do I just ignore where qq1000 is blank or is there something else going on.

select sum(ifnull(qvp15f,1)),qq1000 
from misjssql/qzg0000612            
where qqjnum = 294643               
and qqrid = 1000                    
group by grouping sets ((),(qq1000))
order by sum(ifnull(qvp15f,1)) desc

[jj_dahlheimer]

Re: STRDBMON field qq1000 is blank

Looks like all the blank ones are fetch records and it looks pretty consistent, it does an prepare, open, fetch, and then close. The fetch does not have a sql statment value in qq1000. So I am thinking if I do a count based only on the prepare or open record that would give me an accurate count of the statements they are running.