-2

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?

Update:
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.

Improve this question
  • 2
    You can install more than one instance of SQL Server on a machine. What is the nature of the performance issues? – Martin Smith Oct 7 '12 at 9:39
  • connection not closed or very long queries, which some time fail, somethings like this. – Amr Elgarhy Oct 7 '12 at 9:47
  • i have on this server 2 instances, the (local) and .\sqlexpress but they affect each other performance – Amr Elgarhy Oct 7 '12 at 9:47
  • @AmrElGarhy You are speculating about a solution without telling us the problem. If you post a new question with an example of the error messages you see in your application, we might be able to help you better. – Iain Samuel McLean Elder Oct 7 '12 at 10:18
3

Multiple installations are possible

According to the feature matrix, You can install up to 16 instances of SQL Server on one host. If you use Enterprise edition, you can install up to 50.

The side-by-side documentation states that certain features will be shared among all instances. For example, if you install the development kit or the management tools, you will be able to use them with all instaled instances. The database engine and other instance-specific components will be logically isolated.

Run the SQL Server installer from your installation media and it will guide you through the process of creating another instance.

Will it solve your problem?

You haven't given us any detail about the performance problem, so it's hard to know if using a separate instance would benefit you.

If the application behaves so badly that it causes SQL Server to restart, then running a separate instance will stop the restart from affecting other applications.

If the application is executing poorly-optimized queries that result in a lot of disk scanning, then running a seperate instance is unlikely to help you, because the same hardware is shared among all instances.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.