I’m sorry to bother, but I recently started using Metabase with my MSSQL 2016 server. My database is some 12 GB, without Metabase running it doesn’t use more than 13 GB of RAM, and Tempdb stays under 1GB. When I turn on my metabase machine, RAM usage goes to 95% of the 19 GB I have for the sql machine, and Tempdb starts to climb - Over 36 hours its gone from under 1gb to occupying the whole 100gb partition its on.
Would anyone have any idea what is causing this? I’ve tried to set all the options to the least expensive possible, but it still seems to happen.
Thanks in advance for any ideas!!