9.6.10: Service Pack 1

This topic contains information about fixes and updates in this service pack.

For information about issues corrected in this service pack, see Known-and-corrected-issues.

- What's new

What's new

Tolerance support for Microsoft SQL Server 2016

BMC PATROL for Microsoft SQL Server supports only those features of Microsoft SQL Server 2016 that are covered by the existing monitor types.

Enhanced the KM to support In-Memory Online Transaction Processing

QM001886855: Introduced support for Microsoft SQL Server In-Memory Online Transaction Processing (OLTP) for databases. The new metrics are:

Monitor types	Attributes
MS SQL Server Perfmon Xtp Cursors	Click here to expand... Cursor deletes/sec (CursorDeletes) Cursor inserts/sec (CursorInserts) Cursor scans started/sec (CursorScansStarted) Cursor unique violations/sec (CursorUniqueViolations) Cursor updates/sec (CursorUpdates) Cursor write conflicts/sec (CursorWriteConflicts) Dusty corner scan retries/sec (user-issued) (DustyCornerScanRetriesUser) Expired rows removed/sec (ExpiredRowsRemoved) Expired rows touched/sec (ExpiredRowsTouched) Rows returned/sec (RowsReturned) Rows touched/sec (RowsTouched) Tentatively-deleted rows touched/sec (TentativelyDeletedRowsTouched)
MS SQL Server Perfmon Databases	Click here to expand... XTP Controller DLC Latency/Fetch (XTPControllerDLCLatency) XTP Controller DLC Peak Latency (XTPControllerDLCPeakLatency) XTP Controller Log Processed/sec (XTPControllerLogProcessedSec) XTP Memory Used (KB) (XTPMemoryUsedKB)
MS SQL Server Perfmon Xtp IO Governor	Click here to expand... Insufficient Credits Waits/sec (InsufficientCreditsWaits) Io Issued/sec (IoIssued) Log Blocks/sec (LogBlocks) Missed Credit Slots (MissedCreditSlots) Stale Rate Object Waits/sec (StaleRateObjectWaits) Total Rate Objects Published (TotalRateObjectsPublished)
MS SQL Server Perfmon Xtp Garbage Collection	Click here to expand... Dusty corner scan retries/sec (GC-issued) (DustyCornerScanRetriesGCIssued) Main GC work items/sec (MainGCWorkItems) Parallel GC work item/sec (ParallelGCWorkItem) Rows processed/sec (first in bucket and removed) (RowsProcessedFirstInAndRemoved) Rows processed/sec (first in bucket) (RowsProcessedFirstInBucket) Rows processed/sec (marked for unlink) (RowsProcessedMarkedForUnlink) Rows processed/sec (no sweep needed) (RowsProcessedNoSweepNeeded) Rows processed/sec (RowsProcessed) Sweep expired rows removed/sec (SweepExpiredRowsRemoved) Sweep expired rows touched/sec (SweepExpiredRowsTouched) Sweep expiring rows touched/sec (SweepExpiringRowsTouched) Sweep rows touched/sec (SweepRowsTouched) Sweep scans started/sec (SweepScansStarted)
MS SQL Server Perfmon Xtp Storage	Click here to expand... Checkpoints Closed (CheckpointsClosed) Checkpoints Completed (CheckpointsCompleted) Core Merges Completed (CoreMergesCompleted) Merge Policy Evaluations (MergePolicyEvaluations) Merge Requests Outstanding (MergeRequestsOutstanding) Merges Abandoned (MergesAbandoned) Merges Installed (MergesInstalled) Total Files Merged (TotalFilesMerged)
MS SQL Server Perfmon Xtp Transactions	Click here to expand... Cascading aborts/sec (CascadingAborts) Commit dependencies taken/sec (CommitDependenciesTaken) Read-only transactions prepared/sec (ReadOnlyTransactionsPrepared) Save point refreshes/sec (SavePointRefreshes) Save point rollbacks/sec (SavePointRollbacks) Save points created/sec (SavePointsCreated) Transaction validation failures/sec (TransactionValidationFailures) Transactions aborted by user/sec (TransactionsAbortedByUser) Transactions aborted/sec (TransactionsAborted) Transactions created/sec (TransactionsCreated)
MS SQL Server Perfmon Xtp Transaction Log	Click here to expand... Log bytes written/sec (LogBytesWritten) Log records written/sec (LogRecordsWritten)

Added support for Logpool Freepool and Query Store perfmon counters

The KM now supports Logpool Freepool and Query Store perfmon counters. The new metrics are:


