Include write_page_count and other info in RunTimeCountersPerThread
Currently we can get some great actual I/O info in the new showplan element RunTimeCountersPerThread... this includes some reads (mapping to several columns in sys.dmexecqueryprofileinfo), but no writes, which can occasionally be a pretty important factor in I/O costs as well. Can we please include other columns in the XML output:
- writepagecount - not in XSD today
- opentime, closetime, firstrowtime, lastrowtime - in XSD but not exposed
2
votes
Aaron Bertrand
shared this idea