Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by y.koteswarrao, Oct 25, 2008.
How to find the long running queries & Network performance issues?
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
Separate names with a comma.