We log duration and rowcount of virtually every sql statement within a stored proc. This allows to see exactly how long each bit takes, and also where the stored...

Well I did say that it wasn't advised. 😉

Of course to answer the question 'is it acceptable?', you have to ask to whom?

One of my current Production systems for...

That sounds a bit over-engineered to me.

You didn't say whether the wieghting factor is always equal (in the example you gave it was). If that's true then if a...

Yeah, of course it's acceptable.

But there are plenty of reasons why it wouldn't be advised, and I'm not...

Did you mean timestamp/machine name, or datetime/machine name.? If not the latter, then step one, make it the latter.

You could then partition by day and just drop the relevant...

Well I don't think you should be adding facts to your dimensions.

Isn't the issue here that your fact table is at the wrong granularity. Clients can change suite size...

I think the earlier point about context is the key. As a manager/developer, when we talk to users, we might say things like

"we can add that to the database"

"We...