MSSQL Database Intensive Hosting
Oct 4, 2009
We were on shared hosting until we were asked to move off due to our database using a lot of the CPU - how much, we dont know.
Anyway, moved to a 1GB Hyper-V VPS, seems like we have one core of an E5420 but presume the server is shared between 12 people.
When our ASP application runs, the MSSQL server reaches 100% CPU and the website performs slower than the shared server we were on.
Where can we go from here? Seems like going from shared to a Dual/Quad Core Dedicated Server is a large jump and a massive jump in price.
What about a host with a high performance dedicated server for MSSQL shared between customers.
View 14 Replies
ADVERTISEMENT
May 7, 2008
Any windows hosting provider with MSSQL database?
View 14 Replies
View Related
May 5, 2009
How can my user use MSSQL management studio to restore the DB? Whenever my user try to browse for the db file, he can't browse to his own web folder due to permission error.
View 12 Replies
View Related
Jan 5, 2007
one of my servers currently died (it was a 1u System) Dual Xeon, 3GB RAM. I need the DATA off my SCSI harddrives.. i have a 2U system only, but when i try and put the SCSI harddrive into the Machine, windows crashes on the "Windows 2003 " starting screen. Windows, ugh, horrible. I need to get into windows to get my MSSQL database's backed up and then moved to a new server.
View 11 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
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
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
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
May 19, 2008
what level of hardware/hosting plan I need for one of my clients.
Current stats:
~65 ecommerce orders per week
~5000 unique visitors per day
Requirements:
Win2k3
ASP.NET 3.5
MSSQL 2005
My first recommendation to them was RackSpace due their good reputation, but they were not able to pay for the plan suggested to them by RackSpace.
My other question is what type of plan do you guys recommend based on the above stats/requirements (managed/VPS/dedicated/etc.)? VPS is what came to mind for me since we'll probably end up using this setup for more than one website/domain and since they are so price sensitive.
I'm fairly comfortable setting up and administering Win2k3 and MSSQL. I'm sure that plays into the choices a little.
I know there is probably some information I have left out that would help you guys make a recommendation. Please just let me know what else would help.
View 8 Replies
View Related
Jul 1, 2009
Does anyone know any shared hosting or semi-private VPS hosting for a site with large MS SQL2005 DB? Our DB is currently 1GB already but could get up to 5-10GB when all is said and done. The site is a B2B networking platform with many users, company profiles, products, etc.
View 3 Replies
View Related
Dec 23, 2008
i am finding a MSSQL 2005 server for one of my application for my client.
Actually, it is a small business program. It will not have a heavy load on the server.
Do any hosting packages company for that with reasonable price? It is not a website. It is a C# software application. So the port will not be 21 or some web port.
View 3 Replies
View Related
Sep 8, 2009
I need a hosting with .net 3.5 support. Prefer 1G MS sql server space. traffic 10-20G is ok. need a stable hosting with good & capable technical support.
anyone can recommend one? I plan to use discountasp, but their sql is too small, 500M only.
View 13 Replies
View Related
Nov 30, 2007
I need europe based asp.net2.0 hosting with mssql, and approx. bandwidth and space 100Gigs-1000Gigs
multiple domains also price is <10$ ...
View 7 Replies
View Related
Mar 19, 2008
Since about 2002 I have constantly had my own co-located and then dedicated box. Before that, the only paid host I ever used was verio.net. Now that I sold off most of my sites, it is time to move to a smaller, shared hosting plan.
My question is can anyone suggest a good hosting plan? I do not need a lot of space or bandwidth, but I do require a few things:
- ASP.net 3.5 is a huge plus, but 2.0 is do-able
- At least one msSQL database
- Daily backups is also a huge plus. I don't need this second, but eventually I will want it.
- Good technical support is a must. I have dealt with to many companies even with my dedicated hosting that offered horrible tech support. A three day wait on a question is not acceptable. Phone support is a plus, but a 24 hour reply on an email is enough.
- ISAPI-Rewrite, or an equivalent is a must. I rewrite my URL's for SE rankings, as I believe everyone should, so the ability to host a rewrite script is a must. Though I use ISAPI-Rewrite, if their is an equivalent that is do-able.
- Need to be able to run at least (2) domains. My main company domain and then a second domain which is basically a landing page. In future I need a 3rd domain added, so ability to upgrade or add on a domain cheaply is a must too.
If you own a hosting company that matches this, or can suggest any please do so. If you suggest and they offer a referral program feel free to let me know your referral code as you obviously deserve the credit for suggesting the company.
View 9 Replies
View Related
Aug 4, 2008
I already have MSSQL 2005 on my server, one my the client requested us to install MSSQL express and they want to use the FOC version.
Can I run MSSQL server + MSSQL server express concurrently? Anybody can give me guidelines how to install it?
Do I need to uninstall MSSQL or it would be as easy as installing MSSQL express on top of MSSQL server.
View 5 Replies
View Related
Jul 14, 2008
I'm working on a new project that involves some heavy data processing in the preparation stage. As an example, one of the setup jobs is now running on a P4-3.0HT desktop at 100% CPU and I estimate it'll be finished in just under a week! Memory and i/o usage are minimal but it's extremely CPU-hungry.
There are other similar jobs to follow and some correlation between the number of cpu cycles and the quality of results so I foresee an ongoing need for computing power for at least a few months.
Viable options are to continue running my own hardware (probably supplementing the P4 with something a bit newer), Amazon EC2 or a cheap dedicated server - I can get a good handle on the cost and performance of each of these.
But I wonder if I'd get more bang per buck from a few VPSs? Some of the VPS benchmark results are spectacular so I suspect the answer could be yes, in the short term anyway. But I don't want to hog the host-node's CPU to the point where it degrades other users' performance or gets my account shut down... Then again, judging by the performance of the VPSs I've used for hosting the node seems to have a lot of spare CPU available...
So (finally) to the questions: Am I crazy to even consider this? If not, which technology would be most suitable? (I'm thinking Xen because of its reputation for better isolation.) Has anyone else done anything similar?
View 7 Replies
View Related
Aug 2, 2008
my client a dedicated server which could handle the following things.
1). Intensive DB queries done from many operators for custom project.
2).DB when info process completes, Generates a PDF which would be upto 10MB in size.and also runs MAPLAB Applications.
3). should be able to run back-up's or please suggest an alternative to always have a copy of recent data.
4). pro-active scanning on Incoming FTP content for Viruses. (is it possible ?)
Considering softlayer with:
either
Single Processor Quad Core Xeon 3220 - 2.40GHz (Kentsfield) - 2 x 4MB cache
8 GB RAM
+ 147GB SA-SCSI 10K RPM
OR Preferring
Dual Processor Quad Core Xeon 5335 - 2.00GHz (Clovertown) - 2 x 8MB cache
8 GB FB-DIMM Registered 533/667
+ 147GB SA-SCSI 10K RPM
View 9 Replies
View Related
Jun 12, 2009
I have two VPS's which run a single MySQL intensive site. The first VPS runs cPanel and has about 50 databases, 200mb each. Second has another 30 databases, of the same size.
What would be the best method to backup this website daily?
At Current;
I use automysqlbackup to backup all the databases at midnight (this crashes the VPS's for about 10 minutes each night). This dumps each one into a zipped file.
Then the rsync copies the changed files (forum attachmenets, cpanel changes etc(whole server)) to an off site location.
Are there any easier ways to do this? The databases are most important!
View 1 Replies
View Related
Apr 14, 2008
I own a couple of servers xeon setups. All use cPanel/WHM.
A client yesterday asked if we could have ffmpeg-php installed on the server so that they could run phpfox.
I have heared ffmpeg is resource intensive? Will it make a big difference on dual core server? Should I install ffmpeg-php or risk losing a client?
If I should install ffmpeg-php I have been having trouble doing so, can anyone help me with this.
View 4 Replies
View Related
Oct 22, 2006
I would like to know how resource intensive is ClamAV Scanner. Should I allow it or not to my VPS clients/resellers?
Can I set it to use it as root? How?
View 0 Replies
View Related
Mar 28, 2008
Calling on all hosting and server experts here. (If you're not an expert, still feel free to take an educated stab at this. But please leave out total made up answers or foolish answers like "Have LittleJoeShmoe Hosting services do it all for $9.99/month".)
Scenario:
If you knew or were planning on developing a site that you knew would generate millions to tens of millions of page views a day, how would you go about supporting a site of such traffic? The site would not serve up videos, but the average page size would contain up to 75-100kB. It would incorporate databases (user logins, accounts, user submitted content, server side scripting, CMS, etc.)
Don't assume anything. Don't assume you have too little or too much money. Just, what would you plan out to accomodate such a scenario?
What hosting companies would you use? Would you do it in-house and build your own datacenter? Farm out the server management? How much would it cost to implement your plan? What platform would you recommend for a site to handle this much traffic?
View 5 Replies
View Related
Aug 9, 2008
I have cpanel server
I found today that my server gets overloading - load spikes to 60 - 80
I sit down and watch top command for 1 hour. Suddanly I noticed that something is going on - loop0 process started to eat over 100% cpu
I tried to stop httpd on another console window using
service httpd stop
After 4 tries it stoped and then loop0 calm down and load lowered to normal size
(below 1)
View 3 Replies
View Related
Dec 27, 2007
I`ve just got a new Windows 2003 Web Edition box and now I`m going to install a database server on that.
MSSQL 2005 license would costs 270$/mo for me, So thats not possible to use it because of its price.
I`m not sure if MSSQL Express 2005 or MSDE (which are free) can handle all requirements of ASP.NET programmers or not.
Is there any limitations for major scripts on those? or will those make any doubts for programmers?
Please share your experiences and suggestions.
* I`m going to install "Hosting Controller" on that box.
View 8 Replies
View Related
Aug 9, 2008
I have a friend who has a dedicated server right now that uses a good 4GB for all his website content. (not streaming media but just a whole bunch of scripts and etc. well thats what he tells me). And so anyways, his SQL database is about 1-2GB. And he is not too sure about his monthly traffic but its a social networking site with a good amount of users (so its actively used by many users). Would it be necessary for him to have a dedicated server or do you think he could cut costs with a shared hosting account at like host gator or some other shared hosting service like that? I guess my biggest concern is his current database. A lot of shared hosting companies (from what i saw) offer unlimited Mysql Tables do they have size limits? And does a bigger sql database drastically effect the performance of the overall server?
View 14 Replies
View Related
Mar 26, 2008
I'm currently working for a company who are looking to migrate there current business system and also create an e-commerce website.
The company (Company A) who were doing the migration were also going to originally take care of the e-commerce side of things aswell, but after looking at the website solution they have now decided to give it to another company (Company B) to deal with. But seem to be sticking with the original company to do the business system migration.
Now this has created a bit of a problem with regards to the hosting side of things (amongst other things ).
Originally this was all going to be hosted by Company A. This would keep it all nicely integrated.
But now Company B are doing the e-commerce side of things it needs to somehow integrate with the business database.
And now for the question (about time i hear you ask ).
Can you give me the pros and cons of the following scenarios:
Scenario A:
We host both business system (database) and webservers onsite.
Scenario B:
Company A hosts business (database) solution. We host webserver.
Scenario C:
Company A hosts business (database) system. Company B hosts webserver.
View 2 Replies
View Related
Mar 5, 2008
I am developer and I ahve done web-site development and database development but it was for other companies where everything was already available.
I was not sure if this was the right place for the post, but I thought I would atleast start here, if I should post this in some other category please let me know.
I am satrting work on a Database driven web-site. I say database driven, becuase the web-site copares prices for multiple products. By some worst case scenarios(explained later) I need a database to easily acoomadate more than 1000 GB of data. I can definitely try cutting this down, but my question is what type of hosting should I choose and how when the web-site is completely relying on data that is updated on a weekly basis.
The reason to keep old data is to use that to show a Price history and forecasting on future Prices. The thought of storing this data locally and just creating a summary has crossed my mind.
The Data Scenario:
Price of Products per store: 50,000
Approximate size for the table per store: 3 MB
Number of stores: 500
Avg Size: 1500 MB
This is the bare minimum 1500 MB + other tables + overhead
Other tables: Forum data, Reviewes, User Favorite Products, etc.
Number of weeks: 52
Avg Size: 78 GB
Howevere the table with the most data and the table that would be changing the most is the Price table. So I am approximating the minimum requirement for the Databse to be atleast 2GB.
My question now is:
To be cost effective I can store the history on my personal desktop. But I still need something that allows me to have 2 GB of Database space. What is my best solution?
I have no strict rules about platform or langauge, to get started I am just trying to be cheap but still find a decent web-hosting solution so that by getting started small I have hopes of going big.
View 12 Replies
View Related
Apr 11, 2008
if there are any recommendations on managed database hosting services. This will be used for a fairly large project running on Mysql DB. Due to the size and complexity of the database a lot of resources are being used, so I prefer to find a company which specializes in dB hosting.
View 8 Replies
View Related
Sep 28, 2007
I have a website that runs off a mysql database.
The first month it hit in excess of 400 threads.
Would anyone know whats the cheapest alternative to run a a site this size. Would a VPS account handle it?
View 4 Replies
View Related
Jan 8, 2007
I'm wondering if someone can recommend a host to me. I know that researching a host before I go with it is important, this is part of my research.
I would like to make a site with ASP.NET 2.0 and a database (MS SQL preferred).
I'm just starting, so I don't have any traffic, but I don't want to rule out the possibility in the future.
I'd like a host that has no lock-in (Does not own my domain name, lets me backup and download my own database files) to a host that scales (allows me to upgrade plans easily, or purchase add-on space and bandwidth), although both are useful, I really don't want to be locked-in.
The site is not for profit (personal) and budget is a concern.
Right now Lunarpages Windows plan is looking good, it does give me a ‘free domain’, but specifies that they do not own it. Does anyone know how easy it is to transfer a free domain from lunarpages to godaddy or another registry? Has anyone had experience with this host for asp.net?
I'm also interested in finding a unbiased, legitimate host searching site that allows me to search hosts by features, with no affiliate links to the hosts reviewed, that do not sell hosting, etc.
View 2 Replies
View Related
Aug 17, 2008
I created a database for my site and then a subdomain.
The subdomain is already working but the database still shows pending setup. Normally, the database setup is much faster than the subdomain setup.
I'm not sure what's going on. Their email support sucks. They don't even reply on time. I can't call them because I'm overseas. It would be a very expensive phone call.
This is my first week with them. Do you guys experience this with Godaddy?
View 14 Replies
View Related
Nov 14, 2007
I created a SQL Server database that need sto be setup for the customer on their hosting account. The hosting company wanted the sql statemens, ok so I gave it to them to setup my tables and stored procedures. I also mentioned that if they gave me a username and password with database location and catalog name for the connection string and as long as I had create rights for that database I could run my own sql statements via SQL Server Enterprise Manager to set it up. They sent an excuse about how insecure that wasy and that they couldn't send any usernames or passwords for the database to me t set this up.
They also said it's becomming more common for Hosting Companies to not allow access to the databases for thatpurpose. Ok... uh how in the world do they expect to have a programmer create and run their data driven website without that information? I'm confused on what these guys are doing.
So.. is this true? Are more hosting companies hording their database infromation and customer usernames and passwords from the developers?
View 3 Replies
View Related