Results 1 to 3 of 3

Thread: P/T question

  1. #1
    Join Date
    Nov 2002
    Posts
    207

    Unanswered: P/T question

    I have a perfmon output as:
    "(Eastern Standard Time)","Memory\Pages/sec","SQLServer:Memory Manager\Target Server Memory(KB)","SQLServer:Memory Manager\Total Server Memory (KB)"
    "11/18/2004 10:30:04.750","692.29290389658956","6686608","6686 608"
    "11/18/2004 10:30:19.750","57.035332875362883","6686608","6686 608"
    "11/18/2004 10:30:34.750","50.946407096710089","6686752","6686 752"
    "11/18/2004 10:30:49.750","45.985057453103487","6686896","6686 896"
    "11/18/2004 10:31:04.750","80.718985188776941","6686608","6686 608"
    "11/18/2004 10:31:19.765","51.419713435012362","6686688","6686 688"
    "11/18/2004 10:31:34.765","83.316956075479524","6686784","6686 784"
    "11/18/2004 10:31:49.765","86.4656131714503","6686784","668678 4"
    "11/18/2004 10:32:04.765","184.19541457981779","6687008","6687 008"
    "11/18/2004 10:32:19.765","1594.8601288134912","6686784","6686 784"
    "11/18/2004 10:32:34.765","66.843390396403805","6686784","6686 784"
    "11/18/2004 10:32:49.765","66.840494677987792","6686928","6686 928"
    "11/18/2004 10:33:04.765","118.8274008488409","6686896","66868 96"
    "11/18/2004 10:33:19.765","317.40745114920139","6686896","6686 896"
    "11/18/2004 10:33:34.765","102.44640018841849","6686896","6686 896"
    "11/18/2004 10:33:49.765","144.69523847001818","6686896","6686 896"
    "11/18/2004 10:34:04.765","85.31078069975311","6686896","66868 96"
    "11/18/2004 10:34:19.765","201.69105891920668","6687040","6687 040"
    "11/18/2004 10:34:34.765","160.50180640532426","6687040","6687 040"
    "11/18/2004 10:34:49.765","82.745816941897289","6687040","6687 040"
    "11/18/2004 10:35:04.765","77.598868378704793","6687040","6687 040"
    "11/18/2004 10:35:19.765","144.36181802848549","6687040","6687 040"
    "11/18/2004 10:35:34.765","115.436326945804","6687200","668720 0"
    "11/18/2004 10:35:49.765","220.79121078389826","6687200","6687 200"

    Does this mean that if I add more memory to the box and allocate it to SQL Server, it will be beneficial?

    Thanks

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    These are very alarming numbers. How much memory DO you have?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Nov 2002
    Posts
    207
    We have 8GB on the box and 6GB (approx.) allocated to SQL Server. This is a very intensive i/o and oltp application.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •