SQL Server Performance

Help on Quest Spotlight use needed

Discussion in 'Third Party Tools' started by vladimir_sim, Nov 29, 2005.

  1. vladimir_sim New Member


    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]

  2. Luis Martin Moderator

    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.



Share This Page