the default value for QueryLogSampling is 10, and it worked as expected that 1 out of every 10 queries was logged in the table. i then set the value to 1, hoping to capture every queriy, however, no new records were inserted into the log table.
i changed the value to 2, it alse worked as expected.
so i wonder whether 1 is not a valid value for QueryLogSampling in SSAS2008.
BI, Data Mining, Analytical CRM
View Complete Post