Fast query runs slow in SSRS

by

Thanks for the suggestions provided here. We have found a solution and it did turn out to be related to the parameters. SQL Server was producing a convoluted execution plan when executed from the SSRS report due to ‘parameter sniffing’. The workaround was to declare variables inside of the stored procedure and assign the incoming parameters to the variables. Then the query used the variables rather than the parameters. This caused the query to perform consistently whether called from SQL Server Manager or through the SSRS report.

More Related Contents:

  1. Performance optimization strategies of last resort [closed]
  2. How to find the kth largest element in an unsorted array of length n in O(n)?
  3. HTTP vs HTTPS performance
  4. Is performance reduced when executing loops whose uop count is not a multiple of processor width?
  5. Is it safe to shallow clone with –depth 1, create commits, and pull updates again?
  6. How are x86 uops scheduled, exactly?
  7. Why is my Rust program slower than the equivalent Java program?
  8. How can I accurately benchmark unaligned access speed on x86_64?
  9. How much overhead does SSL impose?
  10. When, if ever, is loop unrolling still useful?
  11. Is ADD 1 really faster than INC ? x86 [duplicate]
  12. Clear file cache to repeat performance testing
  13. MATLAB parfor is slower than for — what is wrong?
  14. What’s the (hidden) cost of Scala’s lazy val?
  15. Given n points on a 2D plane, find the maximum number of points that lie on the same straight line
  16. Why is a conditional move not vulnerable to Branch Prediction Failure?
  17. Is Mongodb Aggregation framework faster than map/reduce?
  18. Fast vectorized rsqrt and reciprocal with SSE/AVX depending on precision
  19. Speed-efficient classification in Matlab
  20. x86_64: is IMUL faster than 2x SHL + 2x ADD?
  21. Number of partitions in RDD and performance in Spark
  22. SUMIFS function in Google Spreadsheet
  23. Optimizing File Cacheing and HTTP2
  24. Performance of using static methods vs instantiating the class containing the methods
  25. Performance comparison of a Vec and a boxed slice
  26. How can the rep stosb instruction execute faster than the equivalent loop?
  27. Performance of function slice parameter vs global variable?
  28. Do 128bit cross lane operations in AVX512 give better performance?
  29. How to find Cumulative Layout Shift problems if Page Speed Insights says one thing and Search Console says another
  30. SET vs. SELECT – What’s the difference?

Leave a Comment