INDUSTRY INSIGHTS YOUR PEERS ARE READING
SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. SQL Server enables client mode garbage collection. MORE
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 MORE
A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example. Characteristics of a Graph Database A graph […]. DBAtools Graph database Monitoring Reports MORE
Measuring Performance With Server Timing. Measuring Performance With Server Timing. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. In performance terms this is know as Time to First Byte - the amount of time it takes before the server starts sending something the browser can begin to work with. The Server Timing Header. Implementing Server Timing. MORE
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 MORE
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 […]. MORE
Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, […]. Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases. MORE
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. MORE
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. MORE
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. MORE
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. MORE
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. MORE
repmgr enables you to setup standby servers, promote standbys, do a switchover, and monitor the status of your PostgreSQL cluster. repmrg not only manages the replication of PostgreSQL clusters, but also has capabilities for setting up the standby servers for replication. Following the initial installation, we need to make changes to the repmgr configuration file (repmgr.conf) with the required details on each server. Standby Server Tests. Reboot the server. MORE
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 MORE
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. MORE
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 MORE
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. MORE
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. MORE
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 MORE
This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics. Introduction SQL Server statistics are essential for the query optimizer to prepare an optimized and cost-effective execution plan. MORE
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. MORE
Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? MORE
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. MORE
Editor’s Note: In the first of this four part series, I gave an overview of the tools and techniques of query optimization in SQL Server. I also showed how to generate query execution plans usin gSQL Server Management Studio, […]. In the second part, I talked about the process of displaying and interpreting query execution plans. Performance Tuning Query MORE
You monitor the server over time so that you can determine Server average […]. An important concern in optimizing the hardware platform is hardware components that restrict performance, known as bottlenecks. Quite often, the problem isn’t correcting performance bottlenecks as much as it is identifying them in the first place. Start with obtaining a performance baseline. General DBA Performance Tuning hardware MORE
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. MORE
In my previous article Data Synchronization in SQL Server Always On Availability Group, we described a scenario where if a secondary replica goes down in synchronous data commit mode, SQL Server Always on Availability group changes to asynchronous data commit mode. MORE
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. MORE
CPU pressure slowing down the server This article is the sequel in a series about SQL Server monitoring tools and common performance issues. MORE
In this article, we will review how to monitor AWS RDS SQL Server database instances and setup email notifications using event subscriptions and CloudWatch alarms. MORE
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. […]. MORE
Memory pressure slowing down queries This article is the sequel in a series about SQL Server monitoring tools and common performance issues. MORE
Memory has a dramatic impact on SQL Server Performance. Fortunately, in SQL Server you can either use DMVs, , Extended Events, sp_server_diagnostics system procedure or SQL Profiler to server memory usage and track down root cause of SQL Server memory bottlenecks. MORE
In the previous article of this series on the SQL Server transaction log, we discuss the SQL Server database recovery models, Full, Simple and Bulk-Logged, and the how the recovery model option of the database affects the way the SQL Server Engine works with the transaction logs. MORE
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. MORE
Redis Cluster is the native sharding implementation available within Redis that allows you to automatically distribute your data across multiple nodes without having to rely on external tools and utilities. At ScaleGrid, we recently added support for Redis Clusters on our platform through our fully managed Redis hosting plans. MORE
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. MORE
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. MORE
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. MORE
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. MORE
This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups. Introduction SQL Server Always On is a flexible design solution to provide high availability (HA) and disaster recovery (DR). MORE
Introduction to SQL Server Statistics SQL Server Statistics are an essential part of query performance in SQL Server. They help the query optimizer to prepare a query plan using the distribution of values in participating rows. MORE
In this second part, we will talk in more detail about how the server should react to incoming requests with status codes. Each combination of URL and HTTP method corresponds to a functionality available in the bike rental app: Continue reading How a RESTful API server reacts to requests MORE
Servers Related Topics 
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.
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.
CSS - Tricks
MARCH 6, 2019
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 Shack
JULY 10, 2019
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
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.
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.
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 […].
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.
DZone
JULY 31, 2019
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.
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
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.
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.
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
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.
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.
SQL Server Performance
MARCH 12, 2019
You monitor the server over time so that you can determine Server average […]. An important concern in optimizing the hardware platform is hardware components that restrict performance, known as bottlenecks. Quite often, the problem isn’t correcting performance bottlenecks as much as it is identifying them in the first place. Start with obtaining a performance baseline. General DBA Performance Tuning hardware
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.
SQL Server According to Bob
FEBRUARY 10, 2019
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 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. […].
SQL Performance
JULY 16, 2019
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.
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
High Scalability
JUNE 27, 2019
Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular?
Tasktop
APRIL 30, 2019
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.
SQL Shack
AUGUST 16, 2019
A graph database is a type of NoSQL database that is based on graph theory. Graph databases are ideal for storing data that has complex many to many relationships. In this article, we will study the very basics of graph databases with the help of a simple example. Characteristics of a Graph Database A graph […]. DBAtools Graph database Monitoring Reports
SQL Performance
JUNE 5, 2019
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.
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.
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.
SQL Shack
MAY 27, 2019
Introduction to SQL Server Statistics SQL Server Statistics are an essential part of query performance in SQL Server. They help the query optimizer to prepare a query plan using the distribution of values in participating rows.
SQL Shack
MARCH 27, 2019
Memory pressure slowing down queries This article is the sequel in a series about SQL Server monitoring tools and common performance issues.
SQL Shack
MARCH 21, 2019
In the previous article of this series on the SQL Server transaction log, we discuss the SQL Server database recovery models, Full, Simple and Bulk-Logged, and the how the recovery model option of the database affects the way the SQL Server Engine works with the transaction logs.
SQL Shack
AUGUST 13, 2019
This article gives a walk-through of SQL Server Statistics and different methods to perform SQL Server Update Statistics. Introduction SQL Server statistics are essential for the query optimizer to prepare an optimized and cost-effective execution plan.
SQL Shack
AUGUST 8, 2019
This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups. Introduction SQL Server Always On is a flexible design solution to provide high availability (HA) and disaster recovery (DR).
SQL Shack
APRIL 9, 2019
In this article, we will review how to monitor AWS RDS SQL Server database instances and setup email notifications using event subscriptions and CloudWatch alarms.
SQL Shack
AUGUST 12, 2019
Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, […]. Performance monitoring is a must to do the task for a DBA. You should ensure that the database performance is optimal all the time without any impact on the databases.
SQL Server Performance
MARCH 19, 2019
Editor’s Note: In the first of this four part series, I gave an overview of the tools and techniques of query optimization in SQL Server. I also showed how to generate query execution plans usin gSQL Server Management Studio, […]. In the second part, I talked about the process of displaying and interpreting query execution plans. Performance Tuning Query
High Scalability
FEBRUARY 19, 2019
Redis Cluster is the native sharding implementation available within Redis that allows you to automatically distribute your data across multiple nodes without having to rely on external tools and utilities. At ScaleGrid, we recently added support for Redis Clusters on our platform through our fully managed Redis hosting plans.
Scalegrid
MARCH 12, 2019
repmgr enables you to setup standby servers, promote standbys, do a switchover, and monitor the status of your PostgreSQL cluster. repmrg not only manages the replication of PostgreSQL clusters, but also has capabilities for setting up the standby servers for replication. Following the initial installation, we need to make changes to the repmgr configuration file (repmgr.conf) with the required details on each server. Standby Server Tests. Reboot the server.
SQL Server Performance
SEPTEMBER 25, 2018
Memory has a dramatic impact on SQL Server Performance. Fortunately, in SQL Server you can either use DMVs, , Extended Events, sp_server_diagnostics system procedure or SQL Profiler to server memory usage and track down root cause of SQL Server memory bottlenecks.
SQL Shack
MAY 9, 2019
In my previous article Data Synchronization in SQL Server Always On Availability Group, we described a scenario where if a secondary replica goes down in synchronous data commit mode, SQL Server Always on Availability group changes to asynchronous data commit mode.
O'Reilly Software
DECEMBER 28, 2017
In this second part, we will talk in more detail about how the server should react to incoming requests with status codes. Each combination of URL and HTTP method corresponds to a functionality available in the bike rental app: Continue reading How a RESTful API server reacts to requests
SQL Server According to Bob
MAY 19, 2019
SQL Server will ship Azure SQL Database Edge: [link]. With the announcement I can tell you more about one of the things we have been working on; SQL Server running on IoT Edge and Developer machines in under 500MB of memory. The effort focuses attention on memory usage and disk space requirements of SQL Server. As you can imagine, with a code base as large and vast as SQL Server, there is always room for improvement. SQL Server enables client mode garbage collection.
Smashing Magazine
OCTOBER 29, 2018
Measuring Performance With Server Timing. Measuring Performance With Server Timing. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. In performance terms this is know as Time to First Byte - the amount of time it takes before the server starts sending something the browser can begin to work with. The Server Timing Header. Implementing Server Timing.
43 
Let's personalize your content