Thanks SQL4GNT

Thanks George,sqlbuddy,Grant & Jessie

Thanks George,sqlbuddy,Grant jessie

Thanks Grant and Selva.

What I am looking for is i need to get fragmentation details of particular indexes says indexes with name-A,B,C,D,E.......

Thanks a lot Gail.

Thanks a lot Eric and Grant.

Wow..reply from Steve..

Thanks a lot Steve

What i did is ,used SSIS transfer job task and for some failed jobs ,i scripted out those and executed .

Thanks Grant.

Thanks Gail,

I was actually going through

https://www.simple-talk.com/content/article.aspx?article=1426

Here we have Page Life Expectancy of 17999 and low Buffer Cache Hit ratio

SQLServer:Buffer Manager ...

Thanks for the reply..

I didnt find much tables used in query and the indexes in those tables seems proper.. The procedures are using table variables and temp tables mostly..

Thanks a lot Bill.

Thanks Grant and Steve .

We are creating a report to all server and just want to know whether i can find the apps installed from SSMS.

Thanks everyone.

Blocking by the same process itself is not a big problem .

Thanks a lot Gail & Jeff.

If your MAXDOP is 0 then you are fine.