Q: Why SQL function: ObjIDUpdate() takes long time to execute when ROLAP SSAS cubes are used?
Q: On environment where you have ROLAP SSAS cube setup, we noticed that SQL server function "ObjIDUpdate()" takes long time to execute - from 30second up to 30min and some time even more. Does this indicate that there are some problems with our system? Our ROLAP cube has notification set to "Tracking Tables". SSAS service account is a sysadmin on the SQL Server.
A: This is normal behaviour. This is a query that waits infinitely for notifications from the tables that have been setup for SQL notification. It will end sometimes due to a timeout or a cancellation if other operations occur, but in general you will see it constantly waiting.