Throguh a few of my front-ends I have some fairly heavy tasks, amongst others a stored procedure that creates a 10 column table, feeds it with everything from 10 to 10.000 rows and then creates indexes on it.

These procedures run in a db of their own, but on the same hardware - pretty heavy hardware though - and was wondering if there is any way to throttle the ressources used by any given procedure...

I've tried enabled the bulk insert before the insert function runs, whcih gives a small boost, but the real killer is te creation of the indexes apparently.

Cheers and thanks for any advice