Return
-
Title
DBID vs DatabaseID in LiteSpeed -
Description
The DBID field within Sys.Databases does not match the DatabaseID of LiteSpeedActivity or LiteSpeedDatabase tables.
-
Resolution
There is a 'DBID' field located within the sys.databases table that SQL Server uses to recognize it's databases. In LiteSpeed we have two tables - LitespeedDatabase and LiteSpeedActivity which contain 'DatabaseID' field which is an internal value that Litespeed uses to identify databases that are configured to be used with LiteSpeed.
The two ID's are completely separate from one another and have no link between the two. This will be resolved in a future release of Litespeed where the DatabaseID in the Litespeed tables will not be visible to help clarify any confusion.