I have many databases restored from various other database servers on a shiny new server. I want to unify the log file size limits and allocation percentages. However, I'd like to not do this by hand so we can conform things as time passes.
I have a run away worker process.
Which of the 10ish sites on this box is it thats going nuts?
How can I determine from the pid of the worker process which site he is?
I have max memory set. But at least 1 time a day the Sql Server hits over 95% of the ram in the box, and page faults for more. In the meantime the website is throwing very obscure timeouts on simple
select count(1) where id=1
type queries
I'm a developer and don't normally get into the server administration to this level of detail. So please go easy on the level of your answers.
I inadvertantly got .py files stuck to opening my editor instead of running.