Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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
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

Your Answer


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.