{"ID":"a1044447-5366-4e88-9ee6-6089f5d14b29","VersionNumber":1,"Name":"SQL Server: Forwarded Records/sec","Description":"\r\n\r\n\t\r\n\t\t\r\n\t\t\r\n\t\t\r\n\t\r\n\t\r\n\t\t

Number of records per second fetched through forwarded record pointers. This number should be as close to 0 as possible.

https://www.mssqltips.com/sqlservertutorial/9184/windows-performance-monitor-counters-for-sql-server/

 

-Dexter Cox

\r\n\r\n","AppliesToObjectTypeID":"0a11a887-823a-4461-87af-321cad1c3623","ConditionCategoryID":"805a84c9-7f1b-4b4d-a9ad-3dddcf9e0f17","OwnerObjectID":"b7c74f24-1a45-4115-8262-d7613878bbd6","OwnerObjectTypeID":"894de672-3fc0-4779-9a0d-880d4c207c77","RuleDefinition":"{\"OperationTypeID\":\"6c3d38f1-9317-4258-972a-cfee0a0d76b5\",\"Children\":[{\"OperationTypeID\":\"8fa3cd6a-960c-43bb-96e0-94092fc2c296\",\"ValueDataTypeID\":\"b35a57f5-b8f6-4e4e-9380-e9d328e3eabf\",\"Left\":{\"ValueTypeID\":\"958b13fe-3149-4ee0-9104-edc0012f7566\",\"PerformanceCategoryType\":1,\"CounterID\":-245,\"CounterName\":\"Forwarded Records/sec\",\"CategoryName\":\"SQLServer:Access Methods\",\"InstanceType\":0,\"InstanceName\":null,\"PerformanceCounterValueRetrievalType\":0,\"BaselineAggregationMode\":null,\"CustomBaselineID\":null,\"GlobalBaselineName\":null},\"ComparisonType\":2,\"Right\":{\"ValueTypeID\":\"07f87b7f-c063-47a2-a5be-772ba85ed827\",\"Value\":\"0\"},\"ID\":\"1\"}],\"BooleanOperationType\":0,\"ID\":\"0\"}","EvaluationFrequency":"00:00:30","IdlePeriod":"00:01:00","MaximumAllowedDuration":"00:00:05","AntiConditionID":"be952f09-b290-46f3-9e1f-9c886616ec89","MinWindowsVersion":null,"MaxWindowsVersion":null,"MinSQLServerVersion":null,"MaxSQLServerVersion":null,"MinSSASVersion":null,"MaxSSASVersion":null,"MinVmwareVersion":null,"MaxVmwareVersion":null,"MinSqlDbVersion":null,"MaxSqlDbVersion":null,"MaximumInstanceCount":100,"ColorIndicator":-1739406,"Severity":1,"Signature":{"ConditionID":"a1044447-5366-4e88-9ee6-6089f5d14b29","VersionNumber":1,"AppliesToObjectTypeID":"0a11a887-823a-4461-87af-321cad1c3623","RuleDefinition":"{\"OperationTypeID\":\"6c3d38f1-9317-4258-972a-cfee0a0d76b5\",\"Children\":[{\"OperationTypeID\":\"8fa3cd6a-960c-43bb-96e0-94092fc2c296\",\"ValueDataTypeID\":\"b35a57f5-b8f6-4e4e-9380-e9d328e3eabf\",\"Left\":{\"ValueTypeID\":\"958b13fe-3149-4ee0-9104-edc0012f7566\",\"PerformanceCategoryType\":1,\"CounterID\":-245,\"CounterName\":\"Forwarded Records/sec\",\"CategoryName\":\"SQLServer:Access Methods\",\"InstanceType\":0,\"InstanceName\":null,\"PerformanceCounterValueRetrievalType\":0,\"BaselineAggregationMode\":null,\"CustomBaselineID\":null,\"GlobalBaselineName\":null},\"ComparisonType\":2,\"Right\":{\"ValueTypeID\":\"07f87b7f-c063-47a2-a5be-772ba85ed827\",\"Value\":\"0\"},\"ID\":\"1\"}],\"BooleanOperationType\":0,\"ID\":\"0\"}","PublisherID":0,"PublishDateUtc":"2020-12-16T21:37:05","Rights":0,"SignatureVersion":1,"SignaturePublicKey":"uzJQ9gzevXFwOgw/hkcAtD+cA/bBbD1PRzhEZCxbZ6YwjJ1c9bbfXFItLQNwnm8bdWh2k57//qbpEj5DFHOW2EAjHc2Zw5m/vACm6OzelubPS5hbWvzshlaBJKm7KrpWQpPZClx/5eVvUVzOtlz+44RRTiOszObT58acJAQwA70=AQAB","Signature":"nEysmdY0+Kzzdtbbzol2mSiobuWtlj542qhQPL1jyXD6eJbLK28eKwBjsxOcs1HFao4QzCIeZjBcmu9Rm0AQoTN7KTx6HRP3C+sZ4gp0otjeo/dzM627EIcz7sii4kIqBCUxQwPwIjo9gUCXC8k145GhyaRF3ybY+taPHAkjq/k=","IsSelfPublishedCondition":true},"Tags":null,"Areas":["SQL Server: Key lookups/Forwarded recs"],"ConditionSystemVersion":3,"MinDBSchemaVersion":null,"MaxDBSchemaVersion":null,"Items":[]}