RKL eSolutionsBlogs

John Puttman

Recent Posts

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, .

Continue reading
Tagged With: SQL Server

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 .

Continue reading
Tagged With: Sage 500, Sage X3, How-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 .

Continue reading
Tagged With: How-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

Continue reading
Tagged With: How-To

Performance Monitor Overview

 

Continue reading
Tagged With: How-To

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 .

Continue reading
Tagged With: Sage 500

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 .

Continue reading
Tagged With: Sage 500

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 .

Continue reading
Tagged With: Sage 500

Questions? Need Support?
Get in Touch