1
kudos
spam Kudos Remove

Performance impact: Linked server security configuration and how it can hurt you

posted by sasa 1031 days, 3 hours, 58 minutes ago
Sunday, July 26, 2009 6:38:40 AM GMT

If you change the security configuration of a linked server from using login UserA to login UserB, would you expect that to significantly impact the performance of a query that uses the linked server, assuming that both users have permission to select from the remote table referenced in the query?   Many people probably would answer no. After all, as long as the connection has the permission to access the remote table, how the connection is authenticated should not matter, right? Well, it’s more compli...

category: Management | clicked: 2 | | source: sqlblog.com | show counter code
tags: Performance

No comments yet, be the first one to post comment.

To post your comment please login or signup