select session_id,wait_duration_ms,

wait_type,blocking_session_id

from sys.dm_os_waiting_tasks where session_id >50 and blocking_session_id is not null

Run this and the before query I posted for daily thats it you are done.

Use the following query:

see the output query and the tables in the query.

select req.session_id, ses.login_name,req.blocking_session_id,sqltext.TEXT, req.session_id, req.status, req.command, req.cpu_time, req.total_elapsed_time

from sys.dm_exec_requests req left join sys.dm_exec_sessions ses on req.session_id= ses.session_id

cross apply...

you told you can see in database you told right.

So why don't you just open it as script as and right click on query analyzer and select tune with DTA.

Simple!

I don't see any problem in your server as you said. how you considering as a problem.?

Can you explain little more on that.

Hey Gilsha Thank you man for you rreply

recently I solved almost all the issues

by changing the configuration settings.