if we have resource pools defined but not used or assigned to an existing user, does it use available memory?
It would only use memory if you assigned it a MEMORYSIZE. That's reserved memory, and would be used by the resource pool, regardless of whether queries were running in it or not.
That depends on how you defined the resource pool, if assigned memorysize only, then it will reduce capacity of total , if assigned maxmemorysize only (memorysize is 0), it does not and will borrow from general pool when needed.
thank you for clarifying that.
on a different topic, we have a constantly running etl processes on some tables that have data from the traffic across entire network. I have analyze scheduled to run every 15 minutes but was told that might be creating more issues. What is a rule of thump for constantly changing data tables.
axnels2, are you asking about how frequently should you be loading the table, or are you concerned about the impacts of querying against a table that you're always loading into? What is the nature of the issue here?
I am asking about how often should I be collecting statistics on a given table because its changing constantly.