A resource limit is a set of parameters that prevents an individual login or application from:
Exceeding a given estimated or actual I/O costs
Returning excessive rows on a per query basis
Exceeding a given elapsed time on a query batch or transaction basis
Utilizing excessive tempdb space per session
When a system administrator modifies a resource limit, all users logged in the session see the change, including the system administrator.