MS SQL Server Perfmon Logpool Freepool	Click here to expand... Free Buffer Refills Sec (FreeBufferRefillsSec) Free List Length (FreeListLength)
MS SQL Server Perfmon Query Store	Click here to expand... Query Store CPU usage (QueryStoreCPUusage) Query Store logical reads (QueryStoreLogicalReads) Query Store logical writes (QueryStoreLogicalWrites) Query Store physical reads (QueryStorePhysicalReads)

Enhanced the KM to support Columnstore Index feature

QM001886856: Introduced support for Microsoft SQL Server Columnstore Index feature.

Monitor type	Attributes
MS SQL Server Perfmon Columnstore	Click here to expand... Delta Rowgroups Closed (DeltaRowgroupsClosed) Delta Rowgroups Compressed (DeltaRowgroupsCompressed) Delta Rowgroups Created (DeltaRowgroupsCreated) Segment Cache Hit Ratio (SegmentCacheHitRatio) Segments Reads/Sec (SegmentsReadsSec) Total Delete Buffers Migrated (TotalDeleteBuffersMigrated) Total Merge Policy Evaluations (TotalMergePolicyEvaluations) Total Rowgroups Compressed (TotalRowgroupsCompressed) Total Rowgroups Fit For Merge (TotalRowgroupsFitForMerge) Total Rowgroups Merge Compressed (TotalRowgroupsMergeCompressed) Total Source Rowgroups Merged (TotalSourceRowgroupsMerged)

Monitor type

Attributes

MS SQL Server Perfmon Columnstore

Click here to expand...

Added the ability to control the size of annotations of the SQL Agent Job Failures parameter

QM001822864: Size of the annotation messages of the SQL Agent Job Failures parameter can now be controlled. This can be done by updating the getFailedJobs query in the SqlQueries.xml file. This file is located in the %PATROL_HOME%\mssql\configuration directory.

Introduced new attributes in existing monitor types

Monitor types	Attributes
MS SQL Server Perfmon Buffer Manager	Click here to expand... Extension allocated pages (ExtensionAllocatedPages) Extension free pages (ExtensionFreePages) Extension in use as percentage (ExtensionInUseAsPercentage) Extension outstanding IO counter (ExtensionOutstandingIoCounter) Extension page evictions/sec (ExtensionPageEvictionsSec) Extension page reads/sec (ExtensionPageReadsSec) Extension page unreferenced time (ExtensionPageUnreferencedTime) Extension page writes/sec (ExtensionPageWritesSec)
MS SQL Server Perfmon Databases	Click here to expand... Avg Dist From EOL/LP Request (AvgDistFromEOL_LPRequest) Log Pool Hash Deletes/sec (LogPoolHashDeletesSec) Log Pool Hash Inserts/sec (LogPoolHashInsertsSec) Log Pool Invalid Hash Entry/sec (LogPoolInvalidHashEntrySec) Log Pool Log Scan Pushes/sec (LogPoolLogScanPushesSec) Log Pool LogWriter Pushes/sec (LogPoolLogWriterPushesSec) Log Pool Push Empty FreePool/sec (LogPoolPushEmptyFreePoolSec) Log Pool Push Low Memory/sec (LogPoolPushLowMemorySec) Log Pool Push No Free Buffer/sec (LogPoolPushNoFreeBufferSec) Log Pool Req. Behind Trunc/sec (LogPoolReqBehindTruncSec) Log Pool Requests Old VLF/sec (LogPoolRequestsOldVLFSec) Log Pool Total Active Log Size (LogPoolTotalActiveLogSize) Log Pool Total Shared Pool Size (LogPoolTotalSharedPoolSize)
MS SQL Server Perfmon HTTP Storage	Click here to expand... Avg. microsec/Read Comp (AvgMicrosecReadComp) Avg. microsec/Write Comp (AvgMicrosecWriteComp) HTTP Storage IO failed/sec (HTTPStorageIOFailedSec)
MS SQL Server Perfmon Database Replica	Click here to expand... Log Apply Pending Queue (LogApplyPendingQueue) Log Apply Ready Queue (LogApplyReadyQueue)
MS SQL Server Perfmon Resource Pool Stats	Click here to expand... CPU delayed % (CPUDelayedPercentage) CPU effective % (CPUEffectivePercentage) CPU violated % (CPUViolatedPercentage)
MS SQL Server Perfmon Workload Group Stats	Click here to expand... CPU delayed %   (CPUDelayedPercentage) CPU effective %   (CPUEffectivePercentage) CPU violated %   (CPUViolatedPercentage)