Re: General Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

anonymous_at_discussions.microsoft.com
Date: 08/03/04

  • Next message: Pete Scalercio: "query cannot be executed" 
    Date: Tue, 3 Aug 2004 12:06:53 -0700

    Another thing to consider is the size your log file can
    grow to if your database is particularly busy. As a rule
    of thumb, on a busy database, I plan for 5-6 times the
    data file for a log file and then put in a job to shrink
    that log file down regularly.
    >-----Original Message-----
    >How big is your log file? You don't say, but if it is
    500MB that only
    >leaves you 1.5GB. That is not a lot of room...I would
    probably order
    >another disk now. Then again, if you only add 20MB per
    day you have some
    >time.
    >
    >--
    >Keith
    >
    >
    >"Noor" <noor@ngsol.com> wrote in message
    >news:uZdnayUeEHA.3732@TK2MSFTNGP11.phx.gbl...
    >> I want to ask one general question like let's suppose I
    have a database
    >and
    >> the data file and transaction log for the database are
    located on a 9.1 GB
    >> hard disk. Both files are configured for automatic file
    growth. The data
    >> file occupies 7 GB of disk space. I want calculate when
    I will need to add
    >> additional disk space.
    >>
    >> Should I go with Configure System Monitor to log disk
    space utilization OR
    >> Configure a SQL Server Agent job to execute the
    sp_spaceused stored
    >> procedure each day and then to store the results of the
    procedure to a
    >table
    >> in the database
    >>
    >> Thanks
    >> NOOR
    >>
    >>
    >
    >.
    >

  • Next message: Pete Scalercio: "query cannot be executed"

    Relevant Pages

    • Re: Balance I/O
      ... Is it a good idea to decrease the disks which are near 100% busy? ... files on the same disk spindle? ... Redo log file switch frequency (only need to execute this the last ... session to determine the SQL statements executed by the session, ...
      (comp.databases.oracle.server)
    • Re: How to attach db with missing log file?
      ... Start SQL Service ... Database fake will appear as suspect in EM ... I support PASS - the definitive, ... > allowing me to get past the missing log file, ...
      (microsoft.public.sqlserver.server)
    • RE: Shrink File?
      ... As my understanding of you problem, you have a database with a data file ... in the log file. ... You can truncate only nonactive portion of the transaction log. ...
      (microsoft.public.sqlserver.setup)
    • Re: PerfMon recording to SQL 2005
      ... seconds or even every ne second) from a busy server to a database on ... On the Perfmon counter Log Files tab, SQL Database has been set, End File ... Configuring the log file, choose the tested DSN as the System DSN ... The user account I created in SQL is an owner of the ...
      (microsoft.public.sqlserver.server)
    • Transaction log problems
      ... just before you backup the ... database change the recovery model to ... Simple, shrink the log file then change it back to Full, ... >transaction log and it is causing us some problems. ...
      (microsoft.public.sqlserver.server)