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