Timeline for How to clean up memory usage of a database after a big sql query
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 5, 2018 at 15:33 | comment | added | Legends | :D Ok, I got it to work via ` SQLCMD`. Had to try several times and also reboot once. Yes, I set it probably a way too low. | |
| Jan 5, 2018 at 15:26 | comment | added | Aaron Bertrand | @Legends Please read before setting values that low. | |
| Jan 5, 2018 at 15:03 | comment | added | Scott Hodgin - Retired | You might need to Start SQL Server with Minimal Configuration | |
| Jan 5, 2018 at 15:01 | comment | added | Scott Hodgin - Retired |
Can you put your T-SQL commands into a txt file and reference the txt file as input to SQLCMD?
|
|
| Jan 5, 2018 at 14:57 | comment | added | Legends | Before I set max server memory to 16 MB. Now I have a problem accessing my SQL Instance. EventViewer tells me: There is insufficient system memory in resource pool 'internal' to run this query. How can I increase the max memory now again without access via SSMS? When I start the service under Services, it starts, but shuts down quickly afterwards. | |
| Jan 5, 2018 at 14:38 | comment | added | Legends | Or via SSMS GUI | |
| Jan 5, 2018 at 14:36 | vote | accept | Legends | ||
| Jan 5, 2018 at 13:55 | history | answered | Scott Hodgin - Retired | CC BY-SA 3.0 |