Pluralsight - Managing SQL Server Database Performance by Viktor Suha

File Name

Size

6. Configuring SQL Server in Azure/3. Demo- Creating SQL Server Virtual Machines and Sizing.mp4

26 MB

image.jpg

980 kB

managing-sql-server-database-performance.zip

14 MB

1. Course Overview/1. Course Overview.mp4

3.3 MB

1. Course Overview/1. Course Overview.srt

2.8 kB

2. Aiming for Performance and Scalability/1. Introduction.mp4

4.4 MB

2. Aiming for Performance and Scalability/1. Introduction.srt

4.8 kB

2. Aiming for Performance and Scalability/2. A Holistic and Layered Approach.mp4

3.2 MB

2. Aiming for Performance and Scalability/2. A Holistic and Layered Approach.srt

3.8 kB

2. Aiming for Performance and Scalability/3. Definitions and Methods.mp4

3.2 MB

2. Aiming for Performance and Scalability/3. Definitions and Methods.srt

3.5 kB

2. Aiming for Performance and Scalability/4. Aiming for Scalability and Performance.mp4

4.7 MB

2. Aiming for Performance and Scalability/4. Aiming for Scalability and Performance.srt

6.0 kB

2. Aiming for Performance and Scalability/5. Scope and Assets.mp4

3.5 MB

2. Aiming for Performance and Scalability/5. Scope and Assets.srt

4.2 kB

2. Aiming for Performance and Scalability/6. Overview.mp4

1.8 MB

2. Aiming for Performance and Scalability/6. Overview.srt

2.2 kB

3. Understanding Key SQL Server Concepts/01. Major Versions and Compatibility Levels.mp4

7.2 MB

3. Understanding Key SQL Server Concepts/01. Major Versions and Compatibility Levels.srt

8.7 kB

3. Understanding Key SQL Server Concepts/02. Patch Levels and Servicing.mp4

5.9 MB

3. Understanding Key SQL Server Concepts/02. Patch Levels and Servicing.srt

6.0 kB

3. Understanding Key SQL Server Concepts/03. Editions and Best Practices.mp4

3.7 MB

3. Understanding Key SQL Server Concepts/03. Editions and Best Practices.srt

3.9 kB

3. Understanding Key SQL Server Concepts/04. Server Instances.mp4

4.1 MB

3. Understanding Key SQL Server Concepts/04. Server Instances.srt

4.1 kB

3. Understanding Key SQL Server Concepts/05. Server Configuration Options.mp4

2.5 MB

3. Understanding Key SQL Server Concepts/05. Server Configuration Options.srt

2.8 kB

3. Understanding Key SQL Server Concepts/06. Database Configuration Options.mp4

4.3 MB

3. Understanding Key SQL Server Concepts/06. Database Configuration Options.srt

4.0 kB

3. Understanding Key SQL Server Concepts/07. Trace Flags.mp4

5.9 MB

3. Understanding Key SQL Server Concepts/07. Trace Flags.srt

4.8 kB

3. Understanding Key SQL Server Concepts/08. Tempdb.mp4

4.7 MB

3. Understanding Key SQL Server Concepts/08. Tempdb.srt

4.7 kB

3. Understanding Key SQL Server Concepts/09. Transaction Log and Recovery Models.mp4

5.4 MB

3. Understanding Key SQL Server Concepts/09. Transaction Log and Recovery Models.srt

6.8 kB

3. Understanding Key SQL Server Concepts/10. Memory Management and SQLOS.mp4

8.6 MB

3. Understanding Key SQL Server Concepts/10. Memory Management and SQLOS.srt

10 kB

3. Understanding Key SQL Server Concepts/11. Wait Statistics and the Threading Model.mp4

11 MB

3. Understanding Key SQL Server Concepts/11. Wait Statistics and the Threading Model.srt

14 kB

4. Optimizing SQL Server Instance and Memory Configuration/1. Server Health Check.mp4

6.1 MB

4. Optimizing SQL Server Instance and Memory Configuration/1. Server Health Check.srt

6.8 kB

4. Optimizing SQL Server Instance and Memory Configuration/2. Demo- Memory Settings.mp4

18 MB

4. Optimizing SQL Server Instance and Memory Configuration/2. Demo- Memory Settings.srt

12 kB

