Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We're considering installing MySQL on the same database server that has been running SQL Server. From my research there are no technical issues running both concurrently, but I am worried that the performance will be affected. Is by default SQL Server set up to use all available memory for example? What should I look out for? Thanks

share|improve this question

migrated from stackoverflow.com Feb 1 '10 at 8:51

This question came from our site for professional and enthusiast programmers.

    
Please ask sysadmin questions on superuser.com –  Oded Jan 28 '10 at 11:12
    
@oded yes you are right sorry. serverfault.com/questions/107144/… –  svandragt Jan 28 '10 at 11:16

2 Answers 2

A default SQL Server installation allows consumption of all memory on the machine but it is easy configurable and the same thing goes for MySQL, so given that youre machine actually have the CPU power and IO system to run both and enough memory so that you have a large enough cache on both SQL Server and mySQL go ahead :-)

share|improve this answer

That would entirely depend on what the requirements of each of your databases were for size and memory, performance requirements, and uptime requirements. If this is just a development environment, you're probably in a safe position to pilot such a configuration. If you're considering a production environment, you might have to know exactly how the databases behave under load, and if they share disk volumes, will they create intolerable disk contention. Upgrades to MS SQL might require reboots, and thus, your MySQL instance uptime is subject to that as well. Pilot your changes in a development environment and see if it is performant.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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