Was this page helpful?

NRS

    Table of contents
    No headers

    Pb timeout on subscriptions / favorites ( 30 seconds by default for a query )

    Launch profiler and see the request for timeout
    Edit the ps to see which part is expensive .
    SSMS -> Execution plan to see the expensive part .
    Adding indexes on the table ENVID measure and msr id and the business temporary table temp ( in the code)
    Optimization related to the execution context .
    Good practice in PS
    Assigning arguments of local variables (if expensive in tps ) . set nocount on
    autoindexation in sql 2008
    The timeout problem found when loading subscriptions created (or favorites ) came from the stored procedure " ps_Web_MSR_Select " which took more than 30 seconds (30 seconds is the default timeout max ) .
    Optimization related to the execution context has been made ??:
    - Adding index at the temporary table # TempBusiness declared in the PS .
    - Adding index and ENV_ID MSR_ID on Reference.Measure table.
    - Adding index BSN_ID at the temporary table # TempBusiness declared in the PS .
    - Adding index and ENV_ID MSR_ID2 on Reference.Measure table.
    Following this optimization , the problem has not been found .

     

     

    Was this page helpful?
    Tag page (Edit tags)
    • No tags
    Page statistics
    1004 view(s), 1 edit(s) and 1374 character(s)

    Comments

    You must login to post a comment.

    Attach file

    Attachments