Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

If I have two accounts, where:

  • both accounts have DBO level access (use the DBO schema to log in, and are part of the owner group)
  • one of the accounts is listed as the "actual owner"
  • both accounts are currently in use, and will continue to be in use, running long term (2+ hour) operations on the database
  • I want to switch the "actual owner" from one account to the other

What kind of performance impact should I expect to see on the database?

share|improve this question
add comment

1 Answer 1

up vote 3 down vote accepted

What kind of performance issues are you thinking of? There shouldn't be any impact with regards to performance. The only effects you should see would be related to security.

share|improve this answer
    
I imagine SQL Server will implement the security change gracefully. This means it won't drop existing connections and reset them to ones with proper permissions. Won't the existing connections, then, see a performance hit? All of a sudden the DB server is looking at two sets of permissions (old, changed) for each transaction –  blueberryfields Jan 18 '10 at 20:55
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.