May 29, 2014 at 2:15 pm
Good afternoon SQL guru community 🙂
I have a question for you all, hoping for any ideas as I am fresh out.
I did an in-place upgrade my production box about a month ago. About that same time, the Web application server that connects to the SQL box started having issues with memory. If you recycle IIS the memory starts out at a 2GB consumption, then it starts climbing from there.
I don't understand why there would be any correlation to the database upgrade but this started the very same day.
As a side note, the database server is log shipping two databases to warm standby, and the server has a DNS alias that was switched to the standby, and then back again, after the upgrade.
Thanks in advance for your ideas.
May 29, 2014 at 2:39 pm
Did you upgrade the sql client software on the web server?
June 9, 2014 at 2:36 pm
I didn't install a new driver, I thought of that but realized that the .NET connection string from the web app server is version specific...
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply