Sites Microsoft


SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions-2

Publié le 24 août 2020 sur SQL Server Support Blog
 

SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions-2 In previous post, we discussed the PFS, GAM and SGAM pages. Today, I’m going show you two related corruptions on these pages.   SQL Server checks the bit in PFS, GAM, SGAM …

SQL Server Extents, PFS, GAM, SGAM and IAM and related corruptions

Publié le 22 août 2020 sur SQL Server Support Blog
 

I’m going to start a series of posts talking about SQL Server allocation pages and corruption. Each post will have samples showing how SQL Server use these pages and scenarios of corruption. The first post will talk about the Extents, PFS, GAM, S …

SQL Service failed to start because of ‘Detected unsupported pre-release version of Windows’

Publié le 22 août 2020 sur SQL Server Support Blog
 

1. SQL SERVER cannot start and reported ‘Failed to allocate pages’. It looks like memory shortage issue. But we are quite sure that the server has enough memory. So we decided to focus on ‘Detected unsupported pre-release version of Windows …

Released: SQL Server Management Pack (7.0.24.0)

Publié le 21 août 2020 sur MS Tech Community
 

An updated version of SQL Server Management Pack is ready. It has many new features which are mostly based on your feedback.   Please download at: Microsoft System Center Management Pack for SQL Server   What’s New Added a new “Se …

Azure SQL Capacity Planning: DTU or vCore? | Data Exposed

Publié le 20 août 2020 sur Azure SQL Database Blog
 

  Capacity planning process plays a critical role in migrating to an existing application or designing a brand new one. In the second part of this three-part series with Silvano Coriani, learn about the differences between DTU and vCore when plann …

Commands we can use to manage SQL Server availability group on Linux Pacemaker cluster

Publié le 20 août 2020 sur SQL Server Support Blog
 

  Thanks to Jayantha Das,  who shared some of the common command we use in SQL Server on Linux Pacemaker Maker cluster. This blog contains the pacemaker settings that we can modify. Unless explicitly required it is recommended that we don …

SQL Server managed by Red Hat Linux Identity Management may fail to execute high privileged command

Publié le 20 août 2020 sur SQL Server Support Blog
 

Following article describe how to configure Active Directory authentication on SQL Server running in Red Hat operating system using Red Hat Enterprise Linux Identity Management   Tutorial: Configuring Red Hat Enterprise Linux to allow Active Direc …

Changes to KB articles used for Cumulative Updates

Publié le 18 août 2020 sur MS Tech Community
 

Back in March 2020, the main Knowledge Base (KB) articles for Cumulative Updates (CUs) started including inline description for fixes. We call those descriptions “blurbs” and they replace many of the individual KB articles that existed for …

Improve Query Performance by Managing Statistics in Azure SQL | Data Exposed: MVP Edition

Publié le 18 août 2020 sur Azure SQL Database Blog
 

Within Azure SQL maintenance tasks such as backups and integrity checks are handled for you, and while you may be able to get away with automatic updates keeping your statistics up-to-date, sometimes it’s not enough. Proactively managing statistics in …

Changes to Knowledge Base articles used for Cumulative Updates

Publié le 18 août 2020 sur SQL Server Support Blog
 

Summary: In March 2020 we introduced inline, short description of fixes in the master Cumulative Update KB articles. We call those descriptions “blurbs” and they replace many of the individual KB articles that existed for each product fix a …

Log reader agent may raise a Non-yielding Scheduler dump in SQL Server running on Linux OS

Publié le 17 août 2020 sur SQL Server Support Blog
 

If you are running SQL Server 2017 or SQL Server 2019 on Redhat 7.x or UBUNTU 16.x Linux operating systems and configured Transactional Replication or Change Data Capture feature, then sporadically log reader agent may fail to read the transactional lo …

Azure SQL Capacity Planning: Overview | Data Exposed

Publié le 13 août 2020 sur Azure SQL Database Blog
 

Whether migrating an existing application or designing a brand new one, capacity planning process plays a critical role. Learn how to navigate across Azure SQL Database options like hardware generation, service and compute tiers, and instance sizing pr …

The August 2020 release of Azure Data Studio is now available

Publié le 12 août 2020 sur SQL Server Blog
 

The August release of Azure Data Studio is now available. Download Azure Data Studio and review the release notes to get started.Note: After downloading Azure Data Studio, say Yes to enabling preview features so that you can use extensions.Azure Data S …

How to configure the WFSC AG failover policy when the database level health detection enabled?

Publié le 12 août 2020 sur SQL Server Support Blog
 

The database level health detection failover option introduced on this article https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/sql-server-always-on-database-health-detection-failover-option?view=sql-server-ver15   …

How to configure the WSFC AG failover policy when the database level health detection enabled?

Publié le 12 août 2020 sur SQL Server Support Blog
 

The database level health detection failover option introduced on this article https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/sql-server-always-on-database-health-detection-failover-option?view=sql-server-ver15   …


Pages :