Thanks Eirikur it was really helpful.

Thank you very much HanShi.

Thanks Sean and HanShi for your replies.

Smith - if server is slow then we should go with below approach -

1) Check network latency

2) Check disk I/Os - can be checked with performance monitor toll in windows

3)...

Thanks for better understanding Gail..

Thanks Gail and Vegard. As per my understanding as of now, committed transactions reside in transaction log file and they are marked to be saved permanently in datafile / disk...

Henrico,

I will try these all possbilities and let you know if something needed again.

Thanks a ton!

The issue still remaining same after all hits.

When I logged on with ABC and executed below script I could not find any result.

SELECT * FROM fn_my_permissions('sp_start_job', 'domain\ABC')

Even if I log on with other user who has sysadmin...

Sure Jeff, I am eagerly waiting for your reply.

Thanks

Hi Jeff, I understand the importance of xp_cmdshell. But it is special request by user which I can not deny. Please let me know how can I give execute permissions...

I have heard before upgrading upgrade adviser gives you so much concerns and we have to resolve those all issues that may arise. Sometimes upgrade adviser gives us blocking issues...

Somewhere I read paging is that if data pages are not found in cache and those pages have to be retrieved from disk is called paging. Please let me know...

Hi Steve, thanks for your reply.

Thanks

Hi All, following is the output of sp_wh2 active, I just could not understand why these all background processes taking much cpu.CPU usage always shows very high on server. Can...