Skip to main content
A
ACS LLC
Inspiring
April 11, 2013
Question

Logging requests times of all queries?

  • April 11, 2013
  • 1 reply
  • 671 views

Could anybody tell me if there is anyway to log requests times of all queries?

I have a recent issue where I've started to get deadlock issues with my SQL. There are so many pertential permitations from the SQL queries based on individual users and other data that I'm having a hard time figuring/replicating  which queries might be taking too long and under what circumstances

Thanks

Mark

This topic has been closed for replies.

1 reply

D
Dan_Bracuk
Inspiring
April 11, 2013

If you put a result attribute in the query tag you get a structure that includes the execution time.

A
ACS LLCAuthor
Inspiring
April 11, 2013

Ah. cool

So I did a search, so I add result="mysqlcommand"

Then reference #mysqlcommand.ExecutionTime# for the result which I can write to the log file

I'll have to go through each and every command but I know which page is giving 99% of the trouble.

I did some other investigation on the indexes and they are all out of wack, showing values of 80 to 90% fragmentation, yet even after I try to rebuild them I still end up with 50%+, so that can't be helping

Thanks (yet again) Dan!

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices