| Description |
1 online resource (1 volume) : illustrations |
| Contents |
Cover -- Title Page -- Copyright Page -- Dedication -- Contents -- Foreword -- Acknowledgments -- Introduction -- Chapter 1 SQL Server on Linux: Getting Started -- Creating a Virtual Machine -- Step 1. Basics: Configure Basic Settings -- Step 2. Size: Choose Virtual Machine Size -- Step 3. Settings: Configure Optional Features -- Step 4. Summary and Purchase -- Installing SQL Server -- Configuring SQL Server -- Intro to Unix Commands -- Connecting to SQL Server -- Installing Additional Components -- Installing on Ubuntu -- Installing on SUSE Linux Enterprise Server |
|
Running SQL Server on Docker -- Uninstalling SQL Server -- Summary -- Chapter 2 How SQL Server on Linux Works -- The Sybase Years -- SQLOS -- The Industry Changes -- Project Helsinki -- A Virtualization Surprise -- Drawbridge -- Looking for a Shortcut -- SQLPAL -- Summary -- Chapter 3 Linux for the SQL Server Professional -- Getting Started -- Files and Directories -- Files -- The Unix File System -- Additional Commands -- Building a Command -- Permissions -- Bash Shell -- Services Management -- Software Management -- Disk Management -- System Monitoring -- Summary |
|
Chapter 4 SQL Server Configuration -- The mssql-conf Utility -- Using Variables -- Linux Settings -- Kernel Settings -- Transparent Huge Pages -- Swap File -- Last Accessed Date/Time -- SQL Server Configuration -- Linux Out-of-Memory Killer -- tempdb Configuration -- Process Affinity -- Max Degree of Parallelism -- Cost Threshold for Parallelism -- Statistics -- Trace Flag 2371 -- Summary -- Chapter 5 SQL Server Query Tuning and Optimization -- Query Performance -- Query Processor Architecture -- Parsing and Binding -- Query Optimization -- Generating Candidate Execution Plans |
|
Assessing the Cost of Each Plan -- Query Execution and Plan Caching -- Execution Plans -- Graphical Plans -- XML Plans -- Text Plans -- Query Troubleshooting -- sys.dm_exec_requests and sys.dm_exec_sessions -- sys.dm_exec_query_stats -- statement_start_offset and statement_end_offset -- sql_handle and plan_handle -- query_hash and plan_hash -- Finding Expensive Queries -- SET STATISTICS TIME / IO -- Indexes -- Creating Indexes -- Clustered Indexes vs. Heaps -- Clustered Index Key -- Statistics -- Creating and Updating Statistics -- The New Cardinality Estimator -- Cardinality Estimation Errors |
|
Statistics Maintenance -- Parameter Sniffing -- Optimizing for a Typical Parameter -- Optimizing on Every Execution -- Using Local Variables and the OPTIMIZE FOR UNKNOWN Hint -- Disabling Parameter Sniffing -- Query Processor Limitations -- Query Optimization Research -- Break Down Complex Queries -- Hints -- Summary -- Chapter 6 New Query Processing Features -- Adaptive Query Processing -- Batch Mode Adaptive Joins -- Batch Mode Adaptive Memory Grant Feedback -- Interleaved Execution for Multistatement Table-Value Functions -- Automatic Tuning -- SQL Server 2016 Service Pack 1 |
| Summary |
This comprehensive guide shows, step-by-step, how to set up, configure, and administer SQL Server 2017 on Linux for high performance and high availability. Written by a SQL Server expert and respected author, Microsoft SQL Server 2017 on Linux teaches valuable Linux skills to Windows-based SQL Server professionals. You will get clear coverage of both Linux and SQL Server and complete explanations of the latest features, tools, and techniques. The book offers clear instruction on adaptive query processing, automatic tuning, disaster recovery, security, and much more-- Provided by publisher |
| Notes |
Includes index |
|
Print version record |
| SUBJECT |
SQL server. http://id.loc.gov/authorities/names/n90684343
|
|
Linux. http://id.loc.gov/authorities/names/n94087892
|
|
Linux fast |
|
SQL server fast |
| Subject |
Client/server computing.
|
|
Relational databases.
|
|
Client/server computing
|
|
Relational databases
|
| Form |
Electronic book
|
| ISBN |
9781260121148 |
|
1260121143 |
|
