A Stored Procedure Bogging down the Server


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: A Stored Procedure Bogging down the Server

  1. #1
    Merrill Nelson Guest

    A Stored Procedure Bogging down the Server


    I'm the software development manager at Total Business Solutions in Great
    Neck NY. A recent project we have been working on is giving me a little bit
    of a headache in that, I seem to have a Stored Procedure which happens to
    call several other Stored Procs and which is being passed it's parameters
    from the recordset of another Stored Proc, which seems to lock others out
    of being able to query the system. The users get a message saying that the
    "server is busy". The server is a dual 450 processor machine with 1 gig of
    RAM and I don't see why this series of Stored Procs should be bringing the
    server to it's knees. Is there something that I might be overlooking or is
    there any assistance you might be able to provide?

    Thanks in advance,
    Merrill Nelson
    Share on Google+

  2. #2
    Merrill Nelson Guest

    Re: A Stored Procedure Bogging down the Server


    "Merrill Nelson" <mnelson@tbsolutions.com> wrote:
    >
    >I'm the software development manager at Total Business Solutions in Great
    >Neck NY. A recent project we have been working on is giving me a little

    bit
    >of a headache in that, I seem to have a Stored Procedure which happens to
    >call several other Stored Procs and which is being passed it's parameters
    >from the recordset of another Stored Proc, which seems to lock others out
    >of being able to query the system. The users get a message saying that the
    >"server is busy". The server is a dual 450 processor machine with 1 gig

    of
    >RAM and I don't see why this series of Stored Procs should be bringing the
    >server to it's knees. Is there something that I might be overlooking or

    is
    >there any assistance you might be able to provide?
    >
    >Thanks in advance,
    >Merrill Nelson


    So it seems that when I went through and changed the cursors to Server Side
    instead of Client Side, this solved the problem... Just incase anyone was
    interested in a resolution...

    Merrill

    Share on Google+

  3. #3
    anandverma Guest

    Re: A Stored Procedure Bogging down the Server


    "Merrill Nelson"
    There is no issue of having more capacity of ram. just tell me the level
    of procedure calls
    and if possibel then optimize the sql joins in the procedure.
    encrease you Maximum size of server memory (MB) in ram i.e 1 /4 of total
    ram capacity.
    provided only os and sql server and application is running on the machine.
    and whta is you no of lock for all users that could be optimized, and last
    optimzes
    data bases size as compare to log zise of your corresponding database.


    Share on Google+

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