Dear all,
when SQL server is slow when call from web, mainly insert/update/delete operation, in a super busy situation, web system can hangs and no response.
any way from your point of view to solve this ?
someone suggest tibco active space, which site between database and web tier:
http://www.tibco.com/products/automation/in-memory-computing/in-memory-data-grid/activespaces-enterprise-edition
any other think you guys will do to handle this ?
can in memory database engine in SQL 2012/2014/2016 help on this ?
sorry, sometime EE has some special effect when searching the group this question belongs to and this searching effect can kill my browser session and I don't know it post a question FOR ME today. usually it should not !
"Further more, there are normally many options in the existing system (SQL Server, IIS) to do performance tuning."
can you share what it is?
". Then even the solutions from above won't work. "
sure! the reason I ask for this as it really success for a company I work with before.
from my point of view, combine SPs together into single SP can scale out transaction per sec, combining views in to a single view can do this too. should it related too ?