Environment
Microsoft SQL 2000
Microsoft SQL 2005
Sentinel 5.1.3 Sentinel Database Manager
Sentinel 5.1.3
Situation
Sentinel Database Manager (SDM) shows a tablespace named 'PRIMARY'
that is nearly full or completely filled. Sentinel
tablespaces should not be filling to capacity or insertions to the
database could stop due to a lack of room.
Resolution
The PRIMARY tablespace in Microsoft SQL-Server is not part of the
Sentinel system directly but instead is the default tablespace in
this database system. SDM does not by default manipulate this
tablespace and it should be maintained separately by the system's
Database Administrator (DBA) since it is part of the database
system natively.