|
发信人: reynolds(雷龙.DBA中) 整理人: reynolds(2002-04-02 13:08:03), 站内信件 |
| 6. You are the administrator of a SQL Server 2000 computer that contains a database. Users report that queries to this database respond slowly. You use System Monitor to examine the subsystems on your server and receive the results shown in the exhibit (in the exhibit, the % processor time remains at 100 all the time). You need to modify the server to accelerate query response time. What should you do?
A. Increase the amount of RAM. B. Upgrade to a faster disk subsystem. C. Add a faster network adapter. D. Add an additional processor. Answer: D Reason: 处理器性能接近100%是明显的处理器负担过重，该题目其实不属于SQL2K的题目。 7. You are the administrator of an SQL Server 2000 computer. You create a job that performs several maintenance tasks on the server’s databases. You want the job to run whenever the server’s processor utilization fails below 5 percent. You create a new schedule for the job and specify the ‘start whenever the CPU(s) become idle’ option. After several days, you notice that the job has never executed, although the server’s processor utilization has fallen below 5 percent several times. What should you do? A. Modify SQL Server Agent properties and specify a smaller idle time. B. Modify SQL Server Agent properties and specify a larger idle time. C. Write a stored procedure that executes the job whenever the GGIDLE system variable is less than 5. D. Write a stored procedure that executes the job whenever the GGIDLE system variable is greater than 1. Answer: A Reason: 修改方法-〉服务器-管理-SQL SERVER代理-属性-高级 8. You are the administrator of a SQL Server 2000 computer. Your company modifies a sales application it uses so that it can access data from a SQL Server database rather than a Microsoft Access database. You configure the new SQL server database. The tables are configured as shown in the table schema exhibit (exhibit not available). Users report that queries to this database respond slowly. You use System Manager to analyze database activity and receive the results shown in the exhibit (exhibit not available). You need to modify the database to accelerate query response time. What should you do? A. Place primary keys and foreign key indexes on the table. B. Remove all indexes from the tables. C. Replace the table joins with correlated subqueries. D. Use a server-side cursor to retrieve data. Answer: A Reason: 没有图形，没有原因 9. You are the administrator of a Microsoft Windows 2000 Advanced Server computer. The server is also running SQL Server 2000 and contains a database named sales, as shown in the exhibit below: See http://www.cheet-sheets.com/228/image1.jpg 
The sales database is configured by using the default options and increases by 50MB per day. You want an operator to be notified automatically before the database runs out of disk space. You also want to minimize the amount of administrative overhead necessary for this database. What should you do? A. Configure System Monitor to log an alert if the hard disk database contains less than 600MB of disk space. Configure SQL Server Agent to send an e-mail message notifying the operator of the System Monitor alert. B. Create a SQL Server Agent job that uses the sp_spaceused stored procedure each morning. Place the results of the stored procedure in the e-mail message and set SQL mail to send the results to the operator. C. Set the Maxsize property of sales_data.mdb to 7.5GB and the Maxsize property of log file to 1.5GB. Configure SQL Server Agent to send an e-mail message to an operator when the data file and the transaction log have reached these limits. D. Use Microsoft Windows Explorer to verify the available space on the hard disk each morning. Execute the sp_spaceused stored procedure each morning. Answer: A Reason: sp_spaceused存储过程并不反映逻辑磁盘的剩余空间，因此B错误。如果选择C，那就糟糕了，真到了一点儿剩余空间都没有的时候你就知道惨了！D？天天看这个，系统管理员可以什么事情都不做了吧。 ====================================================================== 首先，你必须使用Diskperf -yd命令开启逻辑和物理磁盘计数器功能，然后重新启动系统，只有这样你才能看到LogicalDisk计数器条目，后面的事情就是你来定义一个警报。 但是性能和SQL代理如何协同工作，我还没有搞清楚。:( ======================================================================= 10. You are the administrator of a Microsoft Windows NT Server 4.0 computer. The server is the PDC in your domain and also runs SQL Server 2000. The server has four processors and 1GB of RAM. Your network consists of 600 client computers that are running Microsoft Windows Millennium edition. Users report that when they log on in the morning their computers respond slowly and occasionally return error messages. You use System Monitor to monitor processor performance and RAM utilization. You discover that the %Total Time and %User Time counters average 90% and the %privileged time counter averages 20 percent. The available Mbytes counter averages 600MB. You need to improve server performance for user logons. What should you do? A. Increase the physical RAM on the computer to 2GB. B. Increase the virtual RAM on the computer to 4GB. C. Configure SQL server to use only processors 1, 2, and 3. D. Configure SQL server to use only processors 0, 1 and 2. Answer: C Reason: 0处理器用于处理登录、验证等请求。 ---- / <>< o /| / <>< (o / |/| ) ) <@ < ( O )( \ |\| <>< ) <>< () \| \ \ 每天在网易游水的鱼 |
|
[关闭][返回] |