Microsoft® SQL Server® 2012 Bible

504

Part V: Enterprise Data Management

Don’t use this feature in new development work because it will likely be removed in the next version of Microsoft SQL

Server. Plan to modify applications that currently use this feature.

Use the sp_addlinkedserver feature instead.

Transactions are explained in Chapter 47, “Managing Transactions, Locking, and Blocking.”

Network-Packet Size

Packets are blocks of information sent over the network to transfer requests that results

between clients and servers. You can change the network-packet size from its default of

4KB by using the network packet size option. However, the network-packet size should

rarely need reconfi guring. Consider this property a fi ne-tuning tool and use it only when the

data passed tends to greatly exceed the default size, such as large text or image data.

In Management Studio, you can set the network packet size option by entering the

new size (in bytes) in the Network Packet Size box on the Server Properties Advanced tab

(refer to Figure 19-10).

The following code sets the network-packet size to 2KB:

EXEC sp_configure 'network packet size', 2048;

RECONFIGURE;

The sys.dm_exec_connections dynamic management view contains information about the network-packet

size (column named net_packet_size) used for information and data transfer.

Advanced Server-Confi guration Properties

The advanced server-confi guration properties, as shown in Table 19-6, enable you to set

advanced SQL Server confi guration options.

TABLE 19- 6 Advanced Server-Confi guration Properties

Property Level* Graphic Control Code Option

FILESTREAM Access

Level

S Management

Studio

EXEC sp_configure

'FILESTREAM access

level'

Extensible Key

Management

S- EXEC sp_configure 'EKM

provider enabled'

c19.indd 504c19.indd 504 7/30/2012 5:43:04 PM7/30/2012 5:43:04 PM

http://www.it-ebooks.info