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?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
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?
--Jeff Moden
Change is inevitable... Change for the better is not.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy