SQL Server Performance

update query problem

Discussion in 'General Developer Questions' started by mpolaiah, Mar 19, 2009.

  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
  2. FrankKalis Moderator

    It might help to post the table structure, indices, and the query... [:)]
  3. FrankKalis Moderator

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

Share This Page