Performance Monitor report showing data collection set captured for memory performance

SQL Server monitoring tools for memory performance

March 27, 2019 by

Memory pressure slowing down queries This article is the sequel in a series about SQL Server monitoring tools and common performance issues. The first article SQL Server monitoring tools for disk I/O performance is about how to detect and solve high input/output on hard disk subsystems when doing too much work during peak or maintenance […]

BI performance counter: Total Memory Cache Hits – Web service

December 25, 2017 by

Applies to SSRS Description This counter monitors all reports that were retrieved directly from CPU in-memory without querying SQL Server’s report cache. This method of rendering a report is very fast as it avoids unnecessary SQL Server database roundtrips. The value returned is a numeric whole number which is reset every time the Report Server […]

BI performance counter: Cleaner Memory KB

December 25, 2017 by

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services internal server memory. It monitors the total amount of memory, in kilobytes (KB), known to the background cleaner. The total amount of memory refers to both shrinkable and non-shrinkable categories of Analysis Services internal server memory. Whilst shrinkable memory can easily […]

BI performance counter: Flat buffer memory

December 25, 2017 by

Applies to SSIS Description Flat buffers refer to special chunk of memory that is usually used by the data flow transformation components such as the Aggregate transform. This performance counter monitors the total number of these chunks of memory used by the Integration Services. The value of this performance counter is measured in bytes and […]

BI performance counter: Memory Limit Hard KB

December 25, 2017 by

Applies to SSAS Description Analysis Services uses memory limit settings to determine how it allocates and manages its internal memory. This performance counter measures, in kilobytes (KB), the hard memory limit from the SSAS msmdsrv.ini configuration file. Memory cleaner threads monitors this metric or file setting to determine the rate at which it will begin […]

BI performance counter: Memory Pressure State

December 25, 2017 by

Applies to SSRS Description SSRS response to request from client application can be affected by the available memory in the server. This performance counter gives you an indication of current memory state. Current memory state value can be in a range of 1 to 5, whereby 1: no memory pressure; 2: low memory pressure; 3: […]

BI performance counter: Memory size bytes

December 25, 2017 by

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services processing of aggregations in MOLAP data files and it monitors the total memory size, in bytes, of the current aggregations. Resolved by DBAs, Server administrators, BI developers Suggested solutions Consider changing the value of “LimitSystemFileCacheSizeMB” property according to your RAM requirements […]

BI performance counter: Memory size rows

December 25, 2017 by

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services processing of aggregations in MOLAP data files and it monitors the current row size of current aggregations in memory. Resolved by DBAs, Server administrators Suggested solutions Avoid doing unnecessary aggregations Reduce the number of attributes in the dimensions Increase the size […]

BI performance counter: Memory Usage KB

December 25, 2017 by

Applies to SSAS Description This performance counter relates to the measurement of Analysis Services internal server memory. It monitors, in kilobytes, the total virtual memory usage for the server process. The total virtual memory is calculated by adding up page files and physical memory. The value of this metric should be similar to what you […]

BI performance counter: Total Memory Cache Hits – Windows service

December 25, 2017 by

Applies to SSRS Description When a request for a report is received from the client, Report Server can either render the report using data from SQL Server, or retrieve the same copy of the report from a cache. This counter monitors all reports that were retrieved directly from CPU in-memory without querying SQL Server’s report […]

BI performance counter: Buffer memory

December 25, 2017 by

Applies to SSIS Description This performance counter measures the total number of physical or virtual memory currently being used by all SSIS packages and can be compared with the amount of available system memory to know if Integration Services processing is bottlenecked by the available RAM. The recommended value for this counter is the one […]

BI performance counter: Private buffer memory

December 25, 2017 by

Applies to SSIS Description A transformation task such as the Sort transform may require additional physical or virtual memory at runtime. In such cases, the data flow engine will generate a private buffer required by the given data transformation. This performance counter monitors the total number of physical and virtual memory created at runtime by […]

In-Memory OLTP Enhancements in SQL Server 2016

August 22, 2017 by

SQL Server In-Memory OLTP, also known as Hekaton when it was introduced in SQL Server 2014, provides us with the ability to move specific database tables and suitable stored procedures into memory and compile the stored procedures into native x86 code. As a result, you can easily query these database objects directly from memory with […]