SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Enter the New SQL Server Profiler.

Azure 96

Azure Database Tuning Network 96

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher.

Servers 145

Servers C++ Code Database 145

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

Scalegrid

APRIL 16, 2020

AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure. AWS , Azure , DigitalOcean. Are you a startup that has free AWS or Azure hosting credits you’d like to use for your database hosting? Do you want to deploy in an AWS VPC or Azure VNET?

Cloud 242

Cloud Azure AWS Database 242

Dynatrace

JANUARY 31, 2024

For example, a Stanford University and UC Berkeley team noted in a research study that ChatGPT behavior deteriorates over time. Using the example of a chatbot, once the user submits a natural language prompt, RAG summarizes that prompt using semantic data. million AI server units annually by 2027, consuming 75.4+

Cache 204

Cache Azure Infrastructure Monitoring 204

Dynatrace

OCTOBER 10, 2022

Despite the name, serverless computing still uses servers. This means companies can access the exact resources they need whenever they need them, rather than paying for server space and computing power they only need occasionally. If servers reach maximum load and capacity in-house, something has to give before adding new services.

Serverless 165

Serverless Infrastructure Lambda Latency 165

Dynatrace

MAY 19, 2022

Example 1: Architecture boundaries. For example, the mobile device talked to an API gateway, and that team was not responsible for all the details of the back-end systems. Example 2: Four golden signals. This refers to the load on your network and servers. Example 3: A look into the user journey. Saturation.

Automotive 270

Automotive Latency Architecture Azure 270

Dynatrace

JUNE 7, 2023

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. How Dynatrace traces OpenAI model requests Let’s use a simple NodeJS example service to show how Dynatrace OneAgent automatically traces OpenAI model requests.

Monitoring 164

Monitoring Latency Metrics Azure 164

High Scalability

JANUARY 11, 2022

When the server receives a request for an action (post, like etc.) We can use cloud technologies such as Amazon Kinesis or Azure Stream Analytics for collecting, processing, and analyzing real-time, streaming data to get timely insights and react quickly to new information(e.g. High Level Design. Architecture. Streaming Data Model.

Design 334

Design Media Storage Logistics 334

Dynatrace

APRIL 15, 2022

The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud. “We used Dynatrace to monitor that large increase in servers. We started out by instrumenting 2,000 servers overnight.

Cloud 177

Cloud Infrastructure Innovation Monitoring 177

SQL Performance

APRIL 26, 2019

If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. DeviceID – This allows you to specify if you want to collect data for a specific SQL Server or everything. The default is -1, which means copy all watched SQL Servers.

Azure 40

Azure Database Metrics Servers 40

Dynatrace

JULY 12, 2022

After moving to Microsoft Azure for many of its production-stage applications, Park ‘N Fly’s IT teams experienced blind spots. “We The platform might identify, for example, that a SQL database “leverages [a particular] node when we do our Tlog [transaction log] backups,” he says. “We

Innovation 219

Innovation Infrastructure DevOps Azure 219

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

AUGUST 11, 2021

For example, the measurements could be temperature and humidity readings taken every 5 minutes, and you want to group the data using hourly buckets and compute aggregates like average per hour. For example, you might want to organize sales data in fiscal year buckets and compute aggregates like the total sales value per fiscal year.

Azure 139

Azure Code Database Servers 139

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Dynatrace

JUNE 15, 2023

If your app runs in a public cloud, such as Amazon Web Services (AWS), Microsoft Azure, or Google Cloud Platform (GCP), the provider secures the infrastructure, while you’re responsible for security measures within applications and configurations. Likewise, attacks on open source libraries have increased.

Cloud 177

Cloud Open Source Architecture Monitoring 177

SQL Server According to Bob

JANUARY 28, 2018

Note: SQL Server can be a client using a linked server, allowing SQL Server to become an APP and/or an RM ). The application then uses the SQL Server client (SQL Server ODBC for this example) to establish a TDS based connection to the target SQL Server (local or remote.). Local Host Name. The olehlp!

Servers 40

Servers Azure Engineering Java 40

Dynatrace

APRIL 5, 2021

What is Azure Functions? Similar to AWS Lambda , Azure Functions is a serverless compute service by Microsoft that can run code in response to predetermined events or conditions (triggers), such as an order arriving on an IoT system, or a specific queue receiving a new message. The growth of Azure cloud computing.

Azure 137

Azure Serverless IoT Lambda 137

ScaleOut Software

AUGUST 5, 2020

And how are they different from streaming pipelines like Azure Stream Analytics and Apache Flink/Beam? For example, consider a web-based ad-serving platform that selects ads for users and logs messages containing a timestamp, user ID, and ad ID every time an ad is displayed. An Example.

Analytics 69

Analytics Azure Processing Speed 69

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.

Servers 40

Servers Database Availability Azure 40

ScaleOut Software

APRIL 6, 2021

