A large sort repeatedly spills to tempdb and latency rises. Which evidence should the administrator inspect?

Published
  1. Only the server's public DNS alias
  2. Memory grants, row estimates, execution plan, and available resources
  3. Only the TDE protector's display name
  4. Only the backup file's extension

Comments — 0