4. Optimizing SQL Server Instance and Memory Configuration/3. Demo- Parallelism Settings.mp4

9.6 MB

4. Optimizing SQL Server Instance and Memory Configuration/3. Demo- Parallelism Settings.srt

5.0 kB

4. Optimizing SQL Server Instance and Memory Configuration/4. Demo- ERRORLOG Files.mp4

22 MB

4. Optimizing SQL Server Instance and Memory Configuration/4. Demo- ERRORLOG Files.srt

7.4 kB

5. Optimizing Tempdb and User Database File Configuration/1. Database File IO.mp4

9.1 MB

5. Optimizing Tempdb and User Database File Configuration/1. Database File IO.srt

11 kB

5. Optimizing Tempdb and User Database File Configuration/2. Instant File Initialization and Tempdb Bottlenecks.mp4

6.5 MB

5. Optimizing Tempdb and User Database File Configuration/2. Instant File Initialization and Tempdb Bottlenecks.srt

7.2 kB

5. Optimizing Tempdb and User Database File Configuration/3. Demo- Autogrowth Settings.mp4

9.5 MB

5. Optimizing Tempdb and User Database File Configuration/3. Demo- Autogrowth Settings.srt

3.7 kB

5. Optimizing Tempdb and User Database File Configuration/4. Demo- Tempdb Configuration.mp4

9.0 MB

5. Optimizing Tempdb and User Database File Configuration/4. Demo- Tempdb Configuration.srt

4.1 kB

6. Configuring SQL Server in Azure/1. SQL Server in Azure.mp4

6.3 MB

6. Configuring SQL Server in Azure/1. SQL Server in Azure.srt

8.8 kB

6. Configuring SQL Server in Azure/2. SQL Server Virtual Machines.mp4

7.4 MB

6. Configuring SQL Server in Azure/2. SQL Server Virtual Machines.srt

7.7 kB

content.txt

3.6 kB

6. Configuring SQL Server in Azure/3. Demo- Creating SQL Server Virtual Machines and Sizing.srt

13 kB

6. Configuring SQL Server in Azure/4. Azure SQL Database.mp4

9.3 MB

6. Configuring SQL Server in Azure/4. Azure SQL Database.srt

12 kB

6. Configuring SQL Server in Azure/5. Elastic Pools.mp4

7.4 MB

6. Configuring SQL Server in Azure/5. Elastic Pools.srt

8.5 kB

6. Configuring SQL Server in Azure/6. Demo- Estimating Service Tiers and Sizes.mp4

17 MB

6. Configuring SQL Server in Azure/6. Demo- Estimating Service Tiers and Sizes.srt

10 kB

7. Troubleshooting and Baselining the Environment/01. Troubleshooting and Baselining in SQL Server.mp4

5.7 MB

7. Troubleshooting and Baselining the Environment/01. Troubleshooting and Baselining in SQL Server.srt

8.4 kB

7. Troubleshooting and Baselining the Environment/02. Wait Statistics in Practice.mp4

8.0 MB

7. Troubleshooting and Baselining the Environment/02. Wait Statistics in Practice.srt

10 kB

7. Troubleshooting and Baselining the Environment/03. IO and CPU Related Wait Type Patterns.mp4

6.4 MB

7. Troubleshooting and Baselining the Environment/03. IO and CPU Related Wait Type Patterns.srt

8.8 kB

7. Troubleshooting and Baselining the Environment/04. OS, Locking, and Data Page Related Wait Type Patterns.mp4

3.7 MB

7. Troubleshooting and Baselining the Environment/04. OS, Locking, and Data Page Related Wait Type Patterns.srt

4.6 kB

7. Troubleshooting and Baselining the Environment/05. Wait Statistics Patterns in Troubleshooting.mp4

8.0 MB

7. Troubleshooting and Baselining the Environment/05. Wait Statistics Patterns in Troubleshooting.srt

9.4 kB

7. Troubleshooting and Baselining the Environment/06. Demo- Wait Statistics Analysis with Custom Query.mp4

10 MB

7. Troubleshooting and Baselining the Environment/06. Demo- Wait Statistics Analysis with Custom Query.srt

4.5 kB

7. Troubleshooting and Baselining the Environment/07. IO Performance Troubleshooting with DMVs.mp4

3.6 MB

