| |
Home |
![[Table of Contents]](/dwicons/b_toc.gif)
|
System Administration Guide (Online Only) |
![[-]](/dwicons/i_colpse.gif)
| Chapter 6 Limiting Access to Server Resources |
Chapter 6
This chapter describes how to use resource limits to restrict the I/O cost, row count, or processing time that an individual login or application can use during critical times. It also describes how to create named time ranges to specify contiguous blocks of time for resource limits.
| What are resource limits? |
| Planning resource limits |
| Enabling resource limits |
|
| Defining time ranges |
| Determining the time ranges you need |
![[+]](/dwicons/i_expand.gif)
| Creating named time ranges |
| Modifying a named time range |
| Dropping a named time range |
| When do time range changes take effect? |
|
| Identifying users and limits |
| Identifying heavy-usage users |
| Identifying heavy-usage applications |
| Choosing a limit type |
| Determining time of enforcement |
| Determining the scope of resource limits |
|
| Understanding limit types |
|
| Limiting I/O cost |
|
| Limiting elapsed time |
|
| Limiting the size of the result set |
| Setting limits for tempdb space usage |
|
| Creating a resource limit |
|
| Resource limit examples |
|
| Getting information on existing limits |
| Example of listing all existing resource limits |
|
| Modifying resource limits |
| Examples of modifying a resource limit |
|
| Dropping resource limits |
| Examples of dropping a resource limit |
|
| Resource limit precedence |
| Time ranges |
| Resource limits |
|
|