Sample Header Ad - 728x90

SQL Query, how to know if is resource intensive? I/O

1 vote
2 answers
1986 views
I am troubleshooting an issue with our marketing platform as it has become sluggish and slow, I've requested the top 50 heavy/resource intensive queries executed on our sql server to correlate with our marketing workflows. Here is an example or some of the top queries, based on the average I/O would you say these queries are consuming too much resources? what is a normal acceptable IO for a query? enter image description here If I take the first query execution plan, it will be as following. enter image description here enter image description here Plan Link https://www.brentozar.com/PasteThePlan/?id=HJtGXHxUc
Asked by David Garcia (367 rep)
May 5, 2022, 11:33 AM
Last activity: Jun 12, 2025, 09:31 AM