How Much memory is occupied when a Begin Transaction Command is given.

Hi,

Each lock consumes memory, 96 bytes per lock, similarly how much memory does a Begin Transaction Command Require.
How much resource (RAM,etc ) is held in the following scenarios.

1)
Begin Transaction
No Statements
Commit Transaction

2)
Begin Transaction
No Statements
Rollback Transaction

Thanks and Regards

PG Thiagarajan

MS Sql Server LazyDBA home page