多項選擇題

You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

A.Move tempdb onto a faster disk volume.
B.Increase the initial size of tempdb to 1.5 GB
C.Increase the size of the data files in the Tracking database.
D.Decrease the file growth increment for tempdb to 25 MB
E.Use more local temporary tables and fewer global temporary tables in the Tracking database.

你可能感興趣的試題

多項選擇題

You need to review the current storage system and decide on the best configuration for the tempdb database on SQL1 to improve tempdb performance. Your solution must ensure that company requirements and policies are fulfilled.Which two actions should you perform？（）

A.Create a RAID-1 set， and move tempdb to this drive set.
B.Create a RAID-0 set， and move tempdb to this drive set.
C.Set the starting size of tempdb to 3 GB
D.Create a RAID-0 set， and move tempdb and the user database with the largest index to this drive set.
E.Disable automatic file growth on tempdb.

單項選擇題

You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard disks for this server. What should you do？（）

A.Configure the hard disks as a RAID-0 array， and store the backups on this new array.
B.Configure the hard disks as a RAID-5 array， and store the backups on this new array.
C.Configure the hard disks as a RAID-10 array， and store the backups on this new array.
D.Configure the hard disks as a spanned volume， and store the backups on this new volume.
E.Use the hard disks to extend the volume that currently holds SQL Server backups.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

你可能感興趣的試題

You need to review the current storage system and decide on the best configuration for the tempdb database on SQL1 to improve tempdb performance. Your solution must ensure that company requirements and policies are fulfilled.Which two actions should you perform？（）

You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard disks for this server. What should you do？（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

You need to improve the performance of the tempdb database on SQL1.Which two actions should you perform？（）

You need to improve the speed of backups on SQL1. Management has approved the purchase of additional hard disks for this server. What should you do？（）