A seldom used ASE feature, resource limits allow limits to be set at the user level or application level. Limit styles include
row_count, elapsed_time (wall clock seconds), io_cost, tempdb_space (in pages).
-- Set a row count limit for jsmith in the cognos app, during business hours
sp_configure 'allow resource limits',1
go
sp_add_time_range business_hours, Monday, Friday, "09:00", "17:00"
go
sp_add_resource_limit jsmith, cognos, business_hours, row_count, 5000000, 2, 1, 2
go
|
|
