sys.dm_db_index_usage

4 Aug 2006 5:49 PM

Michael DeVoe NA Navision Support

SQL2005 SP1 Dev edition

I know I am just not understanding this correctly. When I run the DMV
sys.dm_db_index_usage_stats the database_id column seems to be wrong or do
not line up with sys.databases. The object ID's reported for database_id 4
actually exist in database_id 5. If I substitute database_id 5 for 4
everything lines up. I am reading this wrong? Does sys.database.database_id
not line up with the database_id column in sys.dm_db_index_usage_stats? I do
not think this is a bug because it does not seem to be reported anywhere.

Thanks!!!
Michael...

4 Aug 2006 6:04 PM

Kalen Delaney

Can you show us how you are using this view, and a sample of the results you
get back?

--
HTH
Kalen Delaney, SQL Server MVP

"Michael DeVoe NA Navision Support"
<MichaelDeVoeNANavisionSupp***@discussions.microsoft.com> wrote in message

Show quote

news:F2538D2D-D6B4-4C1E-83F7-E4215FE5EEF0@microsoft.com...
> SQL2005 SP1 Dev edition
>
> I know I am just not understanding this correctly. When I run the DMV
> sys.dm_db_index_usage_stats the database_id column seems to be wrong or do
> not line up with sys.databases. The object ID's reported for database_id
> 4
> actually exist in database_id 5. If I substitute database_id 5 for 4
> everything lines up. I am reading this wrong? Does
> sys.database.database_id
> not line up with the database_id column in sys.dm_db_index_usage_stats? I
> do
> not think this is a bug because it does not seem to be reported anywhere.
>
> Thanks!!!
> Michael...
>
>