How to find the long running queries & Network performance issues?

Regards

koteswar Rao.Y

do a quick live search you will find tons of articles that explain how to do this. Its not a config setting that you can find in properties.. it involves lot of fact finding and analysis. there are lot of articles that explain in detail on how to do that.

Heres one : http://code.msdn.microsoft.com/SQLExamples/Wiki/View.aspx?title=LongRunningProcs&referringTitle=Home

http://sqlserver-qa.net/blogs/perftune/archive/2007/05/25/identify-and-troubleshoot-slow-running-queries-in-sql-server.aspx too.