article thumbnail

New Metadata-Only Column Changes in SQL Server 2016

SQL Performance

Along with a large number of restrictions on what is even possible with this command, there is always the question of performance. When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016. ( SELECT.

Servers 63
article thumbnail

The state of site reliability engineering: SRE challenges and best practices in 2023

Dynatrace

This can often result from a lack of understanding of the discipline’s role in delivering on key performance objectives: SLOs. To overcome this hurdle, the panelists recommended that engineers communicate the value of SRE to higher-level executives through business data.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Site reliability done right: 5 SRE best practices that deliver on business objectives

Dynatrace

With so many of their transactions occurring online, customers are becoming more demanding, expecting websites and applications to always perform perfectly. However, cloud complexity has made software delivery challenging. Identify KPIs Next, create a list of the key performance indicators (KPIs) that are important to the business.

article thumbnail

SQL Server on Linux: Why Do I Have Two SQL Server Processes

SQL Server According to Bob

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 The Linux, sqlservr, WATCHDOG can perform a similar role.

Servers 40
article thumbnail

SQL Server on Linux: Quick Performance Monitoring

SQL Server According to Bob

I have been asked several times about how to get a Performance Monitor like view on Linux. Performance Co-Pilot. PMCHART can be used much like you use performance monitor. Getting Started: Using Performance Co-Pilot and Vector for Browser Based Metric Visualizations: [link]. Vector (Remote Visualization via Browser).

article thumbnail

SQL Server Management Studio Provides–“XE Profiler”

SQL Server According to Bob

Bob Ward and I worked with our SQL Server Tool developers (thanks David) to enable ‘Q uick XE Trace ’ capabilities. The feature is available in the latest SQL Server Management Studio (SSMS) release. Here is an example using the SQL Server SSMS 2017 against my SQL 2016 server.

Servers 40
article thumbnail

SQL Server Linux: fsync and Buffered I/O

SQL Server According to Bob

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. SQL Server does NOT do this, in fact I made sure SQL Server on Linux does not allow this to occur. This issue does NOT impact SQL Server database, log and backup files.

Servers 40