Requirements

Supported Operating Systems

•Desktop

Windows 7, 8, 8.1, 10

•Server

Windows 2003, 2008, 2012, 2016

.Net Version

.net 4.6

Supported SQL Versions

•SQL 2000

•SQL 2005

•SQL 2008

•SQL 2008r2

•SQL 2012

•SQL 2014

•SQL 2016

•SQL 2017

•SQL Azure

•SQL Azure Data Warehouse

•Parallel Data Warehouse (APS)

Database Compatibility Level

For the database it must be compatibility level 80 or later (SQL 2000 or later)

Security Requirements

The application checks the users security on each database processed. If you do not have the required permission it will not process the items listed below.

Permissions Required by SQL Version.

SQL 2005-2017

	Permissions
Security required to view item in application	View Server State	View Database State	sysadmin	db_owner or db_ddladmin
Statistics			üü	üü
Index Operational usage	üü	üü	üü
Index Usage		üü	üü
In memory Index usage	üü		üü
Missing Indexes	üü		üü

SQL Azure/Data Warehouse

	Permissions
Security required to view item in application	View Server State	View Database State	sysadmin	db_owner or db_ddladmin
Statistics			üü	üü
Index Operational usage		üü	üü
Index Usage		üü	üü
In memory Index usage		üü	üü
Missing Indexes		üü	üü

üü Either permission eg. view server state or view database state is required.