GilaMonster (7/15/2008)
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.?
If you are going to use the SQL Profiler, it does put some overhead onto the server, but again, it will depend on what you are actually looking for,as well as how many results you want in the profiler. Filter as much as you can in profiler will also decrease its overhead.
there are a number of other ways to check once you have the query that is running a long time.
what is diff between clustered index seek and bookmark look?
http://sqlinthewild.co.za/index.php/2007/11/15/execution-plan-operations-scans-and-seeks/
The bookmark lookup was renamed to key lookup in SQL 2005.
To answer this question,
Index Seek, is a good thing, means that it is using the clustered index and it is seeking only the rows it needs. If you read the previous post, it explains it very nicely.