BOL provides pretty much no information about what the value contained in
the ObjectID2 column for a Lock Acquired event actually refers to. Can
anyone shed some light on this for me?

TIA

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx

Michael MacGregor (nospam (AT) nospam (DOT) com) writes:
I ran a trace with Lock Acqured included, and there was more data in
ObjectID2 than in ObjectID. I should add that this was on an idle server,
so these were just locks from background things going on.

One number I noted was 281474978545664. This number can never appear in
ObjectID, as that column is int; ObjectID2 is bigint.

I was able to find this number with this query:

select * from master.sys.allocation_units
where allocation_unit_id = 281474978545664

Another number that appeared in several databases was 458752. There was
nothing in sys.objects with this id, but this SELECt returns a row:

select * from sys.partitions where partition_id = 458752

My interpretation is that ObjectID2 represents partitions and allocation
units that contsitute parts of tables.


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx