Documentation / SQL Server XRAY / Common Workflows

Common Workflows

How teams typically use XRAY day to day.

New server onboarding

  1. Register the instance and run a full best-practice profile.
  2. Export or email the findings report for the build ticket.
  3. Remediate Critical/High items; keep Medium for the next sprint.
  4. Save a history snapshot so later scans show drift.

Monthly health review

  1. Re-run the same profile used last month.
  2. Compare dashboards / history for new regressions.
  3. Schedule the scan if you want email delivery without opening the app.

Scheduling & Worker Service

Schedules can run in two ownership modes:

  • InApp — desktop app owns the schedule loop (must stay open).
  • WorkerService — Windows service DBLenseSQLServerXRAY runs unattended scans.

Schedule storage: %LOCALAPPDATA%\DBLenseSQLServerXRAY\scan-schedules.json. Worker logs typically live under %ProgramData%\DBLenseSQLServerXRAY\logs. Install the worker with the included installer as an administrator when you need unattended operation.