GilaMonster (1/15/2014)
I'm not a fan of dev and prod on the same server (mess up dev and you can take prod down), but don't move just on account of memory, each instance of Standard edition can use up to 2GB of memory total.
I had wanted to minimise the number of operating systems we had that were out of support. But I guess 1 vs 2 2K servers is not much of worse place to be in.
- We get scored down on audits for this.
In an ideal world would look to try and improve the querying done by the application, but it's on freeze at the moment and hopefully within 12 months will be retired - so just make things better for the users is the goal (i.e. stop the timeouts!)
Thanks again Gail