Query Text not showing in Azure SQL Analytics for SQL-Managed-Instance Database

• mphilippopoulos

  SSC Eights!

  Points: 846

  More actions

  November 30, 2022 at 9:33 pm

  #4120341

  Hi, I have configured a diagnostic setting to a Log Analytics Workspace for a database that is part of an Azure SQL Managed Instance. When checking top queries, I am able to see the query hash of each individual query when I drill down, but not the query text itself. Instead I am told to, for example:

  -- Get query text by connecting to database and executing the query below

  SELECT qt.query_sql_text query_text, q.query_hash

  FROM sys.query_store_query q

  JOIN sys.query_store_query_text qt

  ON q.query_text_id = qt.query_text_id

  WHERE q.query_hash = 0x29CF07BC6B275535

  This is not happening for Azure SQL Databases. The above instruction appears temporarily, but then the actual query text appears automatically in the same area of the screen.

  Has anyone else observed this behavior?

  • This topic was modified 2 years, 7 months ago by mphilippopoulos.

  Attachments:

  You must be logged in to view attached files.

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  December 1, 2022 at 10:10 pm

  #4120866

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.