With the ScaleOut Digital Twin Streaming Service , an Azure-hosted cloud service, ScaleOut Software introduced breakthrough capabilities for streaming analytics using the real-time digital twin concept. The management console installs as a set of Docker containers on the management server.

IoT 52

IoT Azure Analytics Healthcare 52

SQL Server According to Bob

JUNE 22, 2016

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects. Keep in mind that the vast majority of CMemThread objects (SQL 2005, 2008, 2008 R2, 2012, 2014, Azure DB and 2016) are not partitioned. Trace flag –T8048 longer exists in SQL Server 2016.

Servers 40

Servers Azure Software Engineering Design 40

Particular Software

JANUARY 27, 2020

It is preceded in death by Windows Communication Foundation and Windows Workflow Foundation, and survived by Azure Queues and Azure Service Bus. Since it exists in Windows 10 and Windows Server 2019, MSMQ will continue to live on until at least 2029—and much longer assuming it isn't removed from future versions of Windows.

Transportation 98

Transportation Azure Open Source Systems 98

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

Scalegrid

JULY 8, 2019

So many default to Amazon RDS, when MySQL performs exceptionally well on Azure Cloud. While Microsoft Azure does offer a managed solution, Azure Database, the solution has some major limitations you should know about before migrating your MySQL deployments. A good example would be slow query analysis.

Azure 219

Azure Cloud Virtualization Database 219

ScaleOut Software

JUNE 22, 2020

The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times. They transparently distribute stored objects across the cluster’s servers and ensure that data is not lost if a server or network component fails.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

ScaleOut Software

JUNE 22, 2020

The pace of these changes has made it challenging for server-based infrastructures to manage fast-growing populations of users and data sources while maintaining fast response times. They transparently distribute stored objects across the cluster’s servers and ensure that data is not lost if a server or network component fails.

Ecommerce 52

Ecommerce Cache Scalability IoT 52

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 44

AWS Servers Storage Cloud 44

Percona

JANUARY 24, 2023

For example, for GKE, you must create a VolumeSnapshotClass resource first. For example, for my MongoDB cluster, I have six PVCs: three x replica set nodes and three x config server nodes. Example for mongod-data-my-cluster-name-cfg-0 : apiVersion: snapshot.storage.k8s.io/v1 Please contact us here to ensure data safety.

Database 69

Database Storage Open Source AWS 69

cdemi

FEBRUARY 20, 2017

Let's talk about the elephant in the room; Serverless doesn't really mean that there are no Software or Hardware servers. It just means that from Software Development perspective, servers are abstracted and outsourced to another entity, so you don't need to worry about it. On Public Clouds: Microsoft: Azure Functions.

Serverless 64

Serverless Architecture Lambda Azure 64

SQL Server According to Bob

JUNE 27, 2016

To some of you SQL Server On Linux is old news from various announcements made a couple of months ago. Yes, SQL Server runs on Linux! It was Jan 2015, in my previous supportability role, that I started looking at SQL Server on Linux. I proceeded to install an Ubuntu VM and the internal build of SQL Server on Linux.

Servers 40

Servers Games Azure Software Engineering 40

Dynatrace

SEPTEMBER 30, 2021

Cloud services platforms like AWS, Azure, and GCP are reshaping how organizations deliver value to their customers, making cloud migration an increasingly attractive option for running applications. For example, as traffic increases, costs will too. But what does it take to migrate your existing applications to the cloud? Reduced cost.

Cloud 165

Cloud Traffic Best Practices Strategy 165

Abhishek Tiwari

JULY 22, 2023

In this article, we will explore into the significance of pre-deployment policy compliance, explore the role of policy as code frameworks, and showcase real-life examples of successful implementations. For example, OPA can be used to enforce policies related to Kubernetes deployments, API access control, and more.

AWS 52

AWS Best Practices Infrastructure Traffic 52

High Scalability

JUNE 22, 2018

And if you know anyone looking for a simple book that uses lots of pictures and lots of examples to explain the cloud, then please recommend my new book: Explain the Cloud Like I'm 10. Charlie Demerjian : what does Intel have planned for their server roadmap? Eitally : there are a few critical differences between GCP and AWS or Azure.

Internet 113

Internet Internet Scalability Artificial Intelligence 113

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

Dynatrace

APRIL 1, 2021

Versatile, feature-rich cloud computing environments such as AWS, Microsoft Azure, and GCP have been a game-changer. Cloud computing environments like AWS, Azure, and GCP offer a wide array of computing capabilities and capacity. Without the overhead of establishing and maintaining on-premises servers, these systems save resources.

Azure 172

Azure AWS DevOps Cloud 172

Dynatrace

JUNE 24, 2019

Dynatrace already offers rich support for tracing your business requests end to end, including all major queue vendors from ActiveMQ , HornetQ , RabbitMQ , Tibco EMS , Software AG’s webMethods Broker and Universal messaging , Azure Service Bus , and IBM MQ. See the example below of a remote queue that Dynatrace is unaware of.

Azure 103

Azure Monitoring Programming Servers 103