SQL Server Performance
  1. jkipkangor New Member

    I have SQL Server 2000 being used in a supermarket. The DB has grown to 4GB! Now the client computers are stalling. We are experiencing problems. Is there a script that can truncate all past transactions? But remain with the list of items etc.
  2. satya Moderator

    What Edition of SQL server you are using?
    There is no point in deleting the data, rather look at measure to fine tune the performance.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  3. jkipkangor New Member

    Sql 2000 Personal Edition on a P4 computer.
  4. jkipkangor New Member

    Besides these the client machines are on a 11mps wireless network....this would probably be one setback.
  5. Adriaan New Member

    It's probably the log file that has grown to 4 GB, because of simple recovery model.

    --- The following is a very brief description of what you might do. Please wait for posters who know more about maintenance to respond in detail. ---

    If it is indeed the LDF file that is 4GB, and not the MDF file, then ...

    Make sure all users are disconnected.
    In Enterprise Manager, detach the database.
    Delete the LDF file.

    In Enterprise Manager, attach the MDB as the database.
    It will tell you it could not find the LDF file, and that it has created a new one.

    Change the recovery model for the database.
    Set up a proper maintenance plan with backups of the log file.

    ***

    Get onsite support for a permanent solution. This might involve using a proper server, and/or an edition of SQL Server that is suitable for a production environment.
  6. satya Moderator

    Hope you have more insight to fix the issue.

    The recovery model for a new database in Personal Edition defaults to Simple Recovery. Personal edition is used by mobile users who spend some of their time disconnected from the network but run applications that require SQL Server data storage. Also used when running a stand-alone application that requires local SQL Server data storage on a client computer.



    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page