I have a SQL Server instance with 128GB of RAM that doesn't have a memory cap on it. Well, it had a cap but it was at 128000 so it wasn't doing much good.
We've had issues reducing memory before so I was going to go slow. I reduced that from 128000 to 126000. That took 45 minutes. The server was fine during that time. I continued to work but it caused me a fair amount of grief.
I've had it run quickly and I've had it take a while. Anyone had anything similar?
I'm SQL Server 2008 Enterprise x64 Enterprise w/128GB RAM and 4 cores on a VM. Nothing is oversubscribed.