article thumbnail

Extend business observability: Extract business events from online databases (Part 2)

Dynatrace

In part 2, we’ll show you how to retrieve business data from a database, analyze that data using dashboards and ad hoc queries, and then use a Davis analyzer to predict metric behavior and detect behavioral anomalies. Similar to the tutorial extension, we created an extension that performs queries against databases.

Database 269
article thumbnail

Transfer Stored Procedures between master databases on SQL Server instances using SSDT 2017

SQL Shack

This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database. You can […].

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

TTP-based threat hunting with Dynatrace Security Analytics and Falco Alerts solves alert noise

Dynatrace

In the following sections, we demo the following: Introduce Unguard, our insecure cloud-native microservices demo application. Setting up our TTP-based threat-hunting demo environment Before we start threat hunting, we’ll first walk through how to set up the demo environment. Therefore, we filtered them out with DQL.

Analytics 195
article thumbnail

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. Pam Lahoud also did a quick demo in her PASS Summit general session.

Servers 95
article thumbnail

The road to observability demo part 3: Collect, instrument, and analyze telemetry data automatically with Dynatrace

Dynatrace

We also introduced our demo app and explained how to define the metrics and traces it uses. The second part, The road to observability with OpenTelemetry part 2: Setting up OpenTelemetry and instrumenting applications , covers the details of how to set up OpenTelemetry in our demo application and how to instrument the services.

Metrics 171
article thumbnail

Bandwidth or Latency: When to Optimise for Which

CSS Wizardry

The waterfall I used as a demo was exactly that—a demo. To help demystify it, look at the Server Timing API. ↩ That’s a lot of work, and with smaller files, it may be unsurprising to learn that negotiating all of that network overhead can often take longer than the content download itself. Important Considerations.

Latency 133
article thumbnail

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. ALTER DATABASE [ WideWorldImporters ] SET QUERY_STORE = ON ; GO. sort, hash).

Servers 41