Understanding limit types

Resource limits allow you to limit resource usage in different ways:

• I/O cost

• Elapsed time

• Row count

• tempdb space usage

• Idle time