DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: MS-SQL performance fine tuning

  1. #1
    Kyyap Guest

    MS-SQL performance fine tuning


    hi guys
    I have a DB server running on MS-SQL7.0 with WinNT4.0
    and with the hardware configuration as below
    Server Model : HP NetServer LH4
    Processor : Xeon 550MHz
    RAM : 256Mb
    Hard Disk : 3 x 9Gb configured with RAID-5
    Tape Drive : HP SureStore DAT24
    this DB server hosted in HQ office there are about 10 branches
    from outstation accessing it through WAN link doing online transaction
    ,recently we encounter some problem on the DB server when too many query
    running, and it prompt a message like this
    "A time out occurred while waiting for memory resources to execute the query."
    Is there any other way to fine tunning the performance of the DB server for
    the time being other then upgrade the physical memory of the server.

    thanks


  2. #2
    JC Guest

    Re: MS-SQL performance fine tuning


    you can have sql server use a minimum amount of memory per query. just right
    click the server and select properties then go to the 'Memory' tab. SQL server
    will then use the amount for every query. or you can set the minimum amount
    of memory that SQL server will use, the operating system will then reserve
    this much memory exclusively for SQL server.

    "Kyyap" <kyyap@genting.com.my> wrote:
    >
    >hi guys
    > I have a DB server running on MS-SQL7.0 with WinNT4.0
    >and with the hardware configuration as below
    > Server Model : HP NetServer LH4
    > Processor : Xeon 550MHz
    > RAM : 256Mb
    > Hard Disk : 3 x 9Gb configured with RAID-5
    > Tape Drive : HP SureStore DAT24
    >this DB server hosted in HQ office there are about 10 branches
    >from outstation accessing it through WAN link doing online transaction
    >,recently we encounter some problem on the DB server when too many query
    >running, and it prompt a message like this
    >"A time out occurred while waiting for memory resources to execute the query."
    >Is there any other way to fine tunning the performance of the DB server

    for
    >the time being other then upgrade the physical memory of the server.
    >
    >thanks
    >



  3. #3
    Join Date
    Jul 2009
    Posts
    10

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
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

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