I have a MDE file which constantly keeps inflating in size. I did not notice this before as I used to republish this with a new copy. But over a period of 3-4 days, the size increases from 16 mb to 30 mb. Is this normal or should I take some steps to prevent this occurrence.
Inflating MDE Files (1 Viewer)
- Thread starter khwaja
- Start date
- Local time
- Tomorrow, 08:25
- Joined
- Jan 20, 2009
- Messages
- 12,863
The commonly used bad practice of writing temporary data to the FE will cause it to continue to bloat indefinitely.
My impression is that query plans are dropped in a Compact & Repair. They are rebuilt as each query is subsequently run. This will cause the FE to grow but not indefinitely.
My impression is that query plans are dropped in a Compact & Repair. They are rebuilt as each query is subsequently run. This will cause the FE to grow but not indefinitely.
After checking over night and seeing that file has bloated, I find it quite unprecedented as running of queries was always there but it did not blaot at this rate. could there be any other reason? This file is being access through network drive as well as citrix and we have had some network delay issues lately.
