Viewing 15 posts - 226 through 240 (of 267 total)
i systematically changed one thing at a time. Eventually just running the sub report by itself after each change. I'm convinced its the sub report creating the problem. But after...
March 19, 2024 at 4:39 pm
thanks frederice, deubel, jeffrey.
February 28, 2024 at 4:23 pm
they arent only ssis Jeffrey but your points are still well taken. All of our packages are versioned , in the catalog and at the moment set with some very...
February 23, 2024 at 9:38 pm
apparently clearing means its gone unless you plan to reprocess. its a catch 22.
for me right now this is ok because nobody uses the 1 gig cube anyway.
i'm guessing that...
February 23, 2024 at 7:56 pm
what i did in response to frederico's post was add a clear step on our 3rd cube prior to the dim table level sequenced refreshes (was step 1) and fact...
February 23, 2024 at 7:40 pm
thx Jeffrey, i thought it was going to be something more sinister. You hit it on the head. Funny thing is because of configs each of the 3 pkgs that...
February 23, 2024 at 7:10 pm
thx folks, but has anybody seen the unwanted byproduct of changing a step (eg different step to go to next etc) while right on the server? I believe what is...
February 23, 2024 at 5:16 pm
thx frederico. you should have seen somewhere me saying clear didnt help. Neither did doing table by table after the clear. Neither did splitting the dim refreshes into one step...
February 23, 2024 at 2:28 pm
what we saw before the processing started was ssas using about 10 gig for nothing specific that we know about. I think that's where it is always at rest. When...
February 22, 2024 at 9:04 pm
thanks Ed. Do you believe that 16 gig to be db sizes on disk or maybe total available (to ssas) ram?
Our 3 tabular model dbs total about 5 gig in...
February 22, 2024 at 2:26 pm
we tried your idea Ed B, thank you. I think its going to help in the long run. At the same time we temporarily decreased sql server's (the engine) high...
February 21, 2024 at 8:49 pm
it appears to run.
{
"sequence": {
"maxParallelism": 1,
"operations": [
{
"refresh": {
"type": "clearValues",
"objects": [
{
"database": "MyDB"
}
]
}
},
{
"refresh": {
"type": "full",
"objects": [
{
"database": "MyDB",
"table":"Table1"
}
]
}
},
{
"refresh": {
"type": "full",
"objects": [
{
"database": "MyDB",
"table":"Table2"
}
]
}
},
{
"refresh": {
"type": "full",
"objects": [
{
"database": "MyDB",
"table":"Table3"
}
]
}
},
{
"refresh": {
"type": "full",
"objects": [
{
"database": "MyDB",
"table":"Table4"
}
]
}
},
{
"refresh": {
"type": "full",
"objects": [
{
"database":...
February 21, 2024 at 7:22 pm
it used to be that you could see on the page itself what versions of sql a particular subject applied to. Now its more of a mystery. when i get...
February 21, 2024 at 5:14 pm
hold the phone. I havent tried it yet but here is a link that explains how to mix sequence and refresh. I have to stare at the curly braces to...
February 21, 2024 at 3:10 pm
no problem. I moved the memory part of the discussion to a different thread. And i'll mark your post here as an answer.
February 20, 2024 at 9:10 pm
Viewing 15 posts - 226 through 240 (of 267 total)