Viewing 15 posts - 16 through 30 (of 254 total)
This was removed by the editor as SPAM
May 16, 2019 at 5:24 pm
The information is captured in system tables. You just have to query those and you're off and running. Take a look at sys.jobhistory. Then, to only get the longest...
May 15, 2019 at 5:04 pm
Any reason you couldn't take this and turn it into an INSERT statement into a table somewhere?
SELECT TOP 10
GETDATE() AS EventDate,
qs.total_worker_time/(qs.execution_count*60000000) as [Minutes Avg CPU...
May 15, 2019 at 6:44 am
@Grant: Can you provide me an example on how to do that using Query store or extended events or any article that you can point out that would help me...
May 15, 2019 at 6:43 am
I've provided the output of the virtual file stats via this url link. It was sample exactly as referenced in the article for a period of 30 minutes.
April 2, 2019 at 8:11 pm
Thanks! Sue. I will grab that information and loop back on this thread. Also, we have a team meeting tomorrow with the storage admin, networking team etc. DO you...
April 2, 2019 at 8:09 pm
Thanks! Sue. I will grab that information and loop back on this thread. Also, we have a team meeting tomorrow with the storage admin, networking team etc. DO you have...
April 2, 2019 at 6:24 pm
just append your WHERE statement...
March 22, 2019 at 10:09 am
March 21, 2019 at 2:08 pm
March 19, 2019 at 10:22 am
Okay so I figured out the issue was with different compatibility levels and so the performance dip...thanks everyone for your suggestions.
March 11, 2019 at 11:37 am
March 6, 2019 at 12:49 pm
March 6, 2019 at 12:31 pm
ScottPletcher - Tuesday, March 5, 2019 12:56 PMDid you look at / compare the query plans?
It is actually quite same.
March 5, 2019 at 2:21 pm
Viewing 15 posts - 16 through 30 (of 254 total)