Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Throttling resource usage by a stored procedure
Message
From
24/09/2003 18:12:02
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Throttling resource usage by a stored procedure
Miscellaneous
Thread ID:
00832024
Message ID:
00832024
Views:
40
Is there anyway to limit the resource usage on SQL server for a given stored proceedure or for all stored proceedures?

I'd like to be able to protect a production server from "runaway" stored procedures that might consume large resources and bring the rest of the servers requests to a crawl.

Thanks,
Anthony
Next
Reply
Map
View

Click here to load this message in the networking platform