Viewing 15 posts - 226 through 240 (of 260 total)
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
thanks Phil. I couldnt see how to author the sequence command along with the refresh format i showed in the original post. I think MS is telling us that only...
February 20, 2024 at 8:45 pm
my thought was that a "thread" would lessen the chance of a memory error. And that that was one of the tricks out there for getting around some memory issues. ...
February 20, 2024 at 6:12 pm
thanks, does anybody have access to enterprise? The reason i ask is that there was a time when you had to use a backdoor thru multidimensional to achieve this form...
February 20, 2024 at 5:36 pm
thx Eirikur,
throttling in this context means he gets some relatively lower priority if we go with a "live experience". That (live experience) should have been clear from the original post. ...
February 20, 2024 at 5:32 pm
thx frederico. we are doing a process full at the moment. going to read your link which probably contains the guidance phil was giving also. it would have been so...
February 19, 2024 at 1:38 pm
thx Jeff for your time. Unfortunately the reports needing the data are operational. So the data they need is pretty detailed. So the volume is going to be a factor...
February 19, 2024 at 1:29 pm
thx phil
February 18, 2024 at 2:56 pm
Viewing 15 posts - 226 through 240 (of 260 total)