Hello.
Is posible to know what sentence was executed?
I see some operations with MORE THAN 1 GB in workspace memory when the normal is 768KB more or less
Thanks.
It is hard to capture things after they have occurred. You would need an event session or trace setup to capture these.
You could search the cache and look for parallel plans - here is an example:
SQL SERVER – Find Queries using Parallelism from Cached Plan
Not sure what you are asking with workspace memory but it isn't unusual to see it spike high with hashes, sorts, bulk operations, etc.
Sue