Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    20

    Question Unanswered: Slow performance in Sql server

    Hi

    We are facing performance related problem using Sql server 2000.

    We have one stand alone P4 Pc (128 ram) and around 30 users access the sql server through network.

    We have written our aplication in VB 6 and backend as Sql Server 2000. We have used Stored Procedure where ever necessary. We have used cursor location as Server side.

    When we start with 5 users it is not slow, when all the users say 30 comes in it is slow down.

    Can some one help to find out what is the problem.

    Thanks

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    128? 128 what? K? mb? gb?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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