Advertisement
Guest User

Untitled

a guest
Oct 4th, 2020
15
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.39 KB | None | 0 0
  1. SQL Server parse and compile time:
  2. CPU time = 0 ms, elapsed time = 0 ms.
  3.  
  4. SQL Server Execution Times:
  5. CPU time = 0 ms, elapsed time = 0 ms.
  6. SQL Server parse and compile time:
  7. CPU time = 56 ms, elapsed time = 56 ms.
  8.  
  9. SQL Server Execution Times:
  10. CPU time = 0 ms, elapsed time = 1 ms.
  11.  
  12. SQL Server Execution Times:
  13. CPU time = 0 ms, elapsed time = 3 ms.
  14. SQL Server parse and compile time:
  15. CPU time = 0 ms, elapsed time = 1 ms.
  16. Table '#tmpColumnstore_____________________________________________________________________________________________________000000000029'. Scan count 0, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
  17.  
  18. SQL Server Execution Times:
  19. CPU time = 0 ms, elapsed time = 1 ms.
  20. SQL Server parse and compile time:
  21. CPU time = 47 ms, elapsed time = 53 ms.
  22. Table 'Users'. Scan count 27, logical reads 135570, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
  23. Table '#tmpColumnstore_____________________________________________________________________________________________________000000000029'. Scan count 7, logical reads 12, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
  24. Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
  25. Table 'Worktable'. Scan count 0, logical reads 0, physical reads 0, page server reads 0, read-ahead reads 0, page server read-ahead reads 0, lob logical reads 0, lob physical reads 0, lob page server reads 0, lob read-ahead reads 0, lob page server read-ahead reads 0.
  26.  
  27. SQL Server Execution Times:
  28. CPU time = 4328 ms, elapsed time = 837 ms.
  29. SQL Server parse and compile time:
  30. CPU time = 0 ms, elapsed time = 0 ms.
  31.  
  32. SQL Server Execution Times:
  33. CPU time = 0 ms, elapsed time = 0 ms.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement