Timeline for Suddenly SQL server restarted with pending task count increased
Current License: CC BY-SA 4.0
10 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 6, 2020 at 15:38 | comment | added | Shanky | @BeginnerDBA Thanks. Keep watch on VAS though. | |
| Oct 6, 2020 at 14:46 | vote | accept | BeginnerDBA | ||
| Oct 6, 2020 at 14:46 | comment | added | BeginnerDBA | TF T8075 seems to have fixed the issue. I am posting as a comment for future users. Also your input also helped so i am marking that as answer | |
| Sep 25, 2020 at 14:43 | comment | added | Shanky | @beginnerDBA Since you are not getting OOM and specifically due to VAS fragmentation this TF may not be needed. | |
| Sep 23, 2020 at 18:16 | comment | added | BeginnerDBA | I will see if i can. Also do you think we need T8075 on SP4 even based on that wait SOS_MEMORY_TOPLEVELBLOCKALLOCATOR seen. Just saw two events for 2 queries just few mins before restart | |
| Sep 23, 2020 at 16:40 | comment | added | Shanky | Would it be possible for you to post complete errorlog on shared drive, please mask the sensitive data. | |
| Sep 23, 2020 at 16:37 | comment | added | BeginnerDBA | I am just believing it to be true based on diff between maxworkers available and workers created. Also i did not see any high CPU usage, i mean i can see CPU been stable at around 40% during that time | |
| Sep 23, 2020 at 16:33 | comment | added | Shanky | @beginnerDBA Are you sure other schedulers were "free" ? SQL Server must be assigning parallel threads since you have parallelism and one of the threads should have come to scheduler that is hung, but still SQL Server believes it will come out so may be assigning threads. Later when it came to conclusion that it cannot get out it restarted. | |
| Sep 22, 2020 at 19:46 | comment | added | BeginnerDBA | thanks! I am not able to understand why when there are so many schedulers available , SQL is going back on same thread for a process. We see queries waiting on parallelism coming from different app servers. Should'nt they be assigned diff worker threads may be on diff scheduler if one is hung? | |
| Sep 22, 2020 at 17:25 | history | answered | Shanky | CC BY-SA 4.0 |