Is there some way to estimate the cost of deliver data from DW to "client"?
I'm looking for some generic way to do this, because in my company we don’t want to overwhelm DW with SQL queries. One have to pay for every data that comes to him.
Two simple ideas are:
1) cost base on CPU, I/O operations. But in practice there’s no way to predict usage of CPU
and alone IO statistic isn't enough do this in proper way.
2) Heuristic based on current SQL statistics ( looking for similar queries and estimate approximate cost)
3) some tools ???
Sorry if this seems to trivial question but I'm new in DW environment and haven’t found anything yet that describes my problem. Also sorry if the post in wrong section.