What exactly classified as adhoc queries segment of the server dashboard report?



  • I am looking at a standard report -> server dashboard.

    More than 50% of the pie chart is classified as adhoc query.

    What exactly classified as adhoc queries segment of the server dashboard report?



  • Not sure what else your dashboard shows other than adhoc queries, check if https://devjef.wordpress.com/2012/02/10/comparison-ad-hoc-vs-stored-procedure-vs-dynamic-sql/ clarifies your question.


Log in to reply
 


Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2