Dynatrace

FEBRUARY 1, 2020

Modern web applications rely heavily on Content Delivery Networks (CDNs) and 3rd-party integrations (for example, web analytics, tag managers, chat bots, A/B testing tools, ad providers, and more). This approach was already at its limit back in 2008 when an Akamai CDN network had only ~25,000 delivery nodes. Dynatrace news.

Tuning 185

Tuning Monitoring Network Best Practices 185

SQL Server According to Bob

JANUARY 11, 2020

Using SQL Server’s SNITrace to Troubleshoot Networking Issues In the process of tracking down a few TCP 10054 issues (highlighted here: ​​ [link] ) I ​​ also ​​ used ​​ the ​​ SNITrace ​​ (SNI Trace) ​​ capabilities.

Network 40

Network Servers Processing Software Engineering 40

SQL Performance

JANUARY 22, 2020

Table-valued parameters have been around since SQL Server 2008 and provide a useful mechanism for sending multiple rows of data to SQL Server, brought together as a single parameterized call. The DataTable can be created multiple ways in the.NET code, but a common way to create the table is something like the following: System.

Servers 55

Servers Azure Hardware Network 55

Dean Hume

APRIL 24, 2018

Each HTTP request that is required for the page needs to travel over the network and in turn this consumes energy on both the server and client. CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). Unfortunately, that’s not where it ends. It’s a win-win all round!

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Each HTTP request that is required for the page needs to travel over the network and in turn this consumes energy on both the server and client. CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). Unfortunately, that’s not where it ends. It’s a win-win all round!

Energy 40

Energy Cache Traffic Website 40

Dean Hume

APRIL 24, 2018

Each HTTP request that is required for the page needs to travel over the network and in turn this consumes energy on both the server and client. CPU Utilization and Power Consumption (Source: Blackburn 2008). Server Power Consumption (Source: Intel Labs 2008). Unfortunately, that’s not where it ends. It’s a win-win all round!

Energy 40

Energy Cache Traffic Website 40

SQL Performance

SEPTEMBER 17, 2019

SSRS 2008 brought that component into the reporting service module. You need to be monitoring memory/disk/CPU utilization, network I/O, tempdb usage, waits, and other counters to know what is normal for the overall workload of those systems. The real magic for making reports run faster is to optimize for that report.

Tuning 67

Tuning Servers Database Best Practices 67