Understanding limit types

There are four types of resource limits that allow you to limit resource usage in different ways:

• IO cost

• Elapsed time

• Row count

• tempdb space usage

• Idle time