Hello Everyone, I just started a new gig and am taking over an existing v1511 site. SQL is on a separate server which is a problem in itself but I was noticing that queries were running very slowly even though that server had 28GB of memory and we are a smaller environment (1600 clients).
I started going through collections and noticed that my predecessor set just about every Collection to do a Full Update every 15 minutes which is just crazy. I'm weeding through them but this is getting tedious. Is there a script out there where I can modify all collections to reset to something like every 3-7 days at 12AM? I can then go through and modify the few I would want to have Incremental and/or more aggressive settings. Thanks!
