Desk house is the quantity of space for storing allotted to a desk in a database. It is very important monitor desk house utilization to make sure that tables don’t run out of house and to determine alternatives for optimization.
There are a variety of the way to test desk house utilization. One widespread methodology is to make use of the `SHOW TABLE STATUS` command. This command will show details about all the tables in a database, together with the quantity of house that every desk is utilizing. One other methodology for checking desk house utilization is to make use of the `sp_spaceused` saved process. This saved process will return details about the house utilization of all the tables in a database.