March 28, 2020 at 4:47 pm
question for DB Gurus
when sql server is restarted, it will be slow at first building exec plans , caching plans and increasing buffer.
Any way to do it faster than just waiting for sql server to do it automatically
March 29, 2020 at 3:02 pm
Is there a particular issue you are trying to resolve? Are you seeing performance issues related to the above questions - or is there another reason you are looking for a 'faster' way?
Problems are opportunities brilliantly disguised as insurmountable obstacles.
How to post questions to get better answers faster
Managing Transaction Logs
March 29, 2020 at 5:08 pm
we have a lot of sproc code which was running slowly across 1000's of DB's in production. I understand this is normal , but hoping to get a magic recompile or some way to do it across.. before they start hitting it.
March 29, 2020 at 7:49 pm
To be honest, I'd be more worried about code that was using "1000's of DB's in production". Why do you have so many? Are you using (for example) one database per customer or something similar?
March 29, 2020 at 8:51 pm
yes one DB per customer, I would say 500 of them on one instance are active ( sizes are relatively small)- largest 100 GB, smallest even 1 GB..
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply