Post reply

xp_MSADEnabled is very slow

  • January 7, 2003 at 3:39 am

    #58246

    When I'm opening the propriety page of a database within the EM it's very slow.

    It seems that the reason is the xp_MSADEnabled ext. SP.

    Do you know what it does make and how it can be speeded up?

    Actually it takes over 15 sec tu run and the code seems to be "very intelligent"

    DECLARE @retval int EXEC @retval = master.dbo.xp_MSADEnabled IF (@retval = 0) SELECT 1 ELSE SELECT 0

    Any idea?



    Bye
    Gabor

  • January 7, 2003 at 4:37 am

    #445697

    Saw this in another post on DBForums site.

    First in QA run

    sp_helptext xp_MSADEnabled

    you should get

    xpstar.dll

    back, if not then what do you get back. If so then it could be the path order in your environment variables.

    Right click on my computer on the server machine desktop and goto the Advanced tab in Win 2000 (may be different in yours if other OS). Anyway click Environment Variables button then scan down the top list in the dialog until you see path. Once found double click and copy the string out.

    Make sure the path for SQL is right as it will and alter as needed. Also, may try moving closer to the front of the list as this is the file search order and the further back the longer it will take.

  • January 7, 2003 at 5:57 am

    #445707

    Thanks!

    That was it!!!



    Bye
    Gabor

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply