What does SSRS technically do when it expires the cache?Loading subscription slow in SSRSUse Group Managed...
3.5% Interest Student Loan or use all of my savings on Tuition?
Called into a meeting and told we are being made redundant (laid off) and "not to share outside". Can I tell my partner?
Dukha vs legitimate need
Learning to quickly identify valid fingering for piano?
Can a Mexican citizen living in US under DACA drive to Canada?
Effect of "wrong" driver with slightly long RS-485 stubs
Did Amazon pay $0 in taxes last year?
Was it really inappropriate to write a pull request for the company I interviewed with?
Should I use HTTPS on a domain that will only be used for redirection?
How will Occam's Razor principle work in Machine learning
Adding thousand separator to various number types
How does insurance birth control work in the United States?
The orphan's family
Sundering Titan and basic normal lands and snow lands
How can I be pwned if I'm not registered on the compromised site?
Is there a math equivalent to the conditional ternary operator?
Is every open circuit a capacitor?
Ultrafilters as a double dual
In the world of The Matrix, what is "popping"?
What is the meaning of "producing negative zeroes" in a system that doesn't support it?
Giving a talk in my old university, how prominently should I tell students my salary?
How to close up the table border in a multi-row situation?
How to concatenate two command in shell
“I had a flat in the centre of town, but I didn’t like living there, so …”
What does SSRS technically do when it expires the cache?
Loading subscription slow in SSRSUse Group Managed Service Account for SSRSMultiple databases in productionReverting Compatibility Mode 120 to 100Changing row colour based on a group toggle - SSRS 2014SSRS : Bug using SSL (https://)'Refreshing' SSRS subscriptions (parameter values not valid due to lack of data in the tables)Collation Conflict when patching SSRSReport Server Reports HangingSSRS Error: The report server cannot decrypt the symmetric key
Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a schedule - a schedule that is triggered at the end of our daily load. This is simple.
Where it gets complicated is I have a cache refresh plan to pre-load the cache for all 100 sites. I need to make sure the cache expires before this plan runs - a plan that is tied to a schedule I want to trigger at the end of our load.
If I trigger the jobs, in order, at the end of the load, they are effectively triggered together, so I would like to understand what happens on the system level when SSRS expires a cache so that I can ensure the refresh occurs after the expiration. Is there a value in one of the ReportServer tables that is changed or a row deleted?
For what it's worth, this is what I am seeing in my testing (the cache is successfully pre-loaded), but I would like to understand the technical architecture to give myself a better comfort level before using this in production.
sql-server ssrs ssrs-2014
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
add a comment |
Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a schedule - a schedule that is triggered at the end of our daily load. This is simple.
Where it gets complicated is I have a cache refresh plan to pre-load the cache for all 100 sites. I need to make sure the cache expires before this plan runs - a plan that is tied to a schedule I want to trigger at the end of our load.
If I trigger the jobs, in order, at the end of the load, they are effectively triggered together, so I would like to understand what happens on the system level when SSRS expires a cache so that I can ensure the refresh occurs after the expiration. Is there a value in one of the ReportServer tables that is changed or a row deleted?
For what it's worth, this is what I am seeing in my testing (the cache is successfully pre-loaded), but I would like to understand the technical architecture to give myself a better comfort level before using this in production.
sql-server ssrs ssrs-2014
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
Only way I understand you can manually delete reports from the cache is through the SOAP API for SSRS. msdn.microsoft.com/en-us/library/ms155927.aspx#Anchor_1
– Shawn Melton
Nov 18 '15 at 5:33
add a comment |
Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a schedule - a schedule that is triggered at the end of our daily load. This is simple.
Where it gets complicated is I have a cache refresh plan to pre-load the cache for all 100 sites. I need to make sure the cache expires before this plan runs - a plan that is tied to a schedule I want to trigger at the end of our load.
If I trigger the jobs, in order, at the end of the load, they are effectively triggered together, so I would like to understand what happens on the system level when SSRS expires a cache so that I can ensure the refresh occurs after the expiration. Is there a value in one of the ReportServer tables that is changed or a row deleted?
For what it's worth, this is what I am seeing in my testing (the cache is successfully pre-loaded), but I would like to understand the technical architecture to give myself a better comfort level before using this in production.
sql-server ssrs ssrs-2014
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
Our data is loaded daily. My report can be run, using a parameter, for any number of sites (100 is the total number of sites) and I want it to cache a temporary copy of the report and expire it on a schedule - a schedule that is triggered at the end of our daily load. This is simple.
Where it gets complicated is I have a cache refresh plan to pre-load the cache for all 100 sites. I need to make sure the cache expires before this plan runs - a plan that is tied to a schedule I want to trigger at the end of our load.
If I trigger the jobs, in order, at the end of the load, they are effectively triggered together, so I would like to understand what happens on the system level when SSRS expires a cache so that I can ensure the refresh occurs after the expiration. Is there a value in one of the ReportServer tables that is changed or a row deleted?
For what it's worth, this is what I am seeing in my testing (the cache is successfully pre-loaded), but I would like to understand the technical architecture to give myself a better comfort level before using this in production.
sql-server ssrs ssrs-2014
sql-server ssrs ssrs-2014
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
edited Mar 22 '16 at 15:20
Paul White♦
52.9k14281457
52.9k14281457
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
asked Nov 17 '15 at 16:40
JHFBJHFB
1,60442760
1,60442760
Only way I understand you can manually delete reports from the cache is through the SOAP API for SSRS. msdn.microsoft.com/en-us/library/ms155927.aspx#Anchor_1
– Shawn Melton
Nov 18 '15 at 5:33
add a comment |
Only way I understand you can manually delete reports from the cache is through the SOAP API for SSRS. msdn.microsoft.com/en-us/library/ms155927.aspx#Anchor_1
– Shawn Melton
Nov 18 '15 at 5:33
Only way I understand you can manually delete reports from the cache is through the SOAP API for SSRS. msdn.microsoft.com/en-us/library/ms155927.aspx#Anchor_1
– Shawn Melton
Nov 18 '15 at 5:33
Only way I understand you can manually delete reports from the cache is through the SOAP API for SSRS. msdn.microsoft.com/en-us/library/ms155927.aspx#Anchor_1
– Shawn Melton
Nov 18 '15 at 5:33
add a comment |
1 Answer
1
active
oldest
votes
I see that it's an old thread but you can essentially have different Shared Schedules to expire and refresh the cache executed in that order to solve the problem.
answered 6 mins ago
DataDivyDataDivy
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f121367%2fwhat-does-ssrs-technically-do-when-it-expires-the-cache%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
I see that it's an old thread but you can essentially have different Shared Schedules to expire and refresh the cache executed in that order to solve the problem.
answered 6 mins ago
DataDivyDataDivy
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I see that it's an old thread but you can essentially have different Shared Schedules to expire and refresh the cache executed in that order to solve the problem.
answered 6 mins ago
DataDivyDataDivy
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
I see that it's an old thread but you can essentially have different Shared Schedules to expire and refresh the cache executed in that order to solve the problem.
answered 6 mins ago
DataDivyDataDivy
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
I see that it's an old thread but you can essentially have different Shared Schedules to expire and refresh the cache executed in that order to solve the problem.
answered 6 mins ago
DataDivyDataDivy
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 6 mins ago
DataDivyDataDivy
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
answered 6 mins ago
DataDivyDataDivy
1
answered 6 mins ago
DataDivyDataDivy
1
1
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
DataDivy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
add a comment |
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f121367%2fwhat-does-ssrs-technically-do-when-it-expires-the-cache%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Only way I understand you can manually delete reports from the cache is through the SOAP API for SSRS. msdn.microsoft.com/en-us/library/ms155927.aspx#Anchor_1
– Shawn Melton
Nov 18 '15 at 5:33