Post reply

SQL Server doesnt responses!

  • April 19, 2004 at 8:33 am

    #101967

    Hello

    I have a program that inserts records to a SQL Server 2000 Database, it inserts the records through a Stored Procedure, the program calls the Stored Procedure a lot of times.

    The problem is that the memory that SQL Server uses begins to grow constantly while the program is running until it uses all the system memory !!!

    Then SQL Server doesn't response and the next insert calls fail.

    The Stored Procedure is created only one time at program startup, and when I need to call it I pass only the parameters and execute it, I do it with an ADO Command

    The program is developed in VB 6.0 with ADO 2.5+

    How I can fix this?

    or Do I have to change something in the way I do the process?

    Thanks

  • April 19, 2004 at 8:57 am

    #503355

    Have you put a hard cap on the amount of memory that SQL uses? Give the Operating System 1Gb of memory to work with. That should help with your system memory issue.


    Shamless self promotion - read my blog http://sirsql.net

  • April 19, 2004 at 8:26 pm

    #503413

    You said that the memory SQL server uses keeps on growing but just in case you are suffering on the VB side, remember that if you repeatedly call the create function for the Command object (ADO) you MUST also call the release function (Set xxx = Nothing). Otherwise you will orphan a lot of unaddressable memory. Same with the CreateParameter calls.

    Dim xx as ADO.Command

    Set xx = new ADO.Command

    .....(set parameters then execute)

    Set xx = Nothing

     

  • April 20, 2004 at 3:47 am

    #503445

    it is recommended not to use any other program on the SQL Server machine.

    because SQL Server is monster in dealing with data ...

    if there is any other program you will on SQL Server machine, then set Maximum Memory to SQL Server .. so SQL Server reserve this memory and work on it.

    Note: it is recommended to ADD extra Memory to your SQL Server Machine if there is Weekiness in performance.

    I hope this help u


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • April 20, 2004 at 8:19 am

    #503495

    Thanks

    I configured my test SQL Server machine to use 40 MB maximun of RAM, just for testing purposes.

    But if I check the RAM used by sqlservr.exe, it exceeds the 40 MB configurated by myself !

    How does this limited RAM work for SQL Server?

  • April 20, 2004 at 8:27 am

    #503500

    what is your total RAM? because 40 M is so so little for SQL Server


    Alamir Mohamed
    Alamir_mohamed@yahoo.com

  • April 20, 2004 at 9:40 am

    #503511

    I just want to test if SQL Server doesn't use more RAM than I give it

    That's all

    I have 256 MB in my test machine

    Any suggestions?

     

    Thanks

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply