Hi, Recently, I am evaluating a copy of Quest Spotlight on my development system in order to try to find some bad SQL code. However, I can view the blocking/lock session SP briefly before the screen will not show any data. Those blocking/locking session screen will be empty. Is there any document or articles to guide me how to use it ? In addition, with the information from spotlight, how do I go about using the information like those SP that cause locking/blocking to good use or tune my SP ? Anyone that have use it, pls kindly advise and guide me. Thank you [:I]
I know my English is no good, but I answered your question few days ago. Please read: http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=878 and if you need more information, I would like to help. Luis Martin Moderator SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important Bertrand Russell All postings are provided “AS IS†with no warranties for accuracy.
