none
CPU Usage(%), Logical IO Performed (%) Usage for Adhoc Queries is 90%

    Question

  •  

    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!

    Friday, September 07, 2007 12:17 PM

All replies

  • This means that of all the CPU and I/O performed 90% is coming from Adhoc Queries, it does not mean 90% CPU usage.

     

     

     

    WesleyB

    Visit my SQL Server weblog @ http://dis4ea.blogspot.com

    Saturday, September 08, 2007 6:24 AM
  • What is the definition of "Adhoc Queries" in SQL server 2008 R2  Server dashboard report in CPU usage area?

    Friday, March 16, 2012 2:35 AM
  • As 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

    Richard Douglas
    My Blog: Http://SQL.RichardDouglas.co.uk
    Twitter: @SQLRich

    • Proposed as answer by shiftbit Thursday, May 08, 2014 1:16 PM
    Friday, March 16, 2012 11:10 AM