There is two aspects when it comes to HA for SSRS. The first one the data tier, which is the ReportServer database. You say the database is a member of...

You can go up in term of edition, but you can't go down.

I would be curious to know a business case that requires an upgrade from Express to...

I found this article and helped me to understand https://blogs.msdn.microsoft.com/clustering/2012/11/21/tuning-failover-cluster-network-thresholds/

Finally I found my issue : Parameter Sniffing issue.

Under certain circumstances, the values for FILEREFRECID were set to 0. It mean no more predicates for FILEREFRECID and leads to the...

Thanks,  I got the values:

DATASOURCE= 2 distinct values
DATATYPE = 5 distinct values
FILEREFRECID = 3820131 distinct values
AXMATCHINGCODE = 12 distinct values
DATAAREAID = 2 distinct values
PARTITION...

Thank you,

Any recommendations on the order of the columns ?

Thank you for the replies.

- As for now, I would like to find a solution without changing the query if possible.
- I changed the query in my...

Thanks Perry Whittle, you solution is much better !

Hi Steve,

You are right, I took a backup of the Service Master Key and restore it on the secondaries and it worked !

Thank you

Hey Thomas,

Yes it is! That's is my problem, do you know how it affects the backup/restore process ?

Hi guys, thank you for the answers.

I am not concerned about the 500GB empty file. I am concerned about the amount of committed/uncommited transaction in the log file.Let...

Hi,

I can tell you where I come from. Basically, I found a slow running query and I saw a RID Lookup in the execution plan. I know that...

Thank you,

What I do no not understand if that when I Google about how to get rid of Key Lookups, most of the solutions are Covering Indexes. I...

Thank you for your answer.

Assuming that I have a Clustered Index, is it possible to do a Clustered Index Seek instead of Key Lookup ? Does it make...

yes, I think you are right. Will do some homework and come back with results