?
Solved

My SQL

Posted on 2013-12-02
2
Medium Priority
?
267 Views
Last Modified: 2013-12-02
I have a My SQL application running on a Window 2003 R2 server.
I need to get rid of the physical box and vertualize it.
Would there be a advantage to moving it to a 2008 or 2012 server in terms of preformance?
Other wise I will just P to V it and run until support runs out.
0
Comment
Question by:Tim_233
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 28

Accepted Solution

by:
Bill Bach earned 2000 total points
ID: 39691302
Moving to a 64-bit server with sufficiently higher amount of memory may yield performance gains,to be sure.  Not only is the 64-bit OS more efficient on 64-bit hardware, but the extra memory available to the OS, and the extra memory available to the MySQL process itself (4GB instead of 2GB) can yield better response times, too.

If it is a lightly-loaded system, you'll probably not see any differences, so just do the P2V and don't look back.
0
 

Author Closing Comment

by:Tim_233
ID: 39691482
Thanks. I like not looking back.
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
A quick step-by-step overview of installing and configuring Carbonite Server Backup.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question