Very slow Refresh on large database
I have a fairly large database/data warehouse that I use to performance tuning. (250 GB)
When I try to use SCA on this database, it takes a very long time (sometimes it fails).
I pinned pointed the issue with a query running on a large table.
The table has 400 millions rows, so I understand that it would be slow... but SCA is not doing the same kind of query on any other tables that have as many rows in it.
The slow query scans the whole table with this (found using sp_blitzWho):
SELECT F_MEASURE_KEY, F_MEASURE_ID, cast ([F_PARTITION_DATE] as varbinary(max))<br>FROM T_DIM_MEASURE<br>Data from this table is not synced only the schema is.
I'm trying to understand why SCA is doing this, is there a way I can prevent it?
Please let me know if you need more information,
0 · Share on Twitter