I don't have the 'Top 10 Most Expensive Queries' showing
sgilboy
Posts: 41
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?
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?
Comments
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?
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
Project Manager
Red Gate Software
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
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)
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
Project Manager
Red Gate Software
I was running version 2.2
thanks Priya for helping me out there.....
damn I feel stupid, lol
Priya
Project Manager
Red Gate Software