Timeline for Free node memory and low PLE
Current License: CC BY-SA 4.0
14 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 3, 2022 at 6:01 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Jun 4, 2022 at 14:03 | history | bumped | CommunityBot | This question has answers that may be good or bad; the system has marked it active so that they can be reviewed. | |
| Apr 26, 2022 at 9:29 | history | edited | KHP | CC BY-SA 4.0 |
added 123 characters in body
|
| Mar 31, 2022 at 11:52 | answer | added | Shanky | timeline score: 0 | |
| Mar 31, 2022 at 11:25 | comment | added | KHP | The database is around 530 GB. | |
| Mar 31, 2022 at 11:21 | comment | added | J.D. | How big is the database itself? | |
| Mar 31, 2022 at 9:39 | comment | added | KHP | Ok, I updated the question | |
| Mar 31, 2022 at 9:38 | history | edited | KHP | CC BY-SA 4.0 |
added 111 characters in body
|
| Mar 31, 2022 at 9:20 | comment | added | Shanky |
Can you also add output of select * from Sys.dm_os_nodes. Its seems like one of the nodes is using more memory but let me check if there is actually NUMA configured physically or not
|
|
| Mar 31, 2022 at 8:55 | comment | added | KHP | Thanks for the reply, I updated the question, I was unsure if you meant the actual first 100 lines of the error log or the last 100 lines so let me know if you need the last 100 lines. | |
| Mar 31, 2022 at 8:54 | history | edited | KHP | CC BY-SA 4.0 |
added 611 characters in body
|
| Mar 31, 2022 at 8:37 | comment | added | Shanky |
Can you add the complete output of select * from sys.dm_os_process_memory select * from sys.dm_os_memory_nodesand select @@version in the question. Please also add first 100 lines of sp_readerrorlog in the question
|
|
| S Mar 31, 2022 at 7:54 | review | First questions | |||
| Mar 31, 2022 at 15:42 | |||||
| S Mar 31, 2022 at 7:54 | history | asked | KHP | CC BY-SA 4.0 |