TFS Database Instance Class

  • ID:  TeamFoundationServer2008.TFSDatabaseInstance
  • Description:  The SQL instance of the TFS - also called the Data Tier.
  • Class Hierarchy: 
    Object
    Configuration Item
    Logical Entity
    Computer Role
    Windows Computer Role
    SQL Role
    SQL DB Engine
    SQL Server 2005 DB Engine
    TFS Database Instance

  • Attributes:  Hosted
Login
Monitors the auto close setting for the database Monitors the auto create statistic setting for the database Monitors the auto shrink setting for the database Monitors the auto update statistics async setting for the database Monitors the auto update statistics setting for the database Monitors the DB chaining setting for the database Monitors the trustworthy setting for the database Monitors the page verify setting for the database. Monitors the recovery model setting for the database. Monitors for a large change in value of database available space over a set number of sample periods. Monitors the space available in the database and on the media hosting the database in percentage terms. This monitor checks the status of the SQL Database Engine service. This monitor checks the status of the SQL Full Text Search service. Monitors the service pack level of the database engine against the compliant setting Monitors blocked sessions for a SQL instance. This monitor analysis the user connections to the SQL database engine over time and calculates a baseline over the initial learning period. This is a major error. Monitor For TFS Event 3001, which is raised when user does not have TFS permission to view reports The user cannot be authenticated by Team Foundation or a component used by Team Foundation Monitor TFSServer Scheduler Monitor to detect event 6004 - TFS crash response MonitorTFSEvent3006: Database is full The service experienced a Fatal error while initializing that prevented it from starting A Plugin failed to load. These indicate event log entries that do not fall into one of the TFS categories. Basically it acts like a catch bucket. MonitorTFSEvent3008: Database connection error Schema version mismatch error AT Stamp mismatch error Team Foundation registration data malformed Monitor TFS Event 3024 - Error while transferring files Active Directory Sync error - This is set to auto reset, as usually during the next AD sync cycle this error should vanish. Instance mismatch error MonitorTFSEvent3033,3036,3038  Error notifying subscribers about TF group/identity change. TFSEvent3007: Database configuration The rate that the Team Foundation Server registration service is being queried. The rate of queries about links between artifacts in Team Foundation Server. The processing rate of the Team Foundation Server event system. The number of Team Foundation Server events being matched with subscriptions The number of files currently being downloaded from the TFS Version Control service. The time, on average, that the TFS Version Control service took to process a single request. The rate that files are being downloaded from the TFS Version Control service. The rate at which requests are being processed by the TFS Version Control Service. The number of currently active requests being processed by the TFS Version Control service. The number of files currently being uploaded to the TFS Version Control service The rate that files are being uploaded to the TFS Version Control service. The number of notifications ready to be sent. MonitorTFSevent3004: Invalid idenity exception MonitorTFSEvent3005: Identity does noe exist TFS Event 3002 - The user lacks authorization for the operation being performed. This usually means that the user is not a member of the Team Foundation Valid Users group or that membership in that group cannot be affirmed This monitor checks the status of the database. This monitor checks the status of the SQL Database Engine service. This monitor detects when a log shipping destination has not had a log restored to it within the threshold defined as a part of the log shipping configuration. This monitor detects when a log shipping source has not had its logs backed up within the threshold defined as a part of the log shipping configuration. Monitors the space available on the log files and on the media hosting the log in percentage terms. Monitors the space available on the log files and on the media hosting the log files in megabytes. Monitors for the free space left in the database in terms of megabytes. The SQL instance of the TFS - also called the Data Tier. TFS Application Tier Defines the basic properties of computers running Windows operating systems This contains all of the SQL databases that are relevant to the TFS instance.

Download diagram as a Visio file

Properties

Display Name Description
Account Name  
Asset Status Asset status
Audit Level  
Authentication Mode  
Cluster  
Connection String  
Display Name Display name of the object.
Edition  
Error Log Location  
Error Reporting Enabled  
Full Text Search Service Name  
Full Text Search Service Name If Clustered Resource  
Install Path  
Instance Name (Key)  
Language  
Master Database Location  
Master Database Log Location  
Notes Notes
Object Status Object status
Performance Counter Object Name  
Replication Distribution Database  
Replication Working Directory  
Service Pack Version  
SQL Server Agent Windows Service Name  
SQL Server Agent Windows Service Name If Clustered Resource  
SQL Server Windows Service Name  
SQL Server Windows Service Name If Clustered Resource  
Tools Path  
Version  

Discovered By

Name Description
Discovery Rule for TFS Database Instance Discovery Rule for TFS Database Instance

Relations

Health Source
NameClassType
SQL Server 2005 Database Engine Hosts SQL Server 2005 Agent SQL Server 2005 DB Engine Hosting
SQL Server 2005 Database Engine Hosts Distributor SQL Server 2005 DB Engine Hosting
SQL Server 2005 Database Engine Hosts Publisher SQL Server 2005 DB Engine Hosting
SQL Server 2005 Database Engine Hosts Subscriber SQL Server 2005 DB Engine Hosting
SQL Database Engine Hosts SQL Database SQL DB Engine Hosting
Owned By User Configuration Item Reference
Affects Customers Configuration Item Reference
Serviced By User Configuration Item Reference
Contains Configuration Item Configuration Item Membership
Is Related to Configuration Item Configuration Item Reference
Config Item References Location Configuration Item Reference
Entity Watched By Perspective Object Reference

Health Target
NameClassType
ContainmentTFSATtoTFSDBInstance TFS Database Instance Membership
SQL Server 2005 Instance Group Contains Instances SQL Server 2005 DB Engine Membership
Instance Group Contains All Instances of SQL DBEngine SQL DB Engine Membership
Hosts Windows Computer Role Windows Computer Role Hosting

Class Knowledgebase

Summary

The SQL instance – also called the Data Tier.

External References
This class does not contain any external references.

See Also for Team Foundation Server (TFS) Management Pack


Downloads for Team Foundation Server (TFS) Management Pack

AZURE OPTIMIZATION ASSESSMENT GET STARTED
MIGRATION TO AZURE GET STARTED
SYSTEM CENTER MIGRATION TO AZURE GET STARTED
MIGRATION TO AZURE FOR SQL AND WINDOWS 2008 GET STARTED