shahbaz.oradba (7/14/2008)
Hi,how can we know that particular query is taking long time and we have to optimize that,and i heared that query optimization through sqlserver profiler degrades the perfomance.?
what is diff between clustered index seek and bookmark look?
Profiler is a GUI for server side traces. You can setup a server side trace that logs long running queries which will have minimal impact on performance. See BOL for how to.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question