1. mpolaiah New Member

   Hai All,
   i am using the sql server 2000.in my application 20 users are used and my table have 170000 records when 20 users apply the update query then the sql server performance is decrease when sql server restart then only performance is increase. How to slove the problem
   regards
   pols
   

   mpolaiah, Mar 19, 2009

   #2
2. FrankKalis Moderator

   It might help to post the table structure, indices, and the query... []
   

   FrankKalis, Mar 19, 2009

   #3
3. FrankKalis Moderator

   ...btw, what is your service pack and fix level?
   

   FrankKalis, Mar 19, 2009

   #4

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in