How can we help you today? How can we help you today?

Flooding the server with collation requests

Every time I click somewhere in the Management Studio (2005) there seems to be some delay. It is so bad I have to switch of SQL Prompt to get any work done. The server is remotely located so there is always some delay, but now it is REALLY bad :wink:
Right Clicking a tab to make a new vertical group takes forever...

I tried looking into the Profiler for some clues and there seems to be some calls that are made "all the time".

The origin seems to be
exec sp_server_info @attribute_id = 18

Resulting in
Attribute_id Attribute_Name attribute_value
18 COLLATION_SEQ charset=iso_1 sort_order=nocase_iso charset_num=1 sort_order_num=52

Seems to be one of those things that could be cached either pr server connection or at least pr tab/window ?
dottNett
0

Comments

1 comment

Sort by
  • Lionel
    Well spotted! The problem is whenever the editor window gets focus it checks to see if the connection has changed. It needs the current collation to do this and this information should be cached but Having looked at the code I am acidedetally bypassing the cache. I will stick this on in our bug tracking system and it will definatly get fixed for the final release. Sorry for the anoying bug.

    Lionel
    Lionel
    0

Add comment

Please sign in to leave a comment.