Microsoft SQL Server MDB Considerations › Management Database Owner

Previous Topic: Microsoft SQL Server MDB Considerations

Next Topic: Partitions

Management Database Owner

The MDB is owned by the Microsoft Windows user who ran the MDB installation.

Tempdb

Microsoft SQL Server uses the tempdb database as a scratch area for MDB temporary tables, sorting, subqueries, and so forth.

The size of the tempdb database should be increased based on available disk space and expected usage. Microsoft SQL Server adjusts the size incrementally over time, but each adjustment causes a performance hit.