'How can I see the queries executed on day x? (So I can find the DB change that is impacting performance.)
Since Day X (which is inconveniently just outside my DB recovery plan), I have been experiencing a significant performance degredation on an overnight process that runs Stored Procedure A, executed via an elastic job agent.
I've done a lot of troubleshooting on the query itself, without shedding any light. I definitely didn't alter it in the time period in question.
As I was trying to optimise other processes around this time, which use some of the same tables, my theory is that I inadvertently changed something that Stored Procedure A is dependent on - eg adding an index.
I would like to do two things:
- Get a list of every statement I executed on day X.
- Get a breakdown of the stored procedure's component statements on day Y, and see which elements were not resolving in a timely manner.
I'm hoping if I can compare these two lists, I'll find a causal link, which I can then undo.
UPDATE I am on AZURE. This seems to invalidate most of the suggestions so far.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|