search

MicrosoftDocs / azure-docs

Open source documentation of Microsoft Azure
https://docs.microsoft.com/azure
Creative Commons Attribution 4.0 International
10.31k stars 21.49k forks source link

sys.resource_stats should be sys.resource_stats_raw? #33277

Closed SQLBrander closed 5 years ago

SQLBrander commented 5 years ago

When running some of the scripts with FROM sys.resource_stats don't work. I found however sys.resource_stats_raw. Probably not adjusted on this page?

Document Details

⚠ Do not edit this section. It is required for docs.microsoft.com ➟ GitHub issue linking.

KalyanChanumolu-MSFT commented 5 years ago

@SQLBrander Could you please post the scripts that didn't work for you? Since you mentioned sys.resource_stats_raw, are you using SQL Managed Instance?

SQLBrander commented 5 years ago

Hi,

Every script on that page that used sys.resource_stats.

I was not using managed instance as far as I know.

Sent from Ninehttp://www.9folders.com/

From: Kalyan Chanumolu notifications@github.com Sent: Friday, June 14, 2019 05:56 To: MicrosoftDocs/azure-docs Cc: Gé Brander (SQLBrander.com B.V.); Mention Subject: Re: [MicrosoftDocs/azure-docs] sys.resource_stats should be sys.resource_stats_raw? (#33277)

@SQLBranderhttps://github.com/SQLBrander Could you please post the scripts that didn't work for you? Since you mentioned sys.resource_stats_raw, are you using SQL Managed Instance?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHubhttps://github.com/MicrosoftDocs/azure-docs/issues/33277?email_source=notifications&email_token=AD6MIATB33DPCOHU6UJRIYDP2MJGNA5CNFSM4HX4NVJKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGODXVUP5I#issuecomment-501958645, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AD6MIAUFHKVDQ35M6H7JE5TP2MJGNANCNFSM4HX4NVJA.

KalyanChanumolu-MSFT commented 5 years ago

@SQLBrander sys.resource_stats_raw is specific to Managed Instance only. The article in question is Azure SQL Database. Please post the scripts that didn't work for you.

KalyanChanumolu-MSFT commented 5 years ago

We will proceed to close this issue now. If there are further questions regarding this matter, please comment and we will gladly continue the discussion.

josh-endries commented 3 years ago

I'm using a Hyperscale DB, and it doesn't have sys.resource_stats, only sys.resource_stats_raw. (As far as I know, it's not a Managed Instance database or server, just a "regular" Azure SQL database and server, on the Hyperscale tier.)

VladDBA commented 11 months ago

Hello,

It looks like this is still an issue. On Azure SQL DB the following query:

select * from sys.resource_stats;

throws the following error message:

Msg 208, Level 16, State 1, Line 1
Invalid object name 'sys.resource_stats'.

While sys.resource_stats_raw exists, but doesn't return any data (even though the query does run for a while).

This is on Azure SQL DB General Purpose Gen 5.

Thank you,

Vlad