I have only question about some interesting issues
I tested yesterday some query, where was problem with running. Long time wasnt some problem, but last week is problem with this.
Default MAXDOP is 8, there is 32 cores 64 logicals CPU, 2sockets . This is AG , I executed on Secondary server with Read where was 1-3% CPU because secondary replica is for reportings.
We found that with MAXDOP hint in query directly
- yesterday about 13-17hours was possible run this query only with MAXDOP 1,2,3,4
- yesterday after 18 and more was possible run only with MAXDOP 1,2
with more maxdop looks like "frozen", I checked also Live query view and know where was "frozen", but could not see some problem only CXPACKETS block on this session where i run.
- Today about 9- till now is possible run this query with all MAXDOP 1,2,3,4,5,6,7,8
I was thinking about update statistics, but problem is that is every day, and this query wasnt possible run longer time not only yesterday.
Does somebody experience or ideas what can i check else?
I am waiting now till night if there will be also problem or not.
- This topic was modified 6 months, 4 weeks ago by tony28.
How to post data/code on a forum to get the best help:
Option 1[/url] /