We are seeing our stock leger records crossing 1.6 million and exponentially increasing. We are also seeing a dip in DB performance with frequent deadlocks or lock wait timeout issue happening.
Can these issues and the high volume stock ledger records be co-related?
Do we need to reset the stock ledger at some periodic intervals(like financial year starting etc?
Any suggestion to approach the situation is appreciated?