Not sure what "best practice" is, but we swapped windows defender out for a more enterprise ready antivirus and then set up ignore rules on the databases as those get...

To clarify, when you say "16 GB" is that the memory allocated to the resource pool or to the Server?

Does your resource pool have enough space for that...

Another thing to watch for is Windows "Available" memory vs "Free" memory.  Available memory is Free + Cached and Cached doesn't get cleaned up all that quickly unless there is...

What tools are you using to build this out to display to end users?  And does the formula table change often?  If the formula table will change very infrequently or...

I am fairly confident that subscription processing is done in parallel.  We have a lot of report subscriptions that occur in parallel.

Is the 16 GB of RAM for...

Where we work, nobody releases their own code changes to live.  With source control, we have a "don't release your own changes to master" policy, but it does happen by...

I am assuming this is 1000 SSRS subscriptions.

On top of what Sue suggested, I would check for database growth of both tempdb and your report server database and log...

What is the default database of the linked server user on the linked server side?

Even if you are using the OPENQUERY method, you could try using 3 part...

Possibly an easier answer - convert User.id to a varchar.

edit - guess I shouldn't have left this open for a bit before answering... others beat me to that LOL.

reported as spam

reported as spam