Post reply

sql memory usage

  • July 25, 2005 at 10:55 am

    #165406

    Hello,

    i got a problem wit my sql server.

    i got the perfmon turned on

    i'm load testing the server with about 20 inserts every 5 secs for three hours.

    the problem is dat after about 1hr sql stops receiving inserts and a look at the perf mon shows dat Available memory started at about 700mb and linearly droped to 300mb in 1hr

    my server has 1gb of RAM

    best regards

    Precious

  • July 25, 2005 at 11:43 am

    #576883

    What does your disk space look like?

    /*****************

    If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

    *****************/

  • July 25, 2005 at 12:11 pm

    #576892

    What is doing the inserts? When you look at Performance Monitor, what do the Target Server Memory and Total Server Memory counters (under SQL Server::Memory Manager) look like?

    K. Brian Kelley
    @kbriankelley

  • July 25, 2005 at 12:41 pm

    #576913

    Hello, tanks for ur prompt response u guys...

    i have about 40Gb HD space so i dont think dat shld b a problem...

    i use stored procedures to do the inserts...

    this is a scenario of the process...

    3 pc's on a lan

    every 5secs pc1 spins of 20processes dat call an asp page on pc2 (dats 20 page requests to pc2)

    pc2 calls a stored procedure dat basically does an insert to a table on pc3 (two processor server)..

    i hope this helps

  • July 25, 2005 at 12:48 pm

    #576917

    OK, what about the SQL Server memory counters?

    K. Brian Kelley
    @kbriankelley

  • July 26, 2005 at 3:43 am

    #577108

    tanks once again for ur response...i'm currently running my scripts again...(i dint add the counters for Memory Manager)i'l nid to check them after an hour cos dats when the problem starts

  • July 28, 2005 at 4:04 am

    #577805

    To me it seems unlikely that it could be a memory problem. If your SQL Server is configured using dynamic memory, it will try to grab all the (available) physical memory it can. So I wouldn't worry so much about SQL Server using a lot of memory...

     

    //Hans

  • July 28, 2005 at 5:09 am

    #577825

    finally got my counters, the Target server memory is 622416mb and the Total Server Memory is 45920mb, after about 1hr.

    Target server memory =621568

    Total server memory=45808

    i really dnt think its a memory prob again...

    cos i have noticed dat sometimes after about 5mins...the same proble starts...dats y i cudnt get the logs earlier...

    so wot do u guys think?

  • July 28, 2005 at 7:34 am

    #577858

    The target server memory counters tells you what SQL Server wants to have in order to run efficiently. The total server memory tells you what SQL Server is able to get. You've got a very big difference in those two numbers and that would indicate a potential memory issue.

    It looks like something else on the server is consuming available memory? What else is running?

    K. Brian Kelley
    @kbriankelley

  • July 28, 2005 at 10:04 am

    #577951

    i noticed my active transactions log =1

    is this normal

  • July 28, 2005 at 2:39 pm

    #578015

    There typically is only one active transaction log per database. Or do you mean number of active transactions?

    K. Brian Kelley
    @kbriankelley

  • July 29, 2005 at 1:58 am

    #578105

    i noticed theres a problem wit my transaction statements in my stored procedure, so i may hav a reentrant problem. id try to fix dat and then try my run again.

    and i meant SQLServeratabases(_Total)\Active Transactions

Viewing 12 posts - 1 through 12 (of 12 total)

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