PHP/Database Performance On Windows
Jul 19, 2008
I've got an app that I've built using FastCGI, PHP, MS SQL and it's currently running on a single IIS 6 (Win2K3) server. The MS SQL database is very large and some of the pages return large result sets so I've also installed memcached to cache the data.
Right now the web app and the database are both running on the same server. I'm looking at moving the database to a 2 node cluster, and the web server to it's own 2 node cluster for higher availability. But I've got a couple of questions:
1. Would IIS 7 (Windows 2008) be faster than IIS 6 (Windows 2003)?
2. Would Apache (on Windows) be faster than IIS?
3. Can Apache be clustered?
4. Would it make more sense to have a load-balanced pair for the web servers instead of an active-active cluster?
5. How does IIS 7 Kernel Mode caching compare to using memcached?
6. Would there be any decrease in performance if the database is running on another machine instead of the same machine as the web app?
7. Should memcached run on the web servers (which will be storing and retrieving the data), on the database servers (which actually has the data), or on it's own dedicated server?
View 0 Replies
ADVERTISEMENT
Jul 22, 2008
will this be a good product to give VPS solutions for service providers? how's the performance of virtuzzo in Windows?
View 5 Replies
View Related
Mar 8, 2008
Since my linux server is out of disk space, I just use cifs to mount some drives from the windows server for people to download files (usually 100-200mb/file).
But I found the performance is not good. For example, I need to wait for a long time before the download process begin. Also, it seems the load average of the server becomes high too.
Is there any suggestion? Should I mount the windows drives through cifs? Or should I change to another server which allow me to add more local harddisks? How about if I mount drives in other linux machine, will the performance better?
View 1 Replies
View Related
Nov 27, 2007
I have a Windows 2000 Advanced Server where there's a performance issue with some of the .asp pages that retrieve data from Access databases, (I know Access databases aren't ideal for data). These pages will just get stuck/freeze, and then either suddenly spring back to life, or give a script timeout error 0113.
The largest Access database I've seen is 136MB (is that way too large?)
I will probably move some of the large Access databases onto a different server but before I do:
- Are there any tools you can recommend to diagnose exactly what files / databases are causing the problem. I don't think the Win 2000 performance monitor tools even work.
- Can anyone explain more about the technicalities behind this issue. I expect it has something to do with processes, threads, memory, Access drivers being loaded into memory etc etc. Can anyone tell me what they know to put me in the picture better?
View 1 Replies
View Related
Jan 3, 2015
I noticed that all my client websites were as slow as a snail snot before uninstalling perl and Python.
Is it normal that perl and python components slowing down IIS?
I search online, it is a common scenerio for those two to slow down IIS.
After I uninstalled perl and python as well as awstat, the site are working as fast as before.
View 2 Replies
View Related
Jul 13, 2007
I am using dreamhost host 3 of my web sites and 1 blog. Dreamhost is great, offers alot space and bandwidth.
but I think they are oversellling their space, sometimes it gets really slow. (overselling ? ok, I dont really know, but sometimes its really slow, and most my asian readers said need to refresh to load the page. I am wondering if theres a way to check if they are overselling or not.)
I am thinking about buying vps, even tho, I still got 5 month left with dreamhost.
I found 2 vps companies are highly recommanded on this forum, JaguarPC and LiquidWeb.
theres already a post compared both companies in terms of price and service. I say I will pick JagarPc, cuz, its basic plan just 20 USD, and htey got promotion now, its even cheaper. and basic Liquidweb vps plan is 60 bucks.
I am wondering why Jagarpc is so cheap , are they overselling? how can we check if they are overselling.
I found a few posts saying how good jaguarPc is. and they are not overselling, but those members just signed up this month, and only have 1-3 posts. I cannot really trust those new members.
Can someone share their experience with JaguarPC? compare JaguarPc performance and liquidweb performance. antoher question is switch from dreamhost to JaguarPC basic vPS plan, will performance gets better?
last question: VPS account allows 3 IP, 3ip = 3 domains? if not, how many domains can I have?
View 14 Replies
View Related
May 7, 2008
Any windows hosting provider with MSSQL database?
View 14 Replies
View Related
Nov 24, 2014
I got this error when i try to active an account in Plesk.
Error: DNSZone::Table::select() failed: no such row in the table
And when o try to solve issue by the following steps,
1) Login to mysql psa database using the plesk administrator password,
cd %plesk_dir%Mysqlin
mysql -h 127.0.0.1 -uadmin -p -P 8306 psa
I got : Unknown psa Database...I'm ensure that database is founded on the server under C:Program Files(86x)MysqlData
View 11 Replies
View Related
Dec 14, 2013
Trying to restore a database in plesk 11 I got the following error.
Error: dbbackup failed: Unable to restore database 'database_name'Could not load file or assembly 'Microsoft.SqlServer.ConnectionInfo, Version=11.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.
There is no wrong with the db, when I restore from it on local machine everything works.
View 2 Replies
View Related
Feb 28, 2014
when i try to make backup of mssql 2012 on plesk 11.5 i have the following error:Error: dbbackup failed: Unable to backup database 'DBANME'. Unable to open connection: A specified logon session does not exist. It may already have been terminated.i already configured temp/network directory,
View 6 Replies
View Related
Feb 26, 2015
I created a mssql database. When I click on the weasmin link I go to a 404.Also when I log in as administrator and go to Tools & Settings >>>Database Servers >>>>>click on the .MSSQLSERVER2012 then webadmin it will open myLittleAdmin for SQ Server and I can see the datases.
View 4 Replies
View Related
Jun 24, 2015
I have a problem with restore ms sql server 2008 database after restoring the message...Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror
View 1 Replies
View Related
Mar 8, 2015
I installed plesk win 12 with mssql2012 , but nobody as abale to restore DB via plesk we recive this error Error: dbbackup failed: Unable to restore database 'degardis'Format of the initialization string does not conform to specification starting at index 29.the backup file is restored straight via sql management studio.
View 1 Replies
View Related
Sep 18, 2012
I restored some some databases outside of Plesk in a MSSQL 2008 instance. Plesk knows about the MSSQL intance but is not aware of the databases. I want to add them to Plesk so they will be backed up.
View 2 Replies
View Related
Jul 22, 2015
Unable to restore database '17'
Not valid backup:
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupclub-panel.irdatabases171.bak'. Operating system error 5(Access is denied.).
VERIFY DATABASE is terminating abnormally.
(Error code 22)
---------------------- Debug Info -------------------------------
View 1 Replies
View Related
Jul 1, 2008
recommend me about a good hosting provider for those requirements: Windows IIS hosting, support for .NET 2.0, MS SQL 2005 Database & ISAPI_Rewrite?
View 4 Replies
View Related
Apr 2, 2015
I've created a website for a client using Sitefinity CMS and MS SQL Server 2008 R2. I've transferred the database from my local SQL server to the production server using SQL Management Studio.
I've created a customer and subscription for hosting the website and it's all up and running perfectly. However, I want to automate the backup of the SQL database for the website which I can only do if the subscription knows about the SQL database for that website. So, how do I associate the two? How do I get the database to show up in plesk for that customer such that it can be part of the scheduled backups - and of course also somethign I could restore via plesk if I had too?
The database exists. It wasn't create via plesk in any way, but I want plesk to be able to back it up, and ideally for it to show up in the customers subscription, etc.
View 1 Replies
View Related
Apr 22, 2013
I have read about people wanting to change their database from MSSQL to MySQL. I however am wanting to change from MySQL to Microsoft SQL in our Plesk panel.
View 7 Replies
View Related
May 2, 2013
I have daily backups for all accounts setup on our Plesk 11 server and was wondering how I would go about restoring a single database from the backup manager? I could restore the entire zip file, but that would make a mess of any other databases which of course isn't optimal. I see if I download a client's zip file that within the zip_file/databases/db_name there is another zip file which contains a tmp file which for a MySQL database it looks fairly standard, for MSSQL it looks to be in their format but is this what's really necessary? Can I even use those tmp files to restore manually through the Backup Manager -> Database Backup Repository? Why isn't there a simple way for a client to restore a database with the existing backups?
View 2 Replies
View Related
Feb 24, 2015
Plesk12 on IIS8.5/Windows2012r2.
For a migrated site, how can I associate an existing DB with a subscription? The only option I see is to add a new database and this is not a new database?
View 1 Replies
View Related
May 26, 2014
my plesk server was running OK for the last 13 months and suddenly it breaks apart on its own and I cant make it work again. [URL]
Is there a way to backup database at this stage? How?
Planning to reformat my windows server. and start over.
View 1 Replies
View Related
Mar 17, 2015
I expored my databse fom my old hoster and want to import it to my new Windows Server 2012 r2 vps Server but I can't find that option:
I found this link: URL....
my dashboard looks like this, it is missing the Backup Manager: Image: "dashboard.png"
View 4 Replies
View Related
Feb 5, 2014
I have vps server with win server 2008 and Plesk 11.5.30. when i am trying to copy Mssql Database trough the panel i have an error: " Unable to copy database ". In the %plesk_dir%adminlogs under the php-error.log i have this error:
"[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Database cloning failed.
[05-Feb-2014 13:31:43 Europe/Helsinki] ERR (3) [panel]: Task failed: id=163, pid=9700, type=db-clone, error=Unable to clone database."
View 7 Replies
View Related
Jun 13, 2014
I'm trying to restore a 600MB database which was uploaded to the repository in plesk. This database backup did NOT originate from this server, but rather I'm attempting to overwrite a blank database that was created with the same name via plesk.
The site is one of our web-spaces (not a customer subscription) so I am logged in as the plesk administrator.
System Info:
Plesk 11.5
Windows 2008 R2 (64Bit)
3GB RAM
MySQL 5.1
Full Error: dbbackup failed: Unable to restore database 'databasename' Exception of type 'System.OutOfMemoryException' was thrown.
I have tried altering the php.ini the PHP settings of the site (even though I'm logged in as the adminsitrator) as well as the php.ini of: C:ParallelsPleskadminphp.ini
memory_limit=2048M
It fails with the error after about 1GB of RAM usage on the server.
View 1 Replies
View Related
Feb 3, 2015
WINDOWS SERVER Plesk Panel version 12.0.18
Error: Test the database server connection failed:
mysqlnd cannot connect to MySQL 4.1+ using the old insecure authentication. Please use an administration tool to reset your password with the command SET PASSWORD = PASSWORD('your_existing_password'). This will store a new, and more secure, hash value in mysql.user. If this user is used in other scripts executed by PHP 5.2 or earlier you might need to remove the old-passwords flag from your my.cnf file
View 1 Replies
View Related
Jun 23, 2014
After Plesk Panel upgrade to 12.x I found a warning showing at Home>Tools & Settings> Database Servers
Warning: Unable to determine the TCP port number used by Microsoft SQL server '.SQLEXPRESS': TCP/IP protocol is not enabled in the server network configuration or the server is configured to use dynamic TCP ports.
To allow your customers to automatically configure firewall for remote database access, manually configure the SQL server to listen on a specific fixed TCP port.Click to expand...
View 3 Replies
View Related
Aug 13, 2013
Since we upgraded to Plesk 11.5 or (I'm not shure) the last Update 12, user can not import MySQL-Databases anymore.
If the user open phpMyAdmin for import and select the database and click on Ok, phpMyAdmin does nothing.
I heard that could be a problem with JQUERY and I checked the files in ParallelsadminhtdocsdomainsdatabasesphpMyAdminjsjquery and all files seems to be there.
Only if I check the source of the phpMyAdmin Import-Website it seems, there is a problem with jquery-1.6.2+fix-9521.js.
But how I can fix this problem for all Windows-Servers.
View 19 Replies
View Related
Mar 20, 2014
I have Plesk Windows version, when I want import my backup mysql, i see below error:
Error: dbbackup failed: Unable to restore database 'admin_IranDnn'
ERROR 2006 (HY000) at line 1: MySQL server has gone awayClick to expand...
View 7 Replies
View Related
Dec 23, 2014
I'm having a problem with Plesk Panel 11.0.9 update #64. All other page running perfect. But when I go to "Backup Manager --> Database Backup Repository --> Upload Backup File" then Plesk Panel show error: Internal Server Error 500.0.
On server, it show detail below: .....
View 2 Replies
View Related
Mar 28, 2015
12.0.18 update #39
Server 2012r2
Logged into my panel today to run a database backup on a site I'm working on to be confronted with the following:
Unable to backup database 'XXXXXXXXXX'
Cannot open backup device 'C:Program Files (x86)ParallelsPleskBackupXXXXXXXXX.co.nzdatabasesXXXXXXXXX-29 est'. Operating system error 5(Access is denied.).
BACKUP DATABASE is terminating abnormally.
(Error code 21)
I'm not sure why permissions would change on their own, I'm also not sure how to fix the permissions error. I get the same error on all databases.
PrivateTemp folder appears to have write permissions for Group MSSQLSERVER
View 6 Replies
View Related
