RKL eSolutionsBlogs

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 .