Viewing 13 posts - 16 through 28 (of 28 total)
Let me re-iterate the issue:
1. I have the same INSTANCE running on the virtual box
2. I have two databases restored on that box next to each other
3....
October 18, 2018 at 3:06 pm
Schedule 175982 45016 KB 22904 KB 21928 KB 184 KB
Schedule 179796 46136 KB 23384 KB 22344 KB 408 KB
Many thanks for the wonderful picture DesNorton, but again - my actual number...
October 18, 2018 at 2:58 pm
October 18, 2018 at 1:45 pm
October 18, 2018 at 12:50 pm
Actual number of rows is very similar (within 10% difference) Something is the counters is giving me the feelings that buffer read is involved but what and how - no...
October 18, 2018 at 12:41 pm
That is another interesting observation - the actual number of rows : EXEC sp_spaceused 'ActivityInstance'
ActivityInstance 217136 59520 KB 52888 KB 6312 KB 320 KB
ActivityInstance 219209 ...
October 18, 2018 at 12:36 pm
Sure : Here is the set of actual execution plans per your request. Many thanks Michael for your time
October 18, 2018 at 12:06 pm
That is a freshly loaded DEV / STG Box all statistics are fresh and indexes are rebuilt , buffers are cleaned and cache is free before each execution since that...
October 18, 2018 at 11:13 am
And here is the SHOWPLAN_ALL txt format
October 18, 2018 at 10:56 am
Many thanks SSC Guru for your reference. Yes these objects (physical tables) even they are fairly alike...
October 18, 2018 at 10:20 am
The ObjectVersion value of the cube is an internal numeric value that is used for isolation management and cannot be changed. We are using the hard coded version for attach...
May 19, 2010 at 11:00 am
Just FYI
I am using SSAS 2008 SP1 CU6 Build 10.0.2757
May 12, 2010 at 9:20 am
Viewing 13 posts - 16 through 28 (of 28 total)