This table lists the amount of memory used by different objects in Microsoft® SQL Server™.
| Object size | ||
|---|---|---|
| Object | SQL Server 6.5 | SQL Server 7.0 |
| Lock | 60 bytes | 96 bytes |
| Open database | 1,144 bytes per server plus 160 bytes per database | 2880 bytes |
| Open object* | 240 bytes | 276 bytes |
| User connection | 44K | 24K |
| * Open objects include all tables, views, stored procedures, extended stored procedures, triggers, rules, defaults, and constraints. | ||