Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Assuming that the monitoring script is running on the same server as your MySQL server, you can check for the following: Ensure the MySQL service is running. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 126

Servers Availability Programming Code 126

High Scalability

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

Servers 165

Servers Programming Database Availability 165

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet. Check out these other posts to learn more about optimizing your MySQL deployments: Calculating InnoDB Buffer Pool Size for your MySQL Server. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 169

Servers Best Practices Efficiency Availability 169

SQL Shack

DECEMBER 23, 2019

This article targets the beginners and gives an introduction of the clustered index in SQL Server. Introduction An index plays a crucial role in SQL Server query performance. Indexes Performance SQL Server Management Studio (SSMS

Servers 68

Servers Performance 68

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019.

Servers 100

Servers C++ Testing Systems 100

SQL Shack

NOVEMBER 25, 2019

In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Development Performance SQL Server 2019

Servers 85

Servers Development Performance 85

SQL Performance

FEBRUARY 13, 2020

SQL Server 2019 Cumulative Update #2 is now available, with 134 fixes and improvements. The post SQL Server 2019 Cumulative Update #2 appeared first on SQLPerformance.com. SQL Server 2019Build # is 15.0.4013.40.

Servers 40

Servers Availability 40

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. Re-Slaving a Crashed #MySQL Master Server in Semisynchronous Replication Setup Click To Tweet. Remember that you need to retain the UUID of this server as before. In a MySQL 5.7

Servers 111

Servers Availability Processing Database 111

SQL Shack

SEPTEMBER 20, 2019

In this article, we will discuss a few very common questions that you may be asked during a SQL Server administrator or developer technical job interview. Q1: What is a SQL Server Execution Plan?

Servers 100

Servers Engineering Development 100

SQL Performance

JANUARY 10, 2020

Earlier this week, Microsoft announced SQL Server 2019 Cumulative Update #1. To update your local Docker image: docker pull mcr.microsoft.com/mssql/server: 2019 -latest. The post SQL Server 2019 Cumulative Update #1 appeared first on SQLPerformance.com.

Servers 52

Servers Testing Processing 52

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. SQL Server Agent Alerts.

Servers 66

Servers Azure Best Practices Database 66

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Microsoft SQL Server Database Engine Input/Output Requirements.

Servers 84

Servers Media Cache Storage 84

Dynatrace

FEBRUARY 11, 2020

OneAgent knows where to connect for further runtime configuration and where to send data because the installer itself is pre-configured to connect to the exact tenant and server that it’s downloaded from. And what if you need to migrate OneAgent from one server to another?

Servers 175

Servers Tuning Systems Availability 175

SQL Server According to Bob

SEPTEMBER 9, 2019

The partitioned memory and latch objects protect in-memory structures for short durations and can be sized according to available memory for SQL Server. Bob Dorr – Principal Software Engineer SQL Server

Servers 103

Servers Database Scalability Tuning 103

SQL Performance

NOVEMBER 1, 2019

As I embark on my first PASS Summit in a few years, it is hard to contain my excitement about the newest version of SQL Server. I wrote about this in a post entitled, " A Big Deal : SQL Server 2016 Service Pack 1." SQL Server 2019 Enterprise Edition Standard Edition

Servers 52

Servers Availability Database Hardware 52

SQL Server According to Bob

FEBRUARY 7, 2020

SQL Server dbcc clonedatabase ​​ - ​​ Gotcha The dbcc clonedatabase is a ​​ handy command to clone metadata and ​​ information such as ​​ query disk store. I have been testing ​​ SQL Server ​​ High Availability failovers ​​ in combination with database creates and drops, including clonedatabase.

Database 43

Database Servers Azure Tuning 43

SQL Shack

JANUARY 16, 2020

This article gives an introduction of the non-clustered index in SQL Server using examples. Introduction In a previous article Overview of SQL Server Clustered indexes, we explored the requirement of an index and clustered indexes in SQL Server.

Servers 69

Servers Performance 69

SQL Shack

FEBRUARY 12, 2020

This is in continuation of the previous articles How to monitor internal data structures of SQL Server In-Memory database objects and SQL Server In-Memory database internal memory structure monitoring.

Database 64

Database Monitoring Servers Design 64

SQL Shack

AUGUST 19, 2019

SQL Server Query Store is a performance monitoring tool that helps us evaluate the performance of a SQL query in terms of several different performance metrics such as CPU and Memory Consumption, execution time and the I/O cycles consumed by the query.

Monitoring 88

Monitoring Servers Metrics Performance 88

SQL Shack

DECEMBER 5, 2019

This article discusses the Forwarded Records and its performance issues for heap tables in SQL Server. Heap introduction and performance issues A page of 8KB is the smallest unit of storage in SQL Server. SQL Server stores the data […].

Storage 58

Storage Servers Performance Systems 58

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 62

Tuning Servers Database Best Practices 62

SQL Shack

AUGUST 21, 2019

Introduction Once we connect to a SQL Server instance, it assigns a unique identification number to each connection. It is the Server Process ID and commonly known as SPID. SPID 1 to 50 is reserved for SQL Server […].

Servers 72

Servers Processing Monitoring 72

SQL Shack

JULY 18, 2019

In this article, we will review how to set up auto-failover groups in Azure SQL Server and how failover group is different from active geo-replication in Azure.

Azure 80

Azure Servers Database Availability 80

SQL Shack

MAY 13, 2019

This article on SQL Server Always On Listeners includes an overview and various connection configurations for specifying MultiSubnetFailover including SSMS, ODBC, ADO.NET, as well as MultiSubnetFailover limitations and how to connect to all IP addresses via RegisterAllProvidersIP.

Servers 64

Servers Availability 64

SQL Server According to Bob

APRIL 24, 2018

When I joined Microsoft in 1993, I would embark on a 25 year journey working only on Windows laptops and Windows Server computers. Last October we released SQL Server 2017 including support for Linux and Docker Containers. docker pull microsoft/mssql-server-linux:2017-latest.

Servers 52

Servers Internet Internet Virtualization 52

SQL Shack

JANUARY 13, 2020

Before going through the index design procedure, let us revise the SQL Server index concept. SQL Server index overview SQL index is considered as one of the most important factors in the SQL Server performance […].

Design 64

Design Servers Performance 64

SQL Shack

DECEMBER 9, 2019

In this article, we will describe SQL Server Profiler and how it can be used. Introduction SQL Server Profiler is a tracing tool provided by Microsoft since SQL Server 2000 version.

Servers 52

Servers Monitoring 52

SQL Performance

AUGUST 23, 2019

In traditional row-mode execution plans, SQL Server may introduce a Bitmap operator as part of performing early semi join reduction before a parallel hash or merge join. There have been major improvements since the first appearance of the batch mode execution engine in SQL Server 2012.

Servers 83

Servers Retail Engineering Efficiency 83

SQL Server According to Bob

FEBRUARY 10, 2019

Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM.

Servers 52

Servers C++ Network Monitoring 52

SQL Performance

DECEMBER 17, 2019

One initial, easy step to moving your SQL Server on-premises workloads to the cloud is using Azure VMs to run your SQL Server workloads in an infrastructure as a service (IaaS) scenario. The post Azure Virtual Machines for SQL Server Usage appeared first on SQLPerformance.com.

Virtualization 56

Virtualization Azure Servers Storage 56

SQL Server According to Bob

JANUARY 17, 2020

SQL Server BDC Hints and Tips:​​ TEMPDB​​ Disk Usage I was troubleshooting ​​ a ​​ master-0 pod eviction ​​ due to ​​ disk pressure. ​​​​ Looking at the disk metrics I was able to map the time ​​ of ​​ the disk ​​ space increase to the startup of SQL Server, specifically TEMPDB. SQL Server BDC Hints and Tips BDC k8s tempdb

Servers 40

Servers Metrics 40

SQL Shack

SEPTEMBER 9, 2019

In this article, we will study in detail about the how SQL Server Index Fill factor works. Index Fill factor SQL Server Index Fill Factor is a percentage value to be filled data page with data in SQL Server.

Benchmarking 77

Benchmarking Storage Servers Availability 77

SQL Shack

JUNE 25, 2019

It is essential for the DBA to need to ensure the SQL Server database performance. Overview of Default trace in SQL Server Starting from SQL Server 2005, SQL Server captures a few critical events in the default traces. […].

Database 80

Database Tuning Servers Performance 80

SQL Server According to Bob

FEBRUARY 11, 2019

SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running newer releases of SQL Server to accommodate larger systems. During SQL Server startup the number of log writer workers is determined. SQL Server 2017 General How It Works It Just Runs Faster NUMA Performance Scheduler

Servers 40

Servers Availability Software Software 40

SQL Shack

AUGUST 15, 2019

This article explores the usage of TempDB and different ways to shrink the TempDB database in SQL Server Each instance of Microsoft SQL Server has a system database TempDB. It is a backbone for the SQL Server instance.

Database 75

Database Servers Systems Monitoring 75

SQL Server According to Bob

DECEMBER 18, 2018

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. SQL Server 2017 How It Works SQL Server on Linu

Cache 52

Cache Media Servers Database 52

SQL Shack

MAY 3, 2019

CPU pressure slowing down the server This article is the sequel in a series about SQL Server monitoring tools and common performance issues.

Monitoring 60

Monitoring Servers Performance 60

SQL Server According to Bob

FEBRUARY 9, 2020

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, ​​ logs, ​​ … This blog ​​ post ​​ focuses on connecting to the SQL Server BDC, ​​ some ​​ helpful ​​ log files ​​ and utility outputs. Port Description 31433 When connecting to ​​ a ​​ SQL Server the default port is ​​ commonly ​​ 1433.

Servers 40

Servers Database Availability Azure 40

SQL Shack

JULY 2, 2019

Index strategies overview This article is about techniques for optimizing the SQL Server indexes strategy. It is an appendix of the SQL index overview and strategy article in which I covered different areas like what indexes actually do, how to create them, and I briefly mentioned some index design guidelines. Furthermore, I also presented an […]. Indexes Maintenance Performance

Strategy 51

Strategy Servers Design Performance 51

SQL Server According to Bob

DECEMBER 18, 2018

The SQL Server Host Extension provides file level integrity. Bob Dorr – Principal Software Engineer SQL Server. SQL Server 2017 How It Works SQL Server on LinuxWhen Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent directory to be synchronized. As documented in the manpage for fsync core changes to the directory require the directory itself to be synchronized.

Servers 40

Servers Software Engineering Engineering Software 40

SQL Server According to Bob

DECEMBER 10, 2018

SQL Server Books Online documents Instant File Initialization and the associated security considerations. SQL Server performs the following API calls when creating or extending (growing) data and log files. Bob Dorr – Principal Software Engineer SQL Server.

Servers 52

Servers Systems Database Speed 52

DZone

SEPTEMBER 20, 2019

php” file that sits quietly until it is invoked by a top-level web server like Nginx+PHP-FPM or Apache mod_php. How does this Peak Perform? Running a PHP application offers a wholly unique experience compared to running applications in other programming languages like Java or Golang.

Java 130

Java Servers Programming Performance 130

SQL Shack

JUNE 18, 2019

In my previous article, Data synchronization in SQL Server Always On Availability Groups, we explored the internal data synchronization for both Asynchronous and Synchronous data commit mode.

Availability 90

Availability Servers Processing 90