Database Serive stops responding on SQL Express 2005.
-
Hi, I have installed a SQL Server Express 2005 instance with default name SQLExpress on a machine running Windows 2003 Server. I have two databases on this instance with size 2GB and 1 GB(approximately) on this insance. These databases are accessed by a(Web based) .Net Application which is used by a maximum of 50 concurrent users.The application is a CRM for ticketing with Reports on the data punched by users. My problem is that some times the SQL Server Express stops giving any connections. If I go and check the Database Engine service status in SQL Server Surface Area Configuration tool it shows the serive as running. As a hack I stop the service and start it again and SQL Server starts givgig connections again. I have similar setup running in another location and that never gives such kind of problem. Please help me with this problem as any downtime on Database is questioned from us. thanks & regards, Aman
-
Hi, I have installed a SQL Server Express 2005 instance with default name SQLExpress on a machine running Windows 2003 Server. I have two databases on this instance with size 2GB and 1 GB(approximately) on this insance. These databases are accessed by a(Web based) .Net Application which is used by a maximum of 50 concurrent users.The application is a CRM for ticketing with Reports on the data punched by users. My problem is that some times the SQL Server Express stops giving any connections. If I go and check the Database Engine service status in SQL Server Surface Area Configuration tool it shows the serive as running. As a hack I stop the service and start it again and SQL Server starts givgig connections again. I have similar setup running in another location and that never gives such kind of problem. Please help me with this problem as any downtime on Database is questioned from us. thanks & regards, Aman
I think this might be the cause of Unclosed connections. Always use using block and also Before you leaving the block use connection.close(). ;) And hey, you are using SQL Server Express 2005 in production environment.. :omg: This is weird. You need to keep in mind of the limitation of 4 GB Database size and 1 GB of RAM Usage. :sigh: There is as such no limitation of Concurrent Connection, but if you go on creating connections, it will soon run out of resources. Also you cant include 2 -4 GB ram because of Limitations. :(
Abhishek Sur
My Latest Articles **Create CLR objects in SQL Server 2005 C# Uncommon Keywords Read/Write Excel using OleDB
**Don't forget to click "Good Answer" if you like to.