Re: Virtual SQL Server Transaction Log Auto-Grow problem.

From: Uttam Parui[MS] (uttamkp_at_online.microsoft.com)
Date: 11/10/04

  • Next message: JPW: "An unaware clustered resource service NetID is effected by Cluster" 
    Date: Wed, 10 Nov 2004 15:13:26 GMT

    Usually in a production environment, it is recommended to grow the data/logs manually as autogrow is expensive. This is the recommended route. This does not mean that we should not have Autogrow set. the
    default autogrow of 10% works good for small sizes and as the data/log sizes increases it is recommended that you change the autogrow from 10% to set size in MB. I would monitor the data and log sizes and
    manually increase the size such that it has enough space during peak times and set autogrow to 500MB or 1GB just in case it needs to autogrow.

    Also, it is highly recommended that you apply
    MS03-031: Security patch for SQL Server 2000 Service Pack 3
    http://support.microsoft.com/kb/821277

    This will get your SQL Server to build 818. This security patch is very critical to apply for security reasons and also has lots of fixes from build 760 (sp3a). Also, it has been released in July 03 and no issues reported.
    As with any other service packs/security patches/hotfix, it is important to test the patch first on a dev/test server and then apply it on prod server.

    HTH,

    Best Regards,

    Uttam Parui
    Microsoft Corporation

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.

    Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
    http://www.microsoft.com/protect
    http://www.microsoft.com/security/guidance/default.mspx

  • Next message: JPW: "An unaware clustered resource service NetID is effected by Cluster"

    Relevant Pages

    • Re: Help on transactional replication
      ... I have left the database/log size to autogrow and will keep an eye on ... keeping the distributor on a subscriber server instead of keeping it ... on how to read and understand processor and memory usage things. ...
      (microsoft.public.sqlserver.replication)
    • Bulk Insert Runs out of space
      ... I am running a Bulk Insert and getting the error that the PRIMARY file group ... All the databases in the server have the Autogrow check box ...
      (microsoft.public.sqlserver.msde)