Skip to content

Instantly share code, notes, and snippets.

@BrentOzar
Last active February 14, 2019 22:46
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save BrentOzar/44e4b7e889f7ba98fa5b7e367d3ddf4d to your computer and use it in GitHub Desktop.
Save BrentOzar/44e4b7e889f7ba98fa5b7e367d3ddf4d to your computer and use it in GitHub Desktop.
{
"createIndexDetails":{
"indexName":"nci_wi_Badges_6E3E4E1FB3A8DD0F4201053BD6EA0D5F",
"indexType":"NONCLUSTERED",
"schema":"[dbo]",
"table":"[Badges]",
"indexColumns":"[Name], [Date]",
"includedColumns":"[UserId]",
"indexActionStartTime":"2019-02-14T13:12:15",
"indexActionDuration":"00:02:56.9860000"
},
"implementationDetails":{
"method":"TSql",
"script":"-- The script to apply the recommendation is the following:\rCREATE NONCLUSTERED INDEX [nci_wi_Badges_6E3E4E1FB3A8DD0F4201053BD6EA0D5F] ON [dbo].[Badges] ([Name], [Date]) INCLUDE ([UserId]) WITH (ONLINE = ON)\r\r-- The script to revert the recommendation is the following:\rDROP INDEX [nci_wi_Badges_6E3E4E1FB3A8DD0F4201053BD6EA0D5F] ON [dbo].[Badges] WITH (WAIT_AT_LOW_PRIORITY (MAX_DURATION = 1 MINUTES, ABORT_AFTER_WAIT = NONE))"
},
"errorDetails":{
"errorCode":null,
"isRetryable":""
},
"estimatedImpact":[
{
"dimensionName":"SpaceChange",
"unit":"Megabytes",
"absoluteValue":1690.1796875,
"changeValueAbsolute":null,
"changeValueRelative":null
}
],
"observedImpact":[
{
"dimensionName":"VerificationProgress",
"unit":"Percent",
"absoluteValue":0.99993894414982676,
"changeValueAbsolute":null,
"changeValueRelative":null
},
{
"dimensionName":"SpaceChange",
"unit":"Megabytes",
"absoluteValue":1641.984375,
"changeValueAbsolute":null,
"changeValueRelative":null
},
{
"dimensionName":"QueriesWithImprovedPerformance",
"unit":"Count",
"absoluteValue":2.0,
"changeValueAbsolute":null,
"changeValueRelative":null
},
{
"dimensionName":"QueriesWithRegressedPerformance",
"unit":"Count",
"absoluteValue":0.0,
"changeValueAbsolute":null,
"changeValueRelative":null
},
{
"dimensionName":"CpuUtilization",
"unit":"CpuCores",
"absoluteValue":null,
"changeValueAbsolute":-0.0854479608835186,
"changeValueRelative":-0.02005553257123055
},
{
"dimensionName":"LogicalReads",
"unit":"ReadsPerSecond",
"absoluteValue":null,
"changeValueAbsolute":-1837.654694200344,
"changeValueRelative":-0.0032872612187644472
},
{
"dimensionName":"LogicalWrites",
"unit":"WritesPerSecond",
"absoluteValue":null,
"changeValueAbsolute":-0.00068247991206702525,
"changeValueRelative":-0.00056769959954218289
},
{
"dimensionName":"AffectedQueriesCpuUtilization",
"unit":"CpuCores",
"absoluteValue":null,
"changeValueAbsolute":-0.0854479608835186,
"changeValueRelative":-0.32860984824616157
},
{
"dimensionName":"AffectedQueriesLogicalReads",
"unit":"ReadsPerSecond",
"absoluteValue":null,
"changeValueAbsolute":-1837.654694200344,
"changeValueRelative":-0.1697462012397688
},
{
"dimensionName":"AffectedQueriesLogicalWrites",
"unit":"WritesPerSecond",
"absoluteValue":null,
"changeValueAbsolute":-0.00068247991206702525,
"changeValueRelative":-0.47760683760683759
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment