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.

The worker is a separate download (not on the main Downloads page). See Getting Started — Worker Service or download DBLenseSQLServerXRAY.Worker-1.0.0.zip, then run Install-WorkerService.exe as administrator.