Post reply

Performance of distributed queries

  • July 7, 2005 at 1:23 am

    #109990

    We have environment of two node servers.On first node we have stored procedures in which is call stored procedures on secound node accros defined linked server (OLE DB provider).The a results (duration percept) is different,execute sp on first node 30 s ,on secound <2 s.I use statement (with recompile to recompile a stored procedure next time it is run&nbspon secound server node.

  • July 13, 2005 at 10:37 am

    #574021

    Not quite sure what your question is - distributed transactions have an overhead but rpc calls are usually pretty quick. Any number of issues can cause different run times ona server - especially stats and indexes.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

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

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