Connect

Connection to SQL Server instance.

SQL 2000 - 2017

Server name format is

Default instance: server name

Named Instance: name\instance.

if there is a non default port add this with a comma- as in above screen shot the port is 2866

Azure/Azure Data Warehouse

tcp:XXXX.database.windows.net where XXXX is the name of the server.

Use authentication type SQL Server Authentication

View

Database information presented in a tree. Used to show indexes on columns

Health

Index, statistics, FK, and DTA health check

Foreign Key

Show foreign keys (FK), link to primary key and if there is an index on the FK.

Disk

Size of tables and indexes for storage on disk

Memory

Size of tables and indexes for storage in disk

Partition

Partitioned tables and details.

Usage

How the indexes are used read and write types

Operations

Operations on tables/indexes

In Memory

Operations on in memory tables and indexes

Settings

Change theme color and banding, and collect detailed statistics information

License

Change license Details