Engine Watch

database engine technology and SQL Server

April, 2005

  • Engine Watch

    SQL Server 2000 Sizing and Capacity Planning

    • 1 Comments
    Found two useful things on the internet today: Planning for Consolidation guide from microsoft: http://www.microsoft.com/technet/prodtechnol/sql/2000/plan/sql2kcon.mspx A guideline from network appliance: http://www.netapp.com/tech_library...
  • Engine Watch

    Beginner: Manage database file size

    • 1 Comments
    <Rewrote from my newgroup post> Case: 4GB database with two "big" tables: 1.5 million records, table with almost 1 million records, and each month, import about 300,000 records, also delete some old records. database goes up to 5 or 6 GB and...
  • Engine Watch

    plan caching in sql 2005

    • 0 Comments
    I have not posted for almost 2 weeks. I have been very busy with Yukon work. Today this paper come to my attention, I think it is very useful for anyone who are interested in performance tuning in SQL 2005. http://www.microsoft.com/technet/prodtechnol...
Page 1 of 1 (3 items)