7. Troubleshooting and Baselining the Environment/07. IO Performance Troubleshooting with DMVs.srt

3.9 kB

7. Troubleshooting and Baselining the Environment/08. Demo- IO Performance Analysis with Custom Query.mp4

3.9 MB

7. Troubleshooting and Baselining the Environment/08. Demo- IO Performance Analysis with Custom Query.srt

2.2 kB

7. Troubleshooting and Baselining the Environment/09. Query Store.mp4

3.1 MB

7. Troubleshooting and Baselining the Environment/09. Query Store.srt

3.6 kB

7. Troubleshooting and Baselining the Environment/10. Demo- Using the Query Store for Query Performance Analysis.mp4

9.5 MB

7. Troubleshooting and Baselining the Environment/10. Demo- Using the Query Store for Query Performance Analysis.srt

5.2 kB

7. Troubleshooting and Baselining the Environment/11. System_health Session Trace.mp4

2.9 MB

7. Troubleshooting and Baselining the Environment/11. System_health Session Trace.srt

3.4 kB

7. Troubleshooting and Baselining the Environment/12. Demo- Using the System_health Session Trace for Troubleshooting.mp4

6.4 MB

7. Troubleshooting and Baselining the Environment/12. Demo- Using the System_health Session Trace for Troubleshooting.srt

2.7 kB

7. Troubleshooting and Baselining the Environment/13. Perfmon Traces.mp4

5.9 MB

7. Troubleshooting and Baselining the Environment/13. Perfmon Traces.srt

6.7 kB

7. Troubleshooting and Baselining the Environment/14. Interesting SQL Server Counters.mp4

2.2 MB

7. Troubleshooting and Baselining the Environment/14. Interesting SQL Server Counters.srt

2.9 kB

7. Troubleshooting and Baselining the Environment/15. Page Life Expectancy Patterns.mp4

4.1 MB

7. Troubleshooting and Baselining the Environment/15. Page Life Expectancy Patterns.srt

3.5 kB

7. Troubleshooting and Baselining the Environment/16. Demo- Using and Analyzing Perfmon Traces.mp4

8.8 MB

7. Troubleshooting and Baselining the Environment/16. Demo- Using and Analyzing Perfmon Traces.srt

3.9 kB

7. Troubleshooting and Baselining the Environment/17. Module Summary.mp4

1.3 MB

7. Troubleshooting and Baselining the Environment/17. Module Summary.srt

1.7 kB

8. SQL Server 2019 Improvements/01. Database and Server Upgrade.mp4

2.0 MB

8. SQL Server 2019 Improvements/01. Database and Server Upgrade.srt

2.1 kB

8. SQL Server 2019 Improvements/02. Versions, Editions, and Patching.mp4

5.4 MB

8. SQL Server 2019 Improvements/02. Versions, Editions, and Patching.srt

4.8 kB

8. SQL Server 2019 Improvements/03. Setup.mp4

2.7 MB

8. SQL Server 2019 Improvements/03. Setup.srt

3.3 kB

8. SQL Server 2019 Improvements/04. Tempdb.mp4

4.6 MB

8. SQL Server 2019 Improvements/04. Tempdb.srt

4.2 kB

8. SQL Server 2019 Improvements/05. Query Store.mp4

2.2 MB

8. SQL Server 2019 Improvements/05. Query Store.srt

1.9 kB

8. SQL Server 2019 Improvements/06. Accelerated Database Recovery.mp4

3.2 MB

8. SQL Server 2019 Improvements/06. Accelerated Database Recovery.srt

2.9 kB

8. SQL Server 2019 Improvements/07. Sequential Key Insert Optimization.mp4

2.0 MB

8. SQL Server 2019 Improvements/07. Sequential Key Insert Optimization.srt

1.9 kB

8. SQL Server 2019 Improvements/08. Intelligent Query Processing.mp4

4.8 MB

8. SQL Server 2019 Improvements/08. Intelligent Query Processing.srt

5.5 kB

8. SQL Server 2019 Improvements/09. References.mp4

1.9 MB

8. SQL Server 2019 Improvements/09. References.srt

1.8 kB

8. SQL Server 2019 Improvements/10. Module and Course Summary.mp4

4.7 MB

8. SQL Server 2019 Improvements/10. Module and Course Summary.srt

5.3 kB