• I ran the DTA tool on testing server considering that SP & that DB,

    I got some object names in Index Recommendation & Estimated improvement = 0%, partition Recommendation = NULL

    Date1/24/2013

    Time7:32:52 AM

    Server182.16.14.151

    Database(s) to tune[test_DB]

    Workload fileC:\RND.sql

    Maximum tuning time58 Minutes

    Time taken for tuning1 Minute

    Expected percentage improvement 0.00

    Maximum space for recommendation (MB)16072

    Space used currently (MB)6126

    Space used by recommendation (MB)6126

    Number of events in workload4

    Number of events tuned4

    Now next what to be done???

    ************************************
    Every Dog has a Tail !!!!! :-D