April 27, 2011 at 8:04 am
Hi All,
Does extracting schema ,producing SQL DDL script will impact the performance on the production server?
Thanks in advance
April 27, 2011 at 8:57 am
Nothing you ever do on a server is free. Yes, it impacts performance, but not very much at all. It should only take out some shared read locks on system tables that prevent schema changes from running. If your code is regularly changing your schema (and it's probably not a good thing if it is), you might see some blocking, but that's an edge case. Normally I would expect your server not to notice this at all in any way.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
April 28, 2011 at 2:56 am
Thanks a lot
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply