performance issue of wampserver 2.5 on windows 2012
Posted by: vxu (---.63.18.65.vultr.com)
Date: September 23, 2017 03:52AM

Dear Guru,

We are facing a serious performance issue of wampserver 2.5 when migrating the windows 2003 to windows 2012 server.The application is using a separate installed mysql, not the one within wampserver. However, during the peak hours, the application is suffering slow performance on wampserver, we have checked the mysql server and the sqls and settings which are confirmed good. Are there any special parameters which should be set when using windows 2012 ? Thanks in advance!

VXU

Options: ReplyQuote
Re: performance issue of wampserver 2.5 on windows 2012
Posted by: RiggsFolly (Moderator)
Date: September 23, 2017 04:04PM

Hi,

Please tell us how we are supposed to help you remotely with almost zero information?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> < 7.2/PHP 7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.5> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: performance issue of wampserver 2.5 on windows 2012
Posted by: vxu (---.63.18.65.vultr.com)
Date: September 25, 2017 03:01AM

Dear Riggs,


Here is the 13 questions' answer:

1 - Windows version used (Specify version number AND whether 32 or 64 bit)
Windows 2012 Server 64bit

2 - Version WampServer (Specify version number AND whether 32 or 64 bit)
WampServer 2.5 64bit

3 - Apache Version
WampServer Embeded Apache : 2.4.9

4 - PHP Version
WampServer Embeded PHP: 5.5.12

5 - MySQL Version
Standalone Community MySQL 5.5.20

6 - What color is the WampServer icon (in the notification area of the taskbar)
Green


7 - In the file c:\Windows\System32\drivers\etc\hosts, what are the active lines with the name [localhost] in them?
Yes


8 - Do you have access to localhost (Homepage WampServer)?
Yes


9 - Do you have access to phpMyAdmin?
Yes

10 - If you refer to an error message, please include the EXACT wording of the error in your post
No Error Message

11 - If you use an Antivirus and / or Firewall, please include the names of these
No Firewall

12 - What is the full path to the installation of WampServer (eg D:\wamp\)
C:\wamp\


13 - If you have one or more Virtual Hosts defined, please show their definition(s)
No Virtual Hosts Defined

We have migrated back to the old windows 2003 server, and it runs fine. Is there any sepecial tricks when using windows 2012 ?


Thanks!

Options: ReplyQuote
Re: performance issue of wampserver 2.5 on windows 2012
Posted by: RiggsFolly (Moderator)
Date: September 25, 2017 10:57AM

Hi

There are no special tricks.

But you will have to make sure that you have ALL the MSVC Runtimes installed. See Troubleshooting tips specifically point 20 but do read the whole document.

If Windows Server 2012 is 64 bit, you will need BOTH the 32bit and 64bit MSVC runtimes installed.
Have you done this?

---------------------------------------------------------------------------------------------
(Windows 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> < 7.2/PHP 7.1/7.0/5.6/5.5/5.4> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.5> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: performance issue of wampserver 2.5 on windows 2012
Posted by: vxu (---.63.18.65.vultr.com)
Date: September 26, 2017 02:49AM

Dear Riggs,

Yes, we have both 32-bit and 64-bit MSVC Runtime installed, and listed below:

MSVC 2005 32bit
MSVC 2005 64bit
MSVC 2008 32bit
MSVC 2008 64bit
MSVC 2010 32bit
MSVC 2010 64bit
MSVC 2012 32bit
MSVC 2012 64bit

Options: ReplyQuote
Re: performance issue of wampserver 2.5 on windows 2012
Posted by: Otomatic (Moderator)
Date: September 26, 2017 09:35AM

Hi,

> and listed below:
It's missing!

- Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
And you will find all the packages on [wampserver.aviatechno.net] in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.

------------------------------------------------------------------------------------------------------------
Wampserver 3.1.1 32 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
Wampserver 3.1.1 64 bit - Apache 2.4.29 - PHP 7.2.0/7.1.12/7.0.26/5.6.32 - MySQL 5.7.20 - MariaDB 10.2.9
PhPMyAdmin 4.7.5 - MysqlDumper 1.24.5
on W10 and W7 Pro 64 bit
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons
« Ce n'est pas parce qu'ils sont nombreux à avoir tort, qu'ils ont forcément raison. Coluche »
« It's not because they are many to be wrong, they are necessarily right. Coluche »

Options: ReplyQuote
Re: performance issue of wampserver 2.5 on windows 2012
Posted by: vxu (---.63.18.65.vultr.com)
Date: September 27, 2017 10:00AM

Hi Octomatic,

We have run the check_vcredist.exe to verify our VC++ packages, all the packages have been installed. However, the performance issue still exists, any other clues ?


Regards,
VXU

Options: ReplyQuote


Sorry, only registered users may post in this forum.