دسترسی نامحدود
برای کاربرانی که ثبت نام کرده اند
برای ارتباط با ما می توانید از طریق شماره موبایل زیر از طریق تماس و پیامک با ما در ارتباط باشید
در صورت عدم پاسخ گویی از طریق پیامک با پشتیبان در ارتباط باشید
برای کاربرانی که ثبت نام کرده اند
درصورت عدم همخوانی توضیحات با کتاب
از ساعت 7 صبح تا 10 شب
ویرایش: نویسندگان: Belt. TJay, Berry. Glenn, Borland. Jes, Bossy. Carlos, DeBow. Ben, Johansen. Jesper, Pastrick. Wendy, Prajdić. Mladen, Fritchey. Grant, Pot'vin. Kellyn, Roggero. Herve, Strate. Jason, Davidson. Louis, Shaw. Chris, Lowell. Jeremy, Ball. Bradley, Gardner. Jonathan, Shaw. Gail سری: ISBN (شابک) : 9781430247715, 1430247711 ناشر: Apress سال نشر: 2012 تعداد صفحات: 494 زبان: English فرمت فایل : PDF (درصورت درخواست کاربر به PDF، EPUB یا AZW3 تبدیل می شود) حجم فایل: 51 مگابایت
در صورت تبدیل فایل کتاب Pro SQL Server 2012 Practices به فرمت های PDF، EPUB، AZW3، MOBI و یا DJVU می توانید به پشتیبان اطلاع دهید تا فایل مورد نظر را تبدیل نمایند.
توجه داشته باشید کتاب تمرینات Pro SQL Server 2012 نسخه زبان اصلی می باشد و کتاب ترجمه شده به فارسی نمی باشد. وبسایت اینترنشنال لایبرری ارائه دهنده کتاب های زبان اصلی می باشد و هیچ گونه کتاب ترجمه شده یا نوشته شده به فارسی را ارائه نمی دهد.
Annotation, Pro SQL Server 2012 Practicesis an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012. With an emphasis upon performancebut also branching intorelease management, auditing, and other issuesthe book helps you deliver the most value for your companys investment in Microsofts flagship database systemGoes beyond the manual to cover good techniques and best practicesDelivers knowledge usually gained only by hard experienceFocuses upon performance, scalability, reliabilityHelps achieve the predictability needed to be in control at all timesWhat youll learnMigrate to the new Extended Events framework for troubleshooting performance problemsAutomate the tracking of key performance indicators such as available disk space, cpu utilization, index fragmentation, and moreDesign performance into your database and its applications from the very beginningManage staged releases from development to test through to productionDiagnose resource and performance problems via dynamic management viewsAnalyze I/O patterns and plan reliably to obtain the performance you needWho this book is forPro SQL Server 2012 Practices is aimed at SQL Server professionals who want to further their careers through expert-level practices in performance management, scalability, predictability, and security. Table of ContentsJesper Johansen. Be Your Developers Best FriendLouis Davidson. Getting It Right: Designing for Database PerformanceGail Shaw. Hidden Performance GotchasKellyn Potvin. Dynamic Management ViewsMladen Prajdic. From SQL Trace to Extended EventsChris Shaw. The Utility DatabaseJason Strate. Indexing Outside the BubbleTJay Belt. Release ManagementJonathan Gardner. Compliance and AuditingJes Borland. Automating AdministrationWendy Pastrick. The Fluid Dynamics of SQL Server Data MovementHerve Roggero. Windows Azure Features for DBAsJeremy Lowell. I/O: The Untold StoryBradley Ball. Page and Row CompressionGlenn Berry. Selecting and Sizing the ServerGrant Fritchey. Backups and Restores Using Availability GroupsCarlos Bossy. Big Data for the SQL Server DBABen DeBow. Tuning for Peak Load.
Cover......Page 1
Contents at a Glance......Page 3
Contents......Page 4
About the Authors......Page 484
About the Technical Reviewers......Page 489
Acknowledgments......Page 491
Audience......Page 493
Example Code......Page 494
My Experience Working with SQL Server and Developers......Page 13
Reconciling Different Viewpoints Within an Organization......Page 14
Step 1: Map Your Environment......Page 15
Step 2: Describe the New Environment......Page 17
Step 4: Create System-Management Procedures......Page 19
Step 5: Create Good Reporting......Page 22
Ensuring Version Compatibility......Page 23
Logon Triggers......Page 24
Next Steps......Page 27
Chapter 2: Getting It Right: Designing the Database for Performance......Page 28
Requirements......Page 29
A Really Quick Taste of History......Page 31
Why a Normal Database Is Better Than an Extraordinary One......Page 32
Physical Model Choices......Page 44
Design Testing......Page 51
Conclusion......Page 52
Predicates......Page 54
Residuals......Page 70
Spills......Page 76
Conclusion......Page 81
Understanding the Basics......Page 82
Groups of Related Views......Page 83
Varbinary Hash Values......Page 84
Retrieving Connection Information......Page 85
Showing Currently Executing Requests......Page 86
Locking Escalation......Page 88
Finding Poor Performing SQL......Page 89
Using the Power of DMV Performance Scripts......Page 91
Optimizing Performance......Page 93
Inspecting Performance Stats......Page 96
Top Quantity Execution Counts......Page 97
Locating Missing Indexes......Page 98
Partition Statistics......Page 103
Sessions and Percentage Complete......Page 104
Conclusion......Page 110
SQL Trace......Page 111
Trace rowset provider......Page 113
Trace file provider......Page 117
Event Notifications......Page 120
Extended Events......Page 124
Predicates......Page 125
Types and Maps......Page 126
Targets......Page 127
Sessions......Page 128
Built in Health Session......Page 131
Extended Events .NET provider......Page 133
Extended Events UI......Page 135
Conclusion......Page 143
Chapter 6: The Utility Database......Page 144
Daily Checklist Items......Page 145
Longer-Term Checklist Items......Page 146
Data Storage......Page 147
Creating the Utility Database......Page 149
Table Structure......Page 150
Extended Stored Procedures......Page 152
Storage......Page 153
Processors......Page 155
Error Logs......Page 157
Indexes......Page 158
Stored Procedure Performance......Page 160
Failed Jobs......Page 161
Reporting Services......Page 162
Mirroring......Page 163
Managing Key Business Indicators......Page 165
Automating the Data Collection......Page 167
Scheduling the Data Collection......Page 168
Conclusion......Page 169
Chapter 7: Indexing Outside the Bubble......Page 170
Identifying Missing Indexes......Page 171
Index Tuning a Workload......Page 179
Index Business Usage......Page 200
Data Integrity......Page 202
Conclusion......Page 204
My Release Management Process......Page 205
A Change Is Requested......Page 206
Considerations......Page 207
Documents......Page 215
Release Notes......Page 216
Release Plan Template and Release Plans......Page 220
Conclusion......Page 227
Sarbanes-Oxley......Page 228
Health Insurance Portability and Accountability Act......Page 230
New Auditing Features in SQL Server 2012......Page 231
Audit Filtering......Page 232
Server Audit......Page 233
Server Audit Specification......Page 235
Database Audit Specification......Page 237
Query the Audit File......Page 238
Pro Tip: Alert on Audit Events......Page 239
Conclusion......Page 241
Performance Monitor......Page 242
Dynamic Management Views......Page 244
SQL Server Agent......Page 245
Maintenance Plans......Page 259
SQL Server Integration Services......Page 266
PowerShell......Page 269
What to Automate......Page 270
Monitoring......Page 271
Backups and Restores......Page 274
Index Maintenance......Page 276
Conclusion......Page 277
Why the Need for Replicating Data?......Page 278
SQL Server Solutions......Page 280
Replication......Page 281
Log Shipping......Page 285
Database Mirroring......Page 287
AlwaysOn......Page 289
Failover Clustering......Page 291
Custom ETL Using SQL Server Integration Services......Page 293
Bulk Copy Process......Page 294
Choosing the Right Deployment......Page 295
Keeping the Data Consistent......Page 297
Conclusion......Page 299
Chapter 12: Windows Azure SQL Database for DBAs......Page 300
Infrastructure......Page 301
Hardware......Page 302
Database Components......Page 303
Management Platform......Page 304
Security......Page 305
Other Important Information......Page 306
Key Terms......Page 307
T-SQL Changes for Federations......Page 308
Federation Example......Page 309
Limitations......Page 310
DMVs Available......Page 311
Execution Plans......Page 312
Performance Dashboard......Page 313
Windows Azure SQL Reporting......Page 315
Windows Azure SQL Data Sync......Page 316
Import/Export Feature......Page 317
Cost of SQL Database......Page 318
Conclusion......Page 319
Chapter 13: I/O: The Untold Story......Page 320
Monitoring......Page 321
Considerations......Page 322
Tactical......Page 324
Code or Disk?......Page 328
Times Have Changed......Page 330
Getting to the Data......Page 331
Addressing a Query......Page 335
Environmental Considerations......Page 338
Conclusion......Page 341
Chapter 14: Page and Row Compression......Page 342
Editions and Support......Page 343
What to Compress and How to Compress It......Page 344
Row Compression......Page 345
Page Compression......Page 348
What Do You Compress?......Page 353
Fragmentation and Logged Operations......Page 362
Conclusion......Page 366
Understanding Your Workload......Page 367
SQL Server 2012 Enterprise Edition Consideration Factors......Page 368
Server Form Factor Selection......Page 370
Dell PowerEdge R320......Page 372
Dell PowerEdge R620......Page 373
Dell Comparison Recap......Page 374
Processor Vendor Selection......Page 375
Processor Model Selection......Page 376
Memory Selection......Page 378
Conclusion......Page 379
Chapter 16: Backups and Restores Using Availability Groups......Page 380
Configuring the Windows Server......Page 381
SQL Server Availability Group......Page 382
Backup Location......Page 388
Backup Priority......Page 389
Maintenance Plans......Page 391
T-SQL Scripts......Page 393
Recovery on Availability Groups......Page 396
Conclusion......Page 397
Chapter 17: Big Data for the SQL Server DBA......Page 399
Big Data Arrives with Hadoop......Page 401
MapReduce: The Nucleus of Hadoop......Page 402
Hardware......Page 408
DBA As Data Architect......Page 409
Big Data for Analytics......Page 410
The DBA’s Role......Page 411
Big Data in Practice......Page 412
Exporting from HDFS......Page 419
Hive......Page 420
Hive and Excel......Page 423
JavaScript......Page 424
Pig......Page 427
Big Data Sources......Page 429
Big Data Business Cases......Page 430
Big Data in the Microsoft Future......Page 431
Conclusion......Page 432
Define the Peak Load......Page 433
Determine Where You Are Today......Page 435
Perform the Assessment......Page 437
Define the Data to Capture......Page 440
Analyzing Application-Usage Data......Page 450
Analyzing Perfmon Data......Page 453
Analyzing Configuration Data......Page 459
Analyzing SQL Performance Data......Page 462
Devise a Plan......Page 466
Conclusion......Page 467
Index......Page 468