We're using a SQL Server 2008 database. This database provides data for two main applications:
- A website to display a Viewer.
- 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?