Resource usage of SQL Server 2005 Generate Script
Home > IT Answers > SQL Server > Resource usage of SQL Server 2005 Generate Sc...
Db23
230 pts.
0
Q:
Resource usage of SQL Server 2005 Generate Script
SQL Server 2005, SQL Server performance, SQL Server performance tuning, SQL Server Scripts, SQL Scripting
Hi,

I am wondering how resource hungry the Generate Script for SQL Server 2005 is. We are planing to script out one of our production database on a production server that has over 1000 object to script, and wether this will have more affect on SQL performance during the scripting?

Thanks.

ASKED: Oct 13 2009  12:28 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
46735 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
It shouldn't put to much load on the server. All the client does is query for the meta data about the tables. The client does most of the heavy work. As long as you don't do it on the servers console you should be fine.
Last Answered: Oct 13 2009  7:26 PM GMT by Mrdenny   46735 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0