Friday, September 07, 2007 12:17 PM
Hello, When I am seeing SQL Server 2005 Management studio Server Dashboard> I am seeing my(USERS) databases and msdb database usage is very small % of in CPU Usage(%), Logical IO Performed (%) Usage pie chart.
90% of Total cpu usage is showing for Adhoc Queries. what excatly this means in Dashboard? if application uses more than it would have shown in Database level or not?
sicerely this dashboard is good, if any one is watching daily, please advice their experiences here.
Thanks in advance. Hail SQL Server!
Saturday, September 08, 2007 6:24 AM
This means that of all the CPU and I/O performed 90% is coming from Adhoc Queries, it does not mean 90% CPU usage.
Visit my SQL Server weblog @ http://dis4ea.blogspot.com
Friday, March 16, 2012 2:35 AM
What is the definition of "Adhoc Queries" in SQL server 2008 R2 Server dashboard report in CPU usage area?
Friday, March 16, 2012 11:10 AMAs a very basic explanation they tend to be queries that are not rolled into stored procedures.
If you find this helpful, please mark the post as helpful,
If you think this solves the problem, please propose or mark it an an answer.
Please provide details on your SQL Server environment such as version and edition, also DDL statements for tables when posting T-SQL issues
My Blog: Http://SQL.RichardDouglas.co.uk