Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Scalegrid

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.

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Scalegrid

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

tempdb Enhancements in SQL Server 2019

SQL Performance

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.

Thoughts on SQL Server 2019 Editions

SQL Performance

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

SQL Table Variable Deferred Compilation in SQL Server 2019

SQL Shack

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

The Client/Server Rendering Spectrum

CSS - Tricks

There is Server-Side Rendering (SSR, like this WordPress site is doing) and Client-Side Rendering (CSR, like a typical React app). The Client/Server Rendering Spectrum by Chris Coyier ( @chriscoyier ). Direct Link to Article — Permalink The post The Client/Server Rendering Spectrum appeared first on CSS-Tricks. Link client side rendering performance server side renderingI've definitely been guilty of thinking about rendering on the web as a two-horse race.

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

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.

SQL Server Execution Plans Interview Questions

SQL Shack

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?

Common SQL Server Mishaps

SQL Performance

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.

Memory-Optimized TempDB Metadata in SQL Server 2019

SQL Shack

By removing disk-based storage and the challenge of copying data in and out of memory, query speeds in SQL Server can be improved by orders of magnitude. Migration Performance SQL Server 2019

Tuning SQL Server Reporting Services

SQL Performance

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.

Batch Mode Bitmaps in SQL Server

SQL Performance

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.

Take the SQL Server Mac challenge

SQL Server According to Bob

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.

SQL Mysteries: SQL Server Login Timeouts – A Debugging Story

SQL Server According to Bob

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.

An overview of the SQL Server Profiler

SQL Shack

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.

Forwarded Records Performance issue in SQL Server

SQL Shack

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 […].

SQL Server 2019 Many No Longer Capture Mini-Dump (SQLDump####.mdmp)

SQL Server According to Bob

I was looking at a SQL Server which had generated ten(10) SQLDump####.txt We introduced a new feature in SQL Server 2019 to save disk space for mini/crash dumps which can skip the suspension and capture for identical dump signatures, saving disk space and reducing the impact on the SQL Server instance. Each time the SQL Server instance is started a hash table is created to track crash dump signatures. How It Works Dumps SQL Server 2019

Managing High Availability in PostgreSQL – Part III: Patroni

Scalegrid

Standby Server Tests. Reboot the server. patronictl list did not display this server. Master/Primary Server Tests. Reboot the server. Failover happened and one of the standby servers was elected as the new master after obtaining the lock. One of the standby servers acquired the DCS lock and became the master by promoting itself. Network-isolate the master server from other servers. PostgreSQL was demoted on the master server.

SQL Server Log Writer Workers

SQL Server According to Bob

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

New Dedicated Application Server Revs PHP to Peak Performance

DZone

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

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

Performance Monitoring via SQL Server Query Store

SQL Shack

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.

SQL Server Linux: Directory fsync Activities

SQL Server According to Bob

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.

SQL Server Instant File Initialization: SetFileValidData (Windows) vs fallocate (Linux)

SQL Server According to Bob

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.

Why Load Balancing Is Important for Web Servers?

DZone

In the web hosting service industry, it is commonly used for balancing the HTTP traffic across multiple servers which act together as a web front-end. A Load Balancer allows the users to distribute the traffic to a single IP across several servers by using a set of different protocols. The processing load can be shared across different nodes, rather limiting it to a single server. The load balancer decides the servers, which can handle the traffic.

KILL SPID command in SQL Server

SQL Shack

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 […].

SQL Server Always On Listeners

SQL Shack

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.

Azure SQL Server auto-failover groups

SQL Shack

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 77

AMD EPYC 7002 Series Processors and SQL Server

SQL Performance

On August 7, 2019, AMD finally unveiled their new 7nm EPYC 7002 Series of server processors, formerly code-named "Rome" at the AMD EPYC Horizon Event in San Francisco. Despite that, you will need a new model server to be able to use PCIe 4.0 Single-Socket Database Servers.

SQL Server I/O Basics Chaper 1 and 2

SQL Server According to Bob

These documents seem to keep moving so providing the SQL Server I/O Basics Chapter #1 and Chapter #2 here as another source. SQL Server I/O Basics Chapter #1: [link] SQL Server I/O Basics Chapter #2: [link]. Bob Dorr

SQL Server Worker Thread Default Calculation

SQL Server According to Bob

SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments. When running on smaller environments SQL Server reduces the worker target. For an X64 installation, using the sp_configure ‘max worker threads’ value of 0 SQL Server uses the following calculation. On small environments SQL Server always uses 256 as the target. SQL Server 2017

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.

Using SQL Server’s SNITrace to Troubleshoot Networking Issues

SQL Server According to Bob

The following link provides a detailed overview and examples of how to leverage SNITrace to troubleshoot SQL Server networking issues. link]. Networking SNITrace TDS XEvent

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 For those signals that default to capturing a full process CORE DUMP, SQL Server on Linux installs alternate signal handlers. Bob Dorr – Principle SQL Server Software Engineer. Linux SQL Server 2017 SQL Server on Linux

SQL Server Index Fill factor with Performance Benchmark

SQL Shack

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.

Jira Cloud, Jira Server, and Jira Data Center Integrations

Tasktop

Whether it’s a result of different teams or lines of business within the same company on separate instances, or even a merger or acquisition, you see different flavors of the multi-Jira architecture: Split across Jira server and Jira Cloud. Split across various Jira server instances.

Cloud 79

Get details of SQL Server Database Growth and Shrink Events

SQL Shack

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. […].

Experience SQL Server 2017: Start your journey here

SQL Server According to Bob

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. Brk2051 sql server on linux and docker from Bob Ward. SQL Server 2017 Release Notes.

SQL Server monitoring tool for CPU performance

SQL Shack

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

Is Intel Doomed in the Server CPU Space?

SQL Performance

A close monitoring of the hardware enthusiast community, including many of the most respected hardware analysts and reviewers paints an even more dire picture about Intel in the server processor space. Intel has been stuck at 14nm in the server space since the Broadwell release in Q4 of 2016.

Overview of the Shrink TempDB database in SQL Server

SQL Shack

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.

Troubleshooting Variable Memory Grants in SQL Server

SQL Performance

One of the more perplexing problems to troubleshoot in SQL Server can be those related to memory grants. SQL Server’s optimizer estimates how much memory is needed, and the query must obtain the memory grant in order to start executing.

Optimizing SQL Server index strategies

SQL Shack

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