Large MSSQL Databases And Harddrives
Oct 20, 2007
I have two servers which both run (very) large databases. To put that into context, one has about 40,000,000 database entries whilst the other has around 100,000,000.
These both currently run on 250GB SATA-II's. I'm considering adding a 147GB SA-SCSI 15k in replace for the 250GB SATA-II's for the live databases.
Would this be beneficial? I've no experience with faster speeded HDD's - especially on servers.
Reason I ask is I have some web applications which access these databases and can often take a while (minutes) to look up data.
View 2 Replies
ADVERTISEMENT
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
Aug 10, 2007
i currently have a database which is about 400mb
I am trying to use lxadmin to do a back up but it keeps crashing the db
how do i do the mysql back up?
i have ssh access
View 6 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
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
Mar 20, 2007
I am planning on starting a new project and am curious as to if there would be an issue with hosting the websites (IIS) and the MSSQL Databases on the same server?
Basically housing all of the websites and SQL DBs on the same server?
Is this going to cause major problems? I originally thought that I should house the DBs separate but am starting to think that we can house the web and dbs on the same machine but I wanted to get some advice from other that know more about Windows then I.
View 2 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
Jun 1, 2008
I have around 5 servers each running an instance of MSSQL. Four of them hold small databases (largest is 4GB) and all fairly active (I was monitoring the largest for around a minute with SQL Profiler and it used about 2000 rows).
The largest server is used as a central database for logs for the above four servers.
This server runs across 4 * 15k drives in RAID10, but the RAM is a huge bottleneck (64bit OS, 32bit MSSQL). I also watched this server for around a minute in SQL Profiler and saw around 2000 rows being used again.
Now I'm looking to centralise everything into a single instance of MSSQL. I can't afford for MSSQL to be slow, but it will be housing 7 databases (3 'main' databases, 3 log databases, 1 misc. database).
I'm looking at this:
- 2 * Quad Core Xeon 5405 - 2.00GHz (Harpertown)
- 12GB RAM
- 250GB SATAII - Windows installation / Programs
- 250GB SATAII - Backup drive, MSSQL transaction logs
- 10 * 73GB SA-SCSI 10k (RAID10) - MSSQL instance, all databases here
I'm just wondering if anyone could hazard a guess if this would be sufficient? I've tried to explain things the best I can. I guess to summarise would be that there are a lot of read and writes that would happen if I conbined all the databases into a single instance.
View 1 Replies
View Related
Apr 29, 2008
I see that SQL Server Express said to be free but does that mean its free for commercial use? personal use? development use? I don't see any information.
Also I read on this board that some hosts offer this. Are they just using the free free version or something else?
View 12 Replies
View Related
Jun 5, 2007
what is the best way to connect to a MSSQL from a Centos box?
View 2 Replies
View Related
Jul 15, 2008
I installed mssql support to my cpanel server as you mentioned on cpanel forums. When i request some data it gets charecters in error and writes them to mysql server.
I've installed this on previous server and didnt have this kind of problem.
I set same configs with old server (mysql.php,etc.) but it's not working.
[ http://forums.cpanel.net/showthread....ighlight=mssql ]
cPanel Ticket Message;
we are still having same problem on mssql, there are difference with 2 dedicated but we did not solved it yet. for example, you can see on first screenshot, there is some character errors while it getting datas on mssql server and we think that, it will cause problem and not showing totals but we did not have any problem on old server without characters problems
New server :
http://img142.imageshack.us/img142/2091/newservercc8.jpg
Old server :
http://img362.imageshack.us/img362/4138/oldserverzz0.jpg
View 0 Replies
View Related
Oct 20, 2009
I am looking for a company to host a relatively simple data driven ASP.Net 3.5 website and a MS SQL 2005 database. There will be minimal traffic on the website as it is for a small business and also minimal media will need to be hosted. Features like Ajax should of course also be enabled.
Data security is of importance although as the developer of the site, I would like the flexibility of being able to configure the database (run scripts) through management studio remotely.
Email features will also eventually be required.
The company should ideally be based in the UK and decent support id (and when) the need arises.
Any recommendations? What sort of price range should I be looking at?
Most companies seem to support MySQL- but this is not flexible.
View 10 Replies
View Related
Jul 8, 2008
I'm building the infrastructure for a live event site.
I have specced 8 app servers but I'm still unsure with regards to MSSQL.
The site functionality makes a single write to the DB with no reads. A simple option would be to have a MSSQL DB instance on each of the APP servers and simply collate the information after the event.
I've also been looking at the mirroring function of 2005 as it would mean we could get away with two MSSQL servers instead of 8.
Has anyone used MSSQL 2005 Mirroring? Is it easy to setup and maintain? Any caveats?
View 1 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
Aug 2, 2009
At the moment our MSSQL defaults to backing up db's to C:/Windows/Temp. On some occasions it backups up to the sql backup folder. Any ideas where these settings exist in MSSQL Management Studio?
View 1 Replies
View Related
Oct 11, 2009
I can see lot of MSSQL Server attacks. In event viewer "Login failed for user 'sa'. [CLIENT: Some IP]"
Most of the attack coming from Chaina. Tipically what I'm doing manually is get that entire IP range and block from Windows Firewall level.
Now I have plenty of blocked IP ranges all over the world.
What would be the best way to avoid from those kind of attacks ?
View 6 Replies
View Related
Jan 22, 2009
I use windows hosting and use plesk 8.3.0.1
I can see any icon except add database, inside the database folder.
In add database too i cant find any import or export option.
How do i upload a local database into my server?
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
May 3, 2008
I would like a VPS account, but the problem for me is that my site is asp.net and has a MS SQL 2005 database. From the research I have done so far, it appears that only the shared hosting solutions provide a MS SQL database, and if I go with a VPS solution I have to own and install my own copy of MS SQL. Is this correct? Does anybody know of a VPS solution that would also provide me with a MS SQL 2005 database as well? I can't afford to pay $5000+ for MS SQL 2005 Standard Ed.
View 9 Replies
View Related
Dec 2, 2008
I saw the suggestions to search around the site for good hosts, but it's really challenging to sort out the advertising vs real life experience and personal reviews.
Can anyone give some suggestions for a shared hosting service that can handle my needs for:
.Net 2.0
MSsql allowing remote databse connect
AJAX
about 12 domains
ability to allow several domains to work off the same database
prefer telephone tech support so I can call when things go down.
Tried Godaddy, but they don't allow remote connection to a database (good luck managing large projects)
Tried EasyCGI but not flexible enough
Tried Seekdotnet but even low traffic sites go down, they jumble which domains are connected to your ftp access (one time I had access to another clients html data), and take weeks or up to 'never' to fix hosting errors (fairly sure the errors were not due to the application.)
Heard about IXwebhosting but people don't seem to fond of them hear.
I'd really appreciate some honest input on reliable, reasonable, well supported windows hosting.
View 3 Replies
View Related
Jul 22, 2007
I am currently using phpdotnuke for a site, and have a forum linked to it supplied by activemodules.com. I would like to move to a non-cms site and something like vbulletin, so want to convert the forum db from MSSQL to MySQL - and hopefully keep all the posts and login data!
As a complete novice to that process, is there any pointers out there in terms of reading material, non-command line software etc I can use? Has anyone done this conversion, and what are the dangers?
View 7 Replies
View Related
May 20, 2007
I'm looking for a Windows VPS provider that offers .NET2 and MSSQL?
View 0 Replies
View Related
Nov 1, 2007
I have MSSQL 2005 running on the W2k server, can i install SQL Server Express on top of it w/o causing any disruption to other services including MSSQL.
View 2 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
Oct 26, 2009
We had a Coldfusion site running MySQL without issues. We are in the process of doing some upgrades and as part of that we recently switched over to MSSQL 5. Ever since that happened, we will have random page hangs. This usually happens on pages with more complex queries, but it is very random. There is no timeout error on the server, no page cannot be displayed errors, no errors of any kind, the page will just hang. We have been monitoring our server resource monitor and we can see when the page 'gives up', we will go from 100% CPU down to almost 0, and then the page simply never recovers. Does anyone have any idea what might be going on? When there is no error message of sorts it makes it very problematic to troubleshoot.
View 3 Replies
View Related
Mar 9, 2009
I've been paying $160 a month for a dedicated server that runs my web application and my mssql 2008 database.
Due to the economic times, I've been searching for a cheaper alternative... This gets me thinking... Wouldn't this be a good business plan for VPS companies?
Include 4-5 databases on a extreme, high-performance MSSQL server for all windows vps.
I know there are current setups like this, but no host really emphasizes the power of their mssql server. If they show how their db server is extremely fast, customers would be less likely to try and run their own express version on the vps. Thereby decreasing ram/cpu load on the vps, and increasing the overall efficiency of the dedicated server running the vps'.
Are there any hosts that currently market like this? If not, why don't you?
View 0 Replies
View Related
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
View Related
Feb 12, 2008
I'm currently with HostNexus and I've been told by their tech support that I need to submit a ticket every time I want one of my databases backed up. This is not going to work anymore and I need to find a new host that will allow me to create and FTP the backups to my home server.
My requirements:
At least 1GB disk space
Bandwidth won't matter as much right now
Allow me to have at least 15-20 domains on my account, I run a few different sites
Allow me to create a decent number of MSSQL databases (more than 5)
No MSSQL size quote (just let it subtract from the overall disk space)
A few MySQL databases
Both ASP.NET 2.0 and PHP 5
I need to be able to run that MSSQL backup via a Scheduled Task or something
I pay $20 but could go up to $30 if it has all the features + more space. DiscountASP.net seemed to have it all but I could only host one site per account and that just won't work. I did LOVE the thought of having a web service I could use to back up the DBs,
View 14 Replies
View Related
May 7, 2008
Any windows hosting provider with MSSQL database?
View 14 Replies
View Related
Jun 2, 2008
I see on one server with windows 2k3 and sql 2000 alot of Injection attemts(lucky so far) and 90% come from china.
Is there any way on iis6 to put range ban like 123.52.0.0 - 123.55.255.255 so to ban all that network?
View 1 Replies
View Related
