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

    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
    Pasay & Candon City, I.S., Phils.
    Are your sql's in your vb6.0 app optimized?

  3. #3
    Join Date
    Jul 2004
    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, 02:15 PM
  2. Access to SQL server
    By Nate in forum Database
    Replies: 29
    Last Post: 05-09-2001, 10:04 AM
  3. Can Sql Server do this?
    By DavidR in forum Database
    Replies: 5
    Last Post: 02-14-2001, 11:46 PM
  4. Replies: 0
    Last Post: 02-05-2001, 09:28 AM
  5. Remove exchange from a site
    By andriano in forum Enterprise
    Replies: 1
    Last Post: 10-02-2000, 03: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
Latest Articles
Questions? Contact us.
Web Development
Latest Tips
Open Source

   Development Centers

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