Skip to the content.

Table of Contents

apm Sample Data For Change

Icons are from version 18 or greater.

Instance

Indicates the status of the SQL Server instance.

Icon Description
Instance running SQL Server instance service state is running.
Instance unknown SQL Server instance service state is unknown and cannot be reached.

Database

Indicates the status of the database.

Icon Description
Database normal Database state is normal.
Database offline Database state is offline.
Database restoring Database state is restoring.
Database recovery Database state is pending recovery.
Database suspect Database state is suspect.

Database User

Icon Description
Dbuser enabled Database user state is enabled - user granted connect privileges.
Dbuser disabled Database user state is disabled - user denied connect privileges.

Management

Policy Management

Indicates the status of policy management.

Icon Description
PolicyMgmt enabled Policy Management state is enabled.
PolicyMgmt disabled Policy Management state is disabled or unavailable in this edition.

Resource Governor

Icon Description
ResourceGov enabled Resource Governor state is enabled.
ResourceGov disabled Resource Governor state is disabled.

SQL Server Agent

Indicates the status of the SQL Server Agent service.

Icon Description
Agent enabled SQL Server Agent service state is running.
Agent disabled SQL Server Agent service is not running.
Agent unknown SQL Server Agent service state is unknown and cannot be reached.

Job

Indicates the status of the SQL Server Agent job.

Icon Description
Job enabled Job state is enabled.
Job disabled Job state is disabled.

Security

Login

Indicates the status of a login.

Icon Description
Login enabled Login state is enabled.
Login disabled Login state is disabled.

Server Role

Indicates the modification status of a server role.

Icon Description
ServerRole unlocked Server role state is unlocked and can be modified.
ServerRole locked Server role state is locked and cannot be modified.

Why These Samples

The samples chosen for this reference guide were done so as a part of Sample Data for Change, which strives to leverage technical examples to increase awareness, diversification, and change within technical fields.

Contribute

Missing something? Want to add an icon? Open an issue to get some :heart:.