Skip to content

SQL Smith

  • Home
  • About Me
  • Blog
  • Contact Me
  • Projects
  • Training / Certifications

Category: SSAS Performance

Using Relog Load Perfmon Data Into a SQL Server Database

October 14, 2018 Kris

Relog is a command line tool that you use to convert the file output created by Perfmon.  It can convert…

Continue Reading →

Posted in: SSAS Performance

Creating A Performance Monitor (Perfmon) Data Collector Sets for SSAS

October 13, 2018 Kris

A data collector set is a collection of saved perfmon counters.  Once a data collector set is created it can…

Continue Reading →

Posted in: SSAS Performance

Cancelling A Long Running Query in SSAS

October 7, 2018 Kris

Cancelling a query in SSAS is not as straight forward it should be.  There’s not an activity monitor for SSAS…

Continue Reading →

Posted in: SSAS Performance

Frequently Used DMVs for SSAS

September 29, 2018 Kris

Brief Overview of SSAS DMVs DMVs are really just queries that return information about the server.  Introduced in SQL Server…

Continue Reading →

Posted in: SSAS Performance Filed under: DMVs, Monitoring, SSAS

Perfmon Counters I Collect For SSAS Monitoring

September 22, 2018 Kris

The counters can be grouped in general categories; OS, Processing, and Query.  SSAS is a service running on a Windows OS. …

Continue Reading →

Posted in: SSAS Performance Filed under: Monitoring, Perfmon, Performance, SSAS, Tuning

Recent Posts

  • Checklist for Creating a SSAS Multidimensional Dimension
  • Checklist For Creating a New Analysis Services Project
  • ODBC Destination” failed validation and returned validation status “VS_ISCORRUPT

Recent Comments

    Archives

    • April 2019
    • March 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • November 2017

    Join The Newsletter

    Sign up to receive timely, useful information in your inbox.


    Copyright © 2025 SQL Smith — Velux WordPress theme by GoDaddy