Hi
Im not sure if this is a CRM issue or a SQL issue.
I have a customer who has a problem with their asyncOperationBase table. Its increasing in size rapidly. The database usually sits around 40gb but has increased beyond 120gb. They have ran the asyncOperationBase clean up script to reduce
the size.
I am well aware what this table is used for and the recommended ways to keep this size down, however I believe the increase we are seeing is beyond normal.
We analysed a 24 hour window. During this time, the table increased by about 6gb. Only 171 rows where added during this time and the message column is NULL.
How is this possible, where has the space gone, and what is using 6gb?
Marc Collins www.QGate.co.uk