How to turn find out duration of SQL Query execution time

Hi everybody,

Want to share two important commands for MS SQL:

SET STATISTICS IO ON

SET STATISTICS TIME ON

After you turn it on, you may see following in the output window:

with this ouptut window you may see how long it took actually to execute some query, and if added indexes improved or didn't execution time.

What is important to pay attention to is Logical reads. Each logical read is equal to reading a chunk of 8Kb

Looking to optimize your Acumatica development environment?

If you're keen on improving your SQL query performance with techniques like SET STATISTICS IO ON and SET STATISTICS TIME ON, it might be time to consider custom development tailored to your specific needs.

Don't let inefficiencies slow you down – reach out for a personalized Acumatica customization that maximizes performance and aligns with your business goals.

Contact us today to discuss how we can help fine-tune your Acumatica system!