www.webdeveloper.com
Results 1 to 6 of 6

Thread: Sql server memusage goes really HIGH

  1. #1
    Join Date
    Nov 2003
    Location
    California
    Posts
    248

    Unhappy Sql server memusage goes really HIGH

    Hi all, this topic is shouldn't be in here but i had no were else to go then this web site (the rest sucks) thanks to you all i can get good solutions to my problems. Now here is the question:

    The company that i work for has a really junky database (maybe it feels like it), because it is really working slow, we have a dual xeon cpu's with 2gb memory and plenty of hard space,

    We use access 2000 to connect to the database (until i complete pushing everything to .net and thats not going to happen soon ).

    I trace how the memusage is and i generally see access is building upmore memory usage in certen processes that has to happen day time by our processing department. normally the memory usage goes upto 1500, but when they use that process it goes up 5000 6000 8000 and i make them get out every time they get there,

    I was curious if there is a way to make access refresh its connection, because its a entry system and after every certain count of entries refreshing the connection would clean up memusage (like i make then restart the program).

  2. #2
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222
    Uhhh dunno. I have not really noticed the memory usage. You might try testing some other clients, such as the one integrated with webmatrix (Its a pain to use in real life but use it to test) and enterprise manager, etc. I generally use access for this myself too.

  3. #3
    Join Date
    Nov 2003
    Location
    California
    Posts
    248
    had to post other places ( http://www.access-programmers.co.uk ) this thing is hard to find. hopefully this place would answer its a access forum.

  4. #4
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222

  5. #5
    Join Date
    Nov 2003
    Location
    California
    Posts
    248
    Sure i will, no sound yet, they are not as fast as u are

  6. #6
    Join Date
    Nov 2002
    Location
    Auburn, AL
    Posts
    9,222
    Hopefully they are more helpful though!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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



Recent Articles