We're using a sql Server 2008 database. This database provides data for two main applications :
1) A website to display a Viewer.
2) A routing application that needs to be highly responsive !
Is it possible to give different priorities to those two applications and what would be all the possibilities available to us ? I'm afraid that our Viewer website, through a bug or anything else would slow down our routing application.
I want to protect the routing application in order to keep it highly responsive, what are the solutions I could use ?
Thanks for your help !