I have a Windows server, and on this server there are many websites running and most of them connect to the installed SQL Server, some of them connect to SQL Server Express and some to local.
My issue is: there is one old website, has some programming errors which affect SQL Server performance and as a result affect all websites performance.
I can't currently fix these errors, so i want to put this website on a separate SQL Server engine.
Is that possible and how? or there is any other suggested solutions?
The issue I have is that some queries while running make the server very slow and opening SQL Server Management Studio is very slow as well.