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 have an asp.net 4.o application running on window server 2008 and a oracle 11G database server running on linux.
There is two database server with same virtual ip.
Recently some how one database server went down and another database server starting working.
Every thing went perfectly on database server site with small problem of oracle listener
But on my application server memory start increasi
I have a dedicated server.its specifications are as follows
Intel xeon processor 2GH x 2,
3GB Ram,
500 GB Hard disk drive.
I am using SQL server 2008 r2 express as database
The website is developed in Visual studio 2010.
The server will also serve database to vb.net applications within the firewall.
Is it enough.
I am developing an application for billing system(in c sharp), i need to have a small database to store the bills and retrieve as and when required. I don wish to go in for any mysql, postgresql kinda dbs where i need to have a client server model ... what other databases u think can i use for this BILLING APPLICATION IN C# .NET
A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article count limit.
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.
I'm trying to connect to my SQL Server express instance from my ASP.NET web application but it doesn't work. The generic error message given to the application is:
Cannot open database 'xxx' requested by the login. The login failed.
I am confused for my project to deploy it on the server. Should I use two server (one server for application code and another server is for database) or ONLY single server for both i.e. application and database? So that the performance may be fast.
Please suggest which is the best option and why???
Thanks in advance
I have a SQL Express 2008 R2 server running on a server in an internal lan network. A few databases are used by some third party software to store data. A SQL-Server user is used by this application to connect to the database.
Now I need to access this database using a local installation of the software from an external pc.