Logging options for Query execution

[lornafnb]

Good day, is there any way to monitor a particularly slow to reload, model (on the server) in terms of eg:

1. Query1 took 10 minutes to resolve and return data

2. Same for query2

etc?

I am aware of the option under Tools (query diagnostics) where one  can (locally) monitor the query execution, but that does not supply us with an accurate execution on the server. 

We need to debug this particular model to make it faster, but we dont know where the delay is.

thanks.

[lornafnb]

Thank you, I will definitely look into this option. Is Fiddler free software?

[Anonymous]

Hi @lornafnb 

Yes, it free, you can refer the following link to download it.

Download Fiddler Web Debugging Tool for Free by Telerik

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @lornafnb 

1.You can use Fiddler to catch the performance of the Server, you can refer the following link

Using Fiddler - Fiddler Classic (telerik.com).

2.You can use the Network in Console, it can also cath the performance of the web.

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.