Computer

Refers to the server that hosts a SQL Server, this maybe a physical or virtual server.

Database

A database is a data structure that stores organized information. Most databases contain multiple tables, which may each include several different fields. For example, a company database may include tables for products, employees, and financial records. Each of these tables would have different fields that are relevant to the information stored in the table.

Instance

Also known as SQL Server or SQL server instance. SQL Server supports multiple "instances" or installations on the same host computer. Each instance runs independently from all others and has its own set of installation code, configuration parameters, system and user databases, memory allocation, and security configuration. 

Location

The location refers to the physical or geographical location of an instance, such as Houston for example.

Owner

The owner refers to the user whom the instance belongs to. When you register an instance, Idera recommends that you register the instance owner, so later you can easily get information from this owner and his/her respective instances. 

 

SQL Compliance Manager audits all activity on your server. Learn more > >
  • No labels