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

    or

    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

    SPONGURU
    "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
    etc...



    MohammedU.
    Moderator
    SQL-Server-Performance.com

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

Share This Page