SQL Performance

JULY 11, 2019

Last year, I got together with one of my dev teams at SentryOne – they call themselves the SQL Injectors – to talk about the possibility of replicating Plan Explorer functionality inside of Azure Data Studio. First, ensure you meet our requirements: Azure Data Studio 1.9.0 or newer ( July announcement post ).NET or better).

Azure 90

Azure Servers Tuning Operating System 90

Scalegrid

DECEMBER 16, 2019

It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. So, what makes DigitalOcean a compelling alternative to other popular MongoDB hosting providers like AWS and Azure ?

Azure 187

Azure AWS Database Latency 187

Scalegrid

JANUARY 30, 2019

The value of SBM, as explained in the MySQL documentation , depends on the state of the MySQL slave in general, and the states of MySQL slave SQL_THREAD and IO_THREAD in particular. ScaleGrid’s Monitoring Console for MySQL on Azure plots the values of SBM over time for the slave nodes. Possible Values of Seconds Behind Master.

Speed 197

Speed Azure Network Monitoring 197

Dynatrace

MAY 28, 2020

If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers.

Engineering 270

Engineering Performance Metrics Best Practices 270

Scalegrid

JULY 29, 2019

Host MySQL on AWS , or MySQL on Azure with configurable instance sizes through the top two cloud providers in the world. Make sure your website doesn’t go down with a server or datacenter crash by configuring a master-slave setup for high availability. We support two different MySQL DBaaS plans on both AWS and Azure.

Database 166

Database Cloud Website Azure 166

Dynatrace

JUNE 7, 2023

A typical design pattern is the use of a semantic search over a domain-specific knowledge base, like internal documentation, to provide the required context in the prompt. This includes OpenAI as well as Azure OpenAI services, such as GPT-3, Codex, DALL-E, or ChatGPT. Our example dashboard below visualizes OpenAI token consumption.

Monitoring 241

Monitoring Latency Metrics Azure 241

Dynatrace

JANUARY 31, 2024

million AI server units annually by 2027, consuming 75.4+ Integrations with cloud services and custom models such as OpenAI, Amazon Translate, Amazon Textract, Azure Computer Vision, and Azure Custom Vision provide a robust framework for model monitoring. Estimates show that NVIDIA, a semiconductor manufacturer, could release 1.5

Cache 276

Cache Azure Infrastructure Monitoring 276

SQL Performance

NOVEMBER 18, 2019

Migrating an on-premises SQL Server instance to an Azure Virtual Machine (VM) is a common method to migrate to Azure. You'll see the types referenced as Family in the Azure Portal when sizing a VM. Compute optimized – High CPU-to-memory ration, medium traffic web servers and application servers. Generation.

Azure 76

Azure Benchmarking Storage Virtualization 76

Dynatrace

AUGUST 24, 2020

Similar ly, integrations for Azure and VMware are available to help you monitor your infrastructure both in the cloud and on-premises. . Dynatrace VMware and virtualization documentation . Dynatrace Kubernetes documentation . Dynatrace OneAgent documentation . Dynatrace root cause analysis documentation .

Analytics 195

Analytics Infrastructure AWS Operating System 195

Dynatrace

JULY 10, 2019

OneAgents are optimized to send data to the Dynatrace servers with the smallest possible impact, querying the metrics every minute, and the data is a first-class citizen for the Dynatrace AI root-cause analysis. Dynatrace provides out-of-the-box support for VMware, AWS, Azure, Pivotal Cloud Foundry, and Kubernetes.

Java 197

Java Best Practices Metrics Azure 197

Scalegrid

JANUARY 3, 2020

ScaleGrid provides full admin access to your MySQL deployments – this makes it easier to integrate the existing MySQL ecosystem of tools with your ScaleGrid MySQL deployments on AWS or Azure. The MySQL Exporter tool can be installed locally on a MySQL server or centrally on the Prometheus server.

Monitoring 164

Monitoring Metrics Servers Database 164

SQL Performance

OCTOBER 7, 2020

The documentation says only the following operators can rewind: Table Spool. The Sort operator’s rewind behaviour may seem strange, but it has been this way from (at least) SQL Server 2000 to SQL Server 2019 inclusive (as well as Azure SQL Database). The post When Do SQL Server Sorts Rewind? Row Count Spool.

Servers 106

Servers Cache Azure Performance 106

SQL Performance

FEBRUARY 26, 2020

Azure SQL Database Managed Instance became generally available in late 2018. Organizations are taking advantage of having managed backups, lots of built-in security features, an uptime SLA of 99.99%, and an always up-to-date environment where they are no longer responsible for patching SQL Server or the operating system. GB per vCore.

Azure 63

Azure Performance Storage Latency 63

Percona

DECEMBER 4, 2023

It is the most stable, scalable, and secure open source MySQL distribution based on Percona Server for MySQL. A release highlight is the implementation of telemetry in Percona Server for MySQL that fills in the gaps in our understanding of how you use Percona Server for MySQL to improve our products. Percona XtraBackup 8.0.35-30

Open Source 110

Open Source Azure Servers Programming 110

SQL Performance

AUGUST 15, 2019

Last year, I got together with one of my dev teams here – they call themselves the SQL Injectors – to talk about the possibility of replicating SentryOne Plan Explorer functionality inside of Azure Data Studio. First, ensure you meet our requirements: Azure Data Studio 1.9.0 or newer ( July announcement post ).NET

Azure 50

Azure Servers Tuning Operating System 50

Particular Software

DECEMBER 7, 2020

For data storage alone, Azure offers: Table Storage, CosmosDB, SQL Server, Blob Storage, and more. With the latest release of Azure Table Persistence for NServiceBus, we offer full transactionality across Outbox, Synchronized Storage Session as well as Sagas. Incidentally, this is an ideal way to avoid batch jobs ).

Azure 52

Azure Storage Speed Cloud 52

Scalegrid

APRIL 5, 2024

ScaleGrid offers managed DBaaS solutions to simplify scaling and managing Redis deployments with features such as dynamic scaling with minimal downtime, automated backups, and high availability, suitable for cloud platforms like AWS, Azure, and Google Cloud. How Does Redis Sharding Work? Visualize it as a relay race.

Scalability 130

Scalability Java Efficiency Database 130

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. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

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. The new database generated from DBCC CLONEDATABASE is primarily intended for troubleshooting and diagnostic purposes.

Servers 45

Servers Azure Database Tuning 45

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. Is MongoDB free to use?

Open Source 98

Open Source Programming Database Servers 98

SQL Server According to Bob

OCTOBER 26, 2017

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 on Linux Release Notes. SQL Server on Linux.

Servers 40

Servers Azure Open Source Database 40

Smashing Magazine

JULY 6, 2021

Microsoft word documents, spreadsheets, Google docs always rear their heads up when working with content authors. How you manage content and assets across cultures and languages should be thought out and documented. Comprehensive documentation and code samples are also a must. Retrofitting is possible, but is not a fun activity.

Cache 145

Cache Website Mobile Google 145

Testsigma

NOVEMBER 18, 2021

The type of applications that are being tested has changed as well, from (now) legacy client server-based applications to microservice-based or cloud-based architectures. I advise teams to look at behavior-driven testing techniques to document security and performance requirements. This changes how teams test for quality.

Engineering 104

Engineering Social Media DevOps Azure 104

Percona

JANUARY 24, 2023

For the major clouds, read the following docs: Google – Documentation on Volume Snapshots for GKE AWS – Using EBS Snapshots for persistent storage with your EKS cluster Azure – AKS CSI documentation Once you have CSI configured and Volume Snapshot Class is in place, proceed to create a backup.

Database 97

Database Storage Open Source Cloud 97

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster.

Database 98

Database Servers Storage Strategy 98

Randon ASCII

JULY 11, 2022

This slowdown may be mitigated in Windows 11 but in the latest Windows Server editions – where it matters most – this bug is alive and well. As their own documentation says: Queued spin locks are a variant of spin locks that are more efficient for high contention locks on multiprocessor machines. Server versions should be fine….

Cache 105

Cache Energy Google Processing 105

SQL Performance

MARCH 15, 2021

This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data. The Microsoft.SqlServer.Management.Trace namespace that contains the Microsoft SQL Server Trace and Replay objects are also deprecated.

Servers 64

Servers Azure Best Practices Monitoring 64

Smashing Magazine

NOVEMBER 15, 2021

Dash Dash is an online documentation site that presents the Unix man pages (i.e. Rclone is an open-source command-line program that allows you to manage files on 40+ cloud storage services (Amazon S3, Dropbox, Google Drive, Azure, etc.). Large preview ). nb is a command-line tool with features that include local web note? bashupload.

Development 141

Development Google Open Source Storage 141

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

O'Reilly

NOVEMBER 12, 2019

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” 1 reported benefit. 1 in tools used.

Serverless 94

Serverless Architecture FinTech Infrastructure 94

Percona

DECEMBER 12, 2022

The percona-ppg-server meta-package installs PostgreSQL and the extensions, while percona-ppg-server-ha package installs high-availability components that are recommended by Percona. This release is focused on the Percona Server for MySQL-based deployment variant. It is based on Percona Server for MySQL 8.0.30-22.

Open Source 64

Open Source Azure Servers Database 64

O'Reilly

MARCH 11, 2025

The same model will run in the cloud at a reasonable cost without specialized servers. Amazon Web Services, Microsoft Azure, Google Cloud, and many smaller competitors offer hosting for AI applications. It will spin your fans; it will be slow (minutes rather than seconds); and youll probably need 64 GB of RAMbut it will work.

Artificial Intelligence 63

Artificial Intelligence Infrastructure Government Open Source 63

Particular Software

AUGUST 16, 2021

How do I move from Azure Tables to Cosmos DB? ?? Cosmos DB is the primary database service provided by Azure. Under the hood, each “record” in Cosmos DB is a JSON document with an ID and partition key that, together, define its globally unique ID. How do I move from Azure Tables to Cosmos DB? What is Cosmos DB?

Azure 52

Azure Serverless Storage Database 52

Smashing Magazine

JUNE 25, 2020

Today, we’ll address storing and serving files for both single-server and scalable deployments while considering factors like compression, caching, and availability. Any file uploaded by a user, from profile pictures to personal documents, is called a media file. The two types of Django deployments are: Single-Server.

Media 77

Media Cache Storage AWS 77

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1. Leonardo Losoviz.

AWS 45

AWS Servers Storage Cloud 45

Particular Software

MARCH 15, 2021

For NServiceBus systems, our SQL Persistence package allows you to use whatever flavor of SQL works best for you, supporting dialects for Microsoft SQL Server, MySQL, PostgreSQL, and Oracle. Our existing code and documentation were already using this name so nothing else needed to change. SQL Server Always Encrypted SQL Persistence 6.1

Transportation 52

Transportation Azure Database Servers 52

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40