Results 1 to 5 of 5

Thread: Big Database

  1. #1
    Join Date
    Feb 2004
    Posts
    25

    Unhappy Unanswered: Big Database

    Hello all, i have a problem with a big database, the problem is that any query executed on that database, takes much much time, but i think that the db is over sized (5 gb aprox), because the table that contains most records has only 650.000, and i worked with db containing tables with more records and that not pass 1 gb.

    Question 1: Why the db has grow so big?
    Question 2: What can i do to speed up the querys?

    Thanks for your help, and sorry for my english!

  2. #2
    Join Date
    Feb 2004
    Posts
    25

    Lightbulb The problem is the log

    I see that the database file has 650 mb (that's ok) but the log file has 5350 mb (that's absolutly wrong), i tried to truncate or shrink log file, but does'nt work.

  3. #3
    Join Date
    Apr 2004
    Location
    Kansas City, MO
    Posts
    734
    If you are not doing transaction log backups, you need to set the recovery mode to simple. After this, shrink the files and they will disappear to almost nothing. You only need full recovery mode, which is what you are probably using if your log files are that big.
    MeanOldDBA
    derrickleggett@hotmail.com
    When life gives you a lemon, fire the DBA.

  4. #4
    Join Date
    Feb 2004
    Posts
    25

    Thumbs up It really work....

    hey, i have reading a bit about that question of the recovery mode, but thanks for your suggestion, now my DB has 560 mb only!, that's great, but, the querys are a little bit slow yet!

    Remember, i'm a programmer, not bilingual! jejeje

  5. #5
    Join Date
    May 2004
    Posts
    7
    Hello parmaia,
    If you interested in making the queries to execute faster - I would start with doing a performance audit of your box . Check out sql-server-performance.com , Brad M. McGehee did a very nice series of articles on how to audit sql db server

    http://www.sql-server-performance.co...ance_audit.asp

    If you run into questions, ask (either here or within sql-server-performance forums)

    simas

Posting Permissions

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