Thursday, April 29, 2010

SQL Server 2008 System Functions to Monitor the Instance, Database, Files, etc.

SQL Server provides several system meta data functions which allow users to obtain property values of different SQL Server objects and securables, for example
  • SERVERPROPERTY
  • DATABASEPROPERTY
  • FILEGROUPPROPERTY
  • FILEPROPERTY
  • OBJECTPROPERTY
  • COLUMNPROPERTY
  • INDEXPROPERTY
  • CONNECTIONPROPERTY
  • SESSIONPROPERTY
Although you can also use the SQL Server catalog views or Dynamic Management Views to obtain much of this information, in some circumstances the system meta data functions simplify the process. In this tip I am going to demonstrate some of the available system meta data functions and their usage in different scenarios, for more details click here.

1 comment: