You use a SQL Server 2005 database named DB1, which is located on a server named SQL1. DB1 is in use 24 hours a day, 7 days a week. A recent copy of DB1 exists on a second server named SQLtest that also runs SQL Server 2005. You detect a high number of full scans on SQL1 and conclude that additional indexes in DB1 are needed. A workload file that is suitable for Database Engine Tuning Advisor (DTA) already exists. You need to analyze the workload file by using DTA. You must ensure maximum performance on SQL1 during analysis. You must also ensure availability during the implementation of any recommendations suggested by the DTA. What should you do?()
A. Store the workload file on SQL1. Start DTA on SQLtest and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box, select the Generate only online recommendations check box.
B. Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the generate only online recommendations check box.
C. Store the workload file on SQL1. Start DTA on SQL1 and connect to SQL1. Specify all workload and tuning options as necessary. In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.
D. Store the workload file on SQLtest. Start DTA on SQLtest and connect to SQLtest.Specify all workload and tuning options as necessary.In the Advanced Tuning Options dialog box,select the All recommendations are offline check box.
查看答案
亏损产品是否停产的决策取决于()
A. 亏损产品是否能提供边际利润
B. 亏损产品是否能提供净利润
C. 亏损产品的销售收入是否大于其变动成本
D. 剩余生产能力是否有更好的用处
E. 其他产品是否停产
对于tomcat下面的说法正确的是()。
A. tomcat必须使用8080端口
B. tomcat在一台机器上可以运行多个
C. 虚拟目录必须在tomcat的根目录里
D. 不配置虚拟目录无法发布BS程序
特殊迁移的范围比一般迁移范围广。
A. 正确
B. 错误
J2EE中,HttpSession接口位于()包中。
A. javax.servlet
B. javax.servlet.session
C. javax.servlet.http.session
D. javax.servlet.htt