| Foreword |
|
ix | (2) |
| Acknowledgments |
|
xi | (2) |
| Introduction |
|
xiii | |
|
|
|
1 | (20) |
|
Why Migrate to SQL Server 11? |
|
|
2 | (3) |
|
How Much Time and Effort Does a Migration Involve? |
|
|
5 | (1) |
|
Useful UNIX Tools and SQL Server Queries |
|
|
6 | (11) |
|
|
|
17 | (2) |
|
Migration Information Available from Sybase |
|
|
19 | (1) |
|
|
|
20 | (1) |
|
|
|
20 | (1) |
|
CHAPTER 2 THE MIGRATION PROCESS |
|
|
21 | (52) |
|
Which Sections of This
Chapter Should You Read? |
|
|
22 | (1) |
|
Development Systems and Production Systems |
|
|
23 | (1) |
|
Methods for Upgrading a SQL Server |
|
|
24 | (1) |
|
|
|
25 | (1) |
|
|
|
26 | (42) |
|
|
|
68 | (1) |
|
|
|
68 | (5) |
|
CHAPTER 3 UPGRADING TO SQL SERVER 11 IN A WINDOWS NT ENVIRONMENT |
|
|
73 | (20) |
|
Reviewing Your Server Hardware |
|
|
74 | (3) |
|
|
|
77 | (1) |
|
|
|
78 | (4) |
|
Configuring SQL.INl: The Windows NT Interfaces File |
|
|
82 | (2) |
|
|
|
84 | (1) |
|
Optimizing SQL Server 11 Performance on Windows NT |
|
|
85 | (5) |
|
|
|
90 | (1) |
|
|
|
91 | (1) |
|
|
|
92 | (1) |
|
CHAPTER 4 UPGRADING TO SQL SERVER 11 IN A UNIX ENVIRONMENT |
|
|
93 | (18) |
|
|
|
93 | (1) |
|
|
|
94 | (10) |
|
|
|
104 | (3) |
|
|
|
107 | (1) |
|
|
|
108 | (1) |
|
|
|
108 | (1) |
|
|
|
109 | (2) |
|
CHAPTER 5 CONFIGURING SQL SERVER 11 |
|
|
111 | (38) |
|
How Has Configuration Changed in SQL Server 11? |
|
|
112 | (1) |
|
What Are Configuration Parameters? |
|
|
113 | (1) |
|
Displaying and Setting Configuration Parameters |
|
|
113 | (2) |
|
Understanding the Configuration File |
|
|
115 | (14) |
|
New Configuration Features in SQL Server 11 |
|
|
129 | (15) |
|
|
|
144 | (1) |
|
Administration and Management Issues |
|
|
145 | (1) |
|
|
|
146 | (1) |
|
|
|
146 | (1) |
|
|
|
147 | (2) |
|
CHAPTER 6 THE BUFFER MANAGER |
|
|
149 | (40) |
|
Understanding How SQL Server 11 Allocates Memory |
|
|
150 | (2) |
|
Understanding the Data Cache |
|
|
152 | (3) |
|
Reducing Contention and Improving Scalability |
|
|
155 | (2) |
|
|
|
157 | (1) |
|
How DO Named Caches Reduce Contention? |
|
|
158 | (1) |
|
|
|
159 | (2) |
|
Getting Ready for Named Caches |
|
|
161 | (1) |
|
Managing the Default Data Cache |
|
|
161 | (2) |
|
Creating Additional Buffer Pools in the Default Data Cache |
|
|
163 | (1) |
|
Working with Named Caches |
|
|
164 | (8) |
|
|
|
172 | (1) |
|
Creating and Modifying Buffer Pools |
|
|
173 | (3) |
|
|
|
176 | (1) |
|
|
|
176 | (4) |
|
Why Disable or Enable Prefetching? |
|
|
180 | (1) |
|
The Fetch-and-Discard Strategy |
|
|
181 | (4) |
|
|
|
185 | (1) |
|
|
|
185 | (1) |
|
|
|
185 | (4) |
|
CHAPTER 7 SQL SERVER 11 ENCHANCEMENTS |
|
|
189 | (30) |
|
Improvements to the Logging System |
|
|
190 | (1) |
|
|
|
191 | (4) |
|
The New syslogshold Table |
|
|
195 | (3) |
|
Variable Log I/O Buffer Sizes |
|
|
198 | (2) |
|
|
|
200 | (7) |
|
Turning Databases online and offline |
|
|
207 | (1) |
|
Paritioning Tables for Improved Performance |
|
|
208 | (3) |
|
|
|
211 | (4) |
|
|
|
215 | (1) |
|
|
|
215 | (1) |
|
|
|
216 | (3) |
|
CHAPTER 8 MONITORING SQL SERVER 11 |
|
|
219 | (36) |
|
|
|
219 | (1) |
|
Using Sybase SQL Server Monitor |
|
|
220 | (3) |
|
Monitoring SQL Server 11 by Using showplan |
|
|
223 | (3) |
|
Using Statistics IO and Statistics Time |
|
|
226 | (2) |
|
Monitoring SQL Server 11 by Using dbcc 302 and dbcc 310 |
|
|
228 | (15) |
|
Monitoring SQL Server 11 by Using sp_sysmon |
|
|
243 | (8) |
|
|
|
251 | (1) |
|
|
|
251 | (1) |
|
|
|
251 | (4) |
|
CHAPTER 9 SQL SERVER 11 PERFORMANCE AND TUNING |
|
|
255 | (14) |
|
Improving SQL Server's Performance by Adding Memory |
|
|
256 | (1) |
|
Taking Advantage of SMP Systems |
|
|
256 | (2) |
|
Choosing Named Caches and Buffer Pools |
|
|
258 | (4) |
|
|
|
262 | (1) |
|
Increasing Performance by Setting tcp no delay |
|
|
263 | (1) |
|
Partitioning Tables to Improve Insert Performance |
|
|
264 | (2) |
|
Using Partitions to Improve bcp Performance |
|
|
266 | (1) |
|
|
|
267 | (1) |
|
|
|
268 | (1) |
| APPENDIX A SAMPLE BENCHMARK RESULTS |
|
269 | (4) |
| APPENDIX B NEW RESERVED WORDS, SYSTEM TABLES, AND SYSTEM STORED PROCEDURES |
|
273 | (4) |
| New Reserved Words in SQL Server 11 |
|
273 | (1) |
| New Reserved Words in SQL Server 10.x |
|
273 | (1) |
| New System Tables in SQL Server 11 |
|
274 | (1) |
| New System Tables in SQL Server 10.x |
|
274 | (1) |
| New System Stored Procedures in SQL Server 11 |
|
275 | (1) |
| New System Stored Procedures in SQL Server 10.x |
|
275 | (2) |
| APPENDIX C CONFIGURATION GROUPS |
|
277 | (6) |
| APPENDIX D COMMAND REFERENCE |
|
283 | (10) |
| APPENDIX E SYBOOKS INSTALLATION GUIDE |
|
293 | (32) |
| Index |
|
325 | |
