Spotlight Cloud Help

Grant account permissions

In some environments, it may not be feasible for Spotlight Cloud to connect to the on-premise SQL Server instance with an account that is a member of the sysadmin server role. The following instructions are provided for these environments.

SQL Server TempDB usage page

Drilldown on usage of the TempDB system database. TempDB is a temporary workspace for storing temporary tables that hold intermediate results during sorting or query processing. Tempdb is re-created newly from stored configuration each time the SQL Server service starts.