I'm aware that SQL Server Express 2008 is having few limitations on the database size and the CPU utilization. In MSDN documentation it was mentioned on the express edition would use only one CPU.
I went through the following links but I'm not clear about this:
here and here
I have a quad core processor server.
I've installed SQL Server 2008 R2 Express Edition in my Win 7 notebook. The Express Edition doesn't have SQL Profiler enabled. Thus it's hard for me to debug my SQL 2005 applications.
I have a license for SQL Server 2005 (32 bit) and when I tried to install the client tools it gave a "known compatibility" error message.
We purchased around 50 PCs and the computer supplier will give us a free server PC with Xeon CPU but without OS installed in it.
On our new server, We're planning to put MSSQL Express and IIS for the following applications.
1. ASP.NET 4.0 website for around 5 concurrent users.
2. .NET 3.5 Windows Form application for 150 users with very minimal database query.
Hello,
I am working with visual studio 2008 and an external website host.
We have the following setup for an web application:
Server
Intel Xeon E5606 @2.13GHz (2 processors - quad core)
24GB RAM
Software
SO: Windows Server 2008 R2 Standard (SP1) x64
Microsoft SQL Server 2008 R2
Database environment description:
The SQL server is hosting 1 database that is accessible from our applications:
DB1 - production database (around 1.5 million records)
The application
I installed Windows Server 2008 as my OS, but I dislike the SQL Server Express which it provided by default, so I changed to SQL Sever 2008 Enterprise.
The problem is, I don't know how to remove the SQL Server Express edition. In Programs and Features under the Control Panel, I can't find the installation of SQL Server Express which was provided with the OS by default.
Not sure if this is a question for Stackoverflow or here, but I'm guessing here is more appropriate.
First of all, we have to use Windows Server 2003 32 bit R2 Standard (even though our server has a decent quad core processor and 8GB's of RAM (D'oh!)). Upgrading to Server 2008 R2 is sadly not an option.
I want to host a .Net 4 ASP.Net 4 website on this server.
We move from this server:
SQL Server Express R2 (has a 1CPU/1GB ram limit as far as I'm aware)
2GB Ram
2 core 2.1ghz
To this server:
SQL Server R2 Enterprise
8GB Ram
4 core 3.2ghz
Everything seems to be working fine.
What is the best performance setup for hosting an ASP.NET MVCv1 application?
I currently have 2 micro instances running, one to serve the database and another to serve the MVC application itself.
Email this page
