I don't have the 'Top 10 Most Expensive Queries' showing

sgilboy

So I was reading up on 'Brad's Sure Guide to SQL Monitor 2.3'

http://www.simple-talk.com/sql/sql-tool ... nitor-2.3/

On this screenshot: http://www.simple-talk.com/iwritefor/ar ... _large.png

there is the "Top 10 Most Expensive Queries" at the bottom of that page..

in our install and running instance of Monitor (which is the newest, 2.3), the information ends at the "Files" section (there is nothing but the end of the page below it): http://i51.tinypic.com/fut1z7.jpg

do I need to "turn on" the ability to see those queries like the guide shows?

sgilboy

was flipping through some of the docs and it says it doesn't work for SQL2000 server

the server we are monitoring is a SQL2008 R2 install with the Db's running currently in SQL2000 compat mode.... does Monitor treat that as 2000 across the board?

priyasinha

Hi,

SQL Monitor looks at the version of the SQL Server and if it is less than SQL Server 2005 then it doesn't run the queries. But since your version is SQL Server 2008 R2 and only the database is in SQL 2000 compatibility mode hence my guess would be that the queries are still being run for collection. Could you clarify few things:

1. The screen shot you have sent is at database level. Do you see any queries at the instance level under "Top 10 expensive queries".
2. There are certain criteria which queries have to satisfy in order for them to appear for this feature. This is documented in the help against "Top 10 expensive queries". Could you also verify if there are any queries which satisfy this criteria?

Thanks,
Priya

sgilboy

priyasinha wrote:

1. The screen shot you have sent is at database level. Do you see any queries at the instance level under "Top 10 expensive queries".

No, if I click the instance i get Host Machine, Databases, General, Memory, Server Properties, Buffer Cache, Latches and Locks, Host Machine, User SQL Processes (top 10 by CPU usage), and finally SQL Server Error Log

priyasinha wrote:

2. There are certain criteria which queries have to satisfy in order for them to appear for this feature. This is documented in the help against "Top 10 expensive queries". Could you also verify if there are any queries which satisfy this criteria?

I do not know where this "documented help" is.... if you mean the blue ? icon in this pic from the simple-talk article: http://www.simple-talk.com/iwritefor/ar ... _large.png , then keep in mind I don't even see that section at all (hence, no blue icon to click)

priyasinha

That's very strange. Because irrespective of whether this data is getting collected or not, you should always see this section. Could you please email me at priya.sinha@red-gate.com ... screen shots of the following pages.

1. SQL Server/ Instance Overview
2. Database Overview
3. Configuration > About page.

Please also send log files. They should be at C:\ProgramData\Red Gate\Logs\SQL Monitor 2 or equivalent location.

Thanks,
Priya

sgilboy

I was running version 2.2

thanks Priya for helping me out there.....

damn I feel stupid, lol

priyasinha

Don't worry. We all make such mistakes .

Priya