from

https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-query-store-runtime-stats-transact-sql?view=sql-server-ver15

avg_cpu_time  - Average CPU time for the query plan within the aggregation interval (reported in microseconds).

Does  avg_cpu_time count  only  CPU time without counting any wait time for blocking...

consider adapting "sp_whoisactive"    as reporting tool

but read licence agreement  first 🙂 http://whoisactive.com/docs/03_license/

Pro SQL Server on Linux

Advanced Data Analytics Using Python

XML and JSON Recipes for SQL Server

Learn Data Analysis with Python

Beginning DAX with Power BI

Azure and Xamarin Forms

Practical Web Scraping for Data...

• This reply was modified 4 years, 9 months ago by  ebooklub.

Thanks everybody for help.

I  was assigned to project to check  why Batch processing  takes 100% of CPU

Using query store I found that during batch processing  job it calls from 50 ...

Perfect script !

Thanks a lot

Thanks everybody

I posted same question on MSDN forum and got answer from MS team

in short...  look into sys.dm_os_job_object   column  process_memory_limit_mb

bellow link to original post and answer from MS

https://social.msdn.microsoft.com/Forums/azure/en-US/911fca13-6a13-424e-b112-5bdc2113523e/correlation-of-dtu-and-ram-in-gb-allocated-to-db?forum=ssdsgetstarted

Hi, thank a lot for all suggestions,

close connection/work with dev team is good ,but  I am adapting to reality  🙂

Project is running in SQL azure ,I posted topic in 2016...

Thanks a lot for suggestions

Role and permission of dba in this project allow to use Query store (no extended events)

Dba might suggest and if needed create new indexes (preferably providing...

Query store capture long running query  for last 1 hr period  in following format

(@P1 bigint, @P2 bigint, @P3 bigint,  ...@P120 )select  Order_Id  from Orders where item_Id in (@P1, @P2, @P3...

• This reply was modified 4 years, 12 months ago by  ebooklub.
• This reply was modified 4 years, 12 months ago by  ebooklub.

Hi,

I should clarify it ,

1. usage of extended events , triggers ,e t.c  is not options. I can use only Azure portal and Query store(any changes to configuration of query...

Thanks a lot Jeff

I modified  query  to provide me overview of  DTA  statistic and indexes I  want/plan  to drop

SELECT

DB_NAME() as 'database name',

sc.name as 'schema',

so.name as 'table',

isnull(si.name,'*ORPHAN STAT*') as 'index name',

(

SELECT

USER_SEEKS+...

"Speak to your Exchange admin and ask them to allow external e-mails to be sent from Server2."

So External email could be restricted to particular IP?

Hi  Steve, 
 thanks for the tip "ARM templates", I used portal to add resources
 it takes some time get used to  ARM templates ,but I see that it will speed up...