SQL Monitor - Show All Activity
BWar81
Posts: 9 New member
Hello,
Is it possible in SQL Monitor to show all activity / queries within a certain timeframe? I have been asked to check if an SQL account was deleted and re-created in one of my instances so am trying to see if SQL Monitor would be able to show that.
Many Thanks
Is it possible in SQL Monitor to show all activity / queries within a certain timeframe? I have been asked to check if an SQL account was deleted and re-created in one of my instances so am trying to see if SQL Monitor would be able to show that.
Many Thanks
Best Answer
-
BWar81
Posts: 9 New member
For anyone interested, I have now been advised that "Unfortunately, SQL is unable to look for a specific query outside of what it considers to be within its "Top Queries" which should be the most resource-intensive."
