RKL eSolutions Blog Trends and Insights

What are Statistics in SQL Server and why do they matter to me?

  What are Statistics in SQL Server and why do they matter to me? Executive summary – You want to ensure that at the data base level your configuration to maintain statistics are set properly. This means that AUTO_CREATE_STATISTICS is set to ON, ...

Perfmon: Creating a SQL Server Data Collector Set

A Performance Monitor Data Collector (DC) Set is used to automatically log performance counters into a binary file for analysis later. We will configure the DC to automatically start each data and after server restarts. It will also be configured to ...

Perfmon: Adding and Understanding Counters

I have been blogging about performance monitor as I am finding that this tool is invaluable for troubleshooting performance on Sage X3, Sage 100 and Sage 500 systems. As a system architect and performance tuner on these systems, I use Perfmon to ...

Windows Performance Monitor – Configuring the Display

Performance Monitor has quite a few configuration options. In this blog post I’ll cover the following: View Types Configuring the views

Performance Monitor Overview

Using Extended Events to Performance Tune Sage 500 – Part 7

Using Extended Events to Performance Tune Sage 500 - Part 7 Analyze the data for queries that aggregate to large impact In this final post I am looking for queries that don’t show in the query for longest duration by individual run, but still have ...

Using Extended Events to Performance Tune Sage 500 – Part 6

Using Extended Events to Performance Tune Sage 500 - Part 6 Analyze the data for long-running single queries Wow, you are getting close to the finish…and so am I! Again this post assumes that you have followed the previous 5 parts in this blog ...

Using Extended Events to Performance Tune Sage 500 – Part 5

Using Extended Events to Performance Tune Sage 500 - Part 5 Add helper columns to the XE table In this point of the series, I am assuming that you have followed parts 1 through 4 and have an Extended Events trace table in a test or development ...