SQL Server & Memory Issues


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: SQL Server & Memory Issues

  1. #1
    Join Date
    Jul 2004
    Posts
    143

    SQL Server & Memory Issues

    I have developed an application with VB6 (SP6) + SQL Server which is running on a dual 3.0 Xeon server with Win2003 Server. I am running into an issue where nearly everyday we get an error about lack of resources when users try to logon. I check and the available physical memory slowly gets smaller. I found that if I stop the app and stop and start SQL Server I get the majority of the memory back for another 12- 18 hours. The users are accessing the app via remote desktop which attaches to MSTS. The server has 1GB of main memory. Would increasing this help? Is there some sort of maintenance to be run on SQL Server so I get the memory it is using back without having to stop/start it? Do I need to have separate servers? Thanks in advance for any suggestions.

  2. #2
    Join Date
    Apr 2005
    Location
    Pasay & Candon City, I.S., Phils.
    Posts
    22
    Are your sql's in your vb6.0 app optimized?

  3. #3
    Join Date
    Jul 2004
    Posts
    143
    Not sure what that means. They are all cnn.Execute "INSERT" or "UPDATE" or "DELETE".

Similar Threads

  1. SQL server vs Access
    By Samantha in forum Database
    Replies: 6
    Last Post: 01-25-2002, 03:15 PM
  2. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 11:04 AM
  3. Can Sql Server do this?
    By DavidR in forum Database
    Replies: 5
    Last Post: 02-15-2001, 12:46 AM
  4. Replies: 0
    Last Post: 02-05-2001, 10:28 AM
  5. Remove exchange from a site
    By andriano in forum Enterprise
    Replies: 1
    Last Post: 10-02-2000, 04:54 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center