It sounds like you were CPU-bottlenecked, and since that is addressed, now you are memory constrained.

Are you using Enterprise Edition? What else do you have running on the VM?

92GB is...

https://aws.amazon.com/blogs/aws/new-gpu-powered-amazon-graphics-workspaces/

https://aws.amazon.com/pm/work

https://docs.aws.amazon.com/AWSEC2/latest/WindowsGuide/elastic-graphics.html

https://aws.amazon.com/blogs/compute/building-a-gpu-workstation-for-visual-effects-with-aws/

https://pages.awscloud.com/ec2-virtual-workstations-media-entertainment.html

Given a tally/number table or function (e.g., https://www.sqlservercentral.com/scripts/create-a-tally-function-fntally):

DECLARE @year INT = DATEPART(YEAR,GETDATE());

SELECT 
    DATEFROMPARTS(@year,Numbers.Number,1) AS FirstOfMonth, 
    DATEADD(month, DATEDIFF(month, 0, DATEFROMPARTS(@year,Numbers.Number,1)) + 1, -1) AS...

SQL Server has no idea where the logged-in user is - TSQL is execute on the server, not the client.

If you want this information for SQL Server, you will have...

You didn't post the function.

Right now, you're missing the entire query

🙂

You can eliminate irrelevant datatype columns using:

and columns.system_type_id IN (35,99,167,175,231,239,241,231)

hopefully you're not using sql_variant (98)

It should be possible. The stored procedure to create a subscription is ReportServer.dbo.CreateSubscription. You could either trace a call to the proc when creating a subscription via the RS Manager...

Depends on what your query is doing. Cast or Convert does whatever your query tells it to do.

If you are only using it in a select (only returning data), then...

Is it hidden? Look in Report > Manage > Properties

Use variables to determine the logic for the comparison values -- e.g.,

DECLARE @dayOfMonth int = DATEPART(DAY,GETDATE())
DECLARE @minDate DATETIME = CASE WHEN @dayOfMonth < 16 THEN DATEADD(mm, DATEDIFF(mm,...

Advantages of pre-allocation: Queries don't die when you suddenly run out of room in the middle of a transaction. No need to wait for file growth. No risk of something...

Are you doing index maintenance before the backup?

"so i have not taken a backup of the database, because it is not required as my Data balance plan is , balancing the data according."

And now you have no...

I liked Telerik reports when I was using it a few years ago. I haven't used it, but generally see good comments on DevExpress. Both appear to be...