SQL Server Performance

Database (DB Objects) Analysis - Urgent

Discussion in 'General DBA Questions' started by sponguru_dba, May 4, 2007.

  1. sponguru_dba New Member

    Hi all

    Any body having Database Desing Check audit list


    what are steps i have to take care while Analysisng
    existing Database(mainly DB Objects)

    some body guide or give steps

    I very much thankfull for your help

    "If Iam Wrong suggest me Right"
  2. MohammedU New Member

    Desing alnalysis is complicated...
    First you need to understand business requirement for effective analysis...

    1. Chek the objects have correct Referential intergrity...
    2. Tables have the right Indexes ...
    3. Check Procedure code for perfomance
    4. Check existence of Triggers and its need...
    5. Check the user/login access


    All postings are provided “AS IS” with no warranties for accuracy.

Share This Page