Question

On domain build DO executes query like

select msg.error, msg.description from [master].[sys].[sysmessages] msg join [master].[sys].[syslanguages] lang on msg.msglangid = lang.msglangid where lang.langid = @@LANGID and msg.error in (2627, 2601, 515, 547)

In some scenarios (i don't really know why) it takes more than two seconds. I assume it is used for exception messages, so, could you optimize it in two steps:

Use lazy initialize of this messages

Use another query, like this:

    DECLARE @MSGLANGID int;
SELECT @MSGLANGID = msglangid FROM [master].[sys].[syslanguages] lang
WHERE   lang.langid = @@LANGID
SELECT  msg.error ,
        msg.description
FROM    [master].[sys].[sysmessages] msg
WHERE   msg.msglangid = @MSGLANGID
        AND msg.error IN ( 2627, 2601, 515, 547 )

Exec plan

Answer 1

0

Hi pil0t,

try rebuilding the indexes. Usually this helps. But before you do that, it will be interesting to take a look at the execution plans for the above-mentioned queries.

Hope that helps.

answered Nov 29 '13 at 07:27

Dmitri Maximov
2211●1●2●11

Exec plan: http://goo.gl/nnWkkV

(Nov 29 '13 at 07:36) pil0t

Thanks. I tried these queries on my side with misc variations and your one showed the best results. I think, this is worth fixing.

(Nov 29 '13 at 12:50) Dmitri Maximov

Subscription:

Related questions