Remember this fancy do-hickey?
It’s the Instance Viewer. We introduced it as a new feature in version 4.1.
For version 4.2, we added this – the Top SQL panel.
We ask the database every 10 seconds what the most expensive query by CPU is. Maybe that’s a bit too aggressive for you?
What if you only wanted to ask every…10 minutes?
You can do this.
You’ll want the Instance Viewer to be open and running, or the Metrics Console won’t display anything.
In the panel, select your connection and expand the Tree.
Look for your metric – the Top SQL one is easy to find 🙂
Right click, ‘Edit…’
Select your new time period.
Click ‘Ok’ and you’ll get a confirmation message, and you’re done.
This Is Also Available for Real Time SQL Monitoring
This is a brand new page we built for v4.2.
Maybe you don’t want to be so aggressive on updating the RTSM report details?
One Last Word on the Instance Viewer
There is another way to configure it.
Maybe you want to see more than the last 30 seconds of activity in the graphs? You could set it up to show the last 2 hours of IO.
Or, maybe you want to split the queries we’re running from one connection to 5 connections?
You can set both of these in the Preferences.