Use https://github.com/signalfx/splunk-otel-collector/releases/tag/v0.132.0 against a sql server that does not have any load. Run for one day. Check memory profiles.
I noticed there's an update on SQLServer receiver optional metrics. However, after trying to use them, it seems they don't work, and I got an error indicating that ...