Mem_Stats.sql and PerfStats.sql both get exact query
gambit9009 opened this issue · 1 comments
Do you want to request a feature or report a bug?
Clean up
What is the current behavior?
Same query running in 2 places. If you get SQL Server Perf Stats and SQL Memory Error. We create and exec sp_mem_stats_grants and sp_mem_stats_grants_mem_script. This sp can have a high mem grant itself.
What is the expected behavior?
Consider only collecting it in one place. Do we need it in both? Are those likely to add SQL Mem Error already going to get SQL Perf Stats?
Which versions of SQL Server and which OS are affected by this issue? Did this work in previous versions of our procedures?
All versions
May want to file separate issues or maybe a single generic one to compare our different .sql and see where we are getting the same info more than once.