PARAMETER SNIFFING讲解_相关内容

{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":4,"count":4}]},"card":[{"des":"阿里云数据库专家保驾护航，为用户的数据库应用系统进行性能和风险评估，参与配合进行数据压测演练，提供数据库优化方面专业建议，在业务高峰期与用户共同保障数据库系统平稳运行。","link1":"https://www.aliyun.com/service/optimization/database","link":"https://www.aliyun.com/service/chiefexpert/database","icon":"https://img.alicdn.com/tfs/TB1a5ZfonnI8KJjy0FfXXcdoVXa-100-100.png","btn2":"数据库紧急救援服务","tip":"还有更多专家帮助您解决云上业务问题：<a href=\"https://www.aliyun.com/service/list#f4\" target=\"_blank\">立即查看</a>","btn1":"云上数据库优化服务","link2":"https://www.aliyun.com/service/databaserescue","title":"数据库专家服务"}],"search":[{"txt":"安全首席专家","link":"https://www.aliyun.com/service/chiefexpert/security"},{"txt":"中间件首席专家","link":"https://www.aliyun.com/service/chiefexpert/middleware"},{"txt":"系统与平台首席专家","link":"https://www.aliyun.com/service/chiefexpert/platform"},{"txt":"存储首席专家","link":"https://www.aliyun.com/service/chiefexpert/storage"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","visual":{"textColor":"dark","topbg":""},"newCard":[{"link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"dbes","contentLink":"https://www.aliyun.com/product/dbes","title":"云数据库DBA专家服务","des":"云数据库DBA专家服务 ApsaraDB专家服务组，全部来自阿里云DBA团队和数据库内核团队，多次参与历年双11的护航保障活动，为客户提供阿里原厂顶尖水准的数据库服务。","btn1":"了解详情","link1":"https://www.aliyun.com/product/dbes","btn2":"管理控制台","link2":"https://dbes.console.aliyun.com/order","btn3":"在线咨询","link3":"https://www.aliyun.com/core/online-consult?spm=5176.8789780.7y9jhqsfz.115.47ea55caeL2Mfu&from=OVtXEBmlH8","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"运维难题一站解决","firstContentLink":"https://common-buy.aliyun.com/?spm=5176.cndbes.0.0.4f754dd8cFAmj3&commodityCode=dbes_es_pre#/buy","lastContentName":"ECS+MySQL 0.7元/日","lastContentLink":"https://www.aliyun.com/1111/enterprise"}},{"infoName":"快速入门","infoContent":{"firstContentName":"产品介绍","firstContentLink":"https://help.aliyun.com/document_detail/118910.html?spm=a2c4g.11186623.6.542.18083d5dasi1JQ","lastContentName":"计费方式","lastContentLink":"https://help.aliyun.com/document_detail/119643.html?spm=a2c4g.11186623.6.544.364a2d0ci3sAYx"}},{"infoName":"用户指南","infoContent":{"firstContentName":"服务流程","firstContentLink":"https://help.aliyun.com/document_detail/119687.html?spm=a2c4g.11186623.6.548.3cafa500YUcM2U","lastContentName":"使用手册","lastContentLink":"https://help.aliyun.com/document_detail/119688.html?spm=a2c4g.11186623.6.549.322f98d5dZsPtj"}},{"infoName":"产品推荐","infoContent":{"firstContentName":"数据湖分析","lastContentName":"云数据库MySQL","firstContentLink":"https://www.aliyun.com/product/datalakeanalytics","lastContentLink":"https://www.aliyun.com/product/rds/mysql"}}]}]}

{"$env":{"JSON":{}},"$page":{"env":"production"},"$context":{"moduleinfo":{"card_count":[{"count_phone":1,"count":1}],"search_count":[{"count_phone":4,"count":4}]},"card":[{"des":"阿里云数据库专家保驾护航，为用户的数据库应用系统进行性能和风险评估，参与配合进行数据压测演练，提供数据库优化方面专业建议，在业务高峰期与用户共同保障数据库系统平稳运行。","link1":"https://www.aliyun.com/service/optimization/database","link":"https://www.aliyun.com/service/chiefexpert/database","icon":"https://img.alicdn.com/tfs/TB1a5ZfonnI8KJjy0FfXXcdoVXa-100-100.png","btn2":"数据库紧急救援服务","tip":"还有更多专家帮助您解决云上业务问题：<a href=\"https://www.aliyun.com/service/list#f4\" target=\"_blank\">立即查看</a>","btn1":"云上数据库优化服务","link2":"https://www.aliyun.com/service/databaserescue","title":"数据库专家服务"}],"search":[{"txt":"安全首席专家","link":"https://www.aliyun.com/service/chiefexpert/security"},{"txt":"中间件首席专家","link":"https://www.aliyun.com/service/chiefexpert/middleware"},{"txt":"系统与平台首席专家","link":"https://www.aliyun.com/service/chiefexpert/platform"},{"txt":"存储首席专家","link":"https://www.aliyun.com/service/chiefexpert/storage"}],"countinfo":{"search":{"length_pc":0,"length":0},"card":{"length_pc":0,"length":0}},"simplifiedDisplay":"newEdition","visual":{"textColor":"dark","topbg":""},"newCard":[{"link":"https://img.alicdn.com/tfs/TB1XY8hGYr1gK0jSZFDXXb9yVXa-1740-328.png","icon":"dbes","contentLink":"https://www.aliyun.com/product/dbes","title":"云数据库DBA专家服务","des":"云数据库DBA专家服务 ApsaraDB专家服务组，全部来自阿里云DBA团队和数据库内核团队，多次参与历年双11的护航保障活动，为客户提供阿里原厂顶尖水准的数据库服务。","btn1":"了解详情","link1":"https://www.aliyun.com/product/dbes","btn2":"管理控制台","link2":"https://dbes.console.aliyun.com/order","btn3":"在线咨询","link3":"https://www.aliyun.com/core/online-consult?spm=5176.8789780.7y9jhqsfz.115.47ea55caeL2Mfu&from=OVtXEBmlH8","infoGroup":[{"infoName":"最新活动","infoContent":{"firstContentName":"运维难题一站解决","firstContentLink":"https://common-buy.aliyun.com/?spm=5176.cndbes.0.0.4f754dd8cFAmj3&commodityCode=dbes_es_pre#/buy","lastContentName":"ECS+MySQL 0.7元/日","lastContentLink":"https://www.aliyun.com/1111/enterprise"}},{"infoName":"快速入门","infoContent":{"firstContentName":"产品介绍","firstContentLink":"https://help.aliyun.com/document_detail/118910.html?spm=a2c4g.11186623.6.542.18083d5dasi1JQ","lastContentName":"计费方式","lastContentLink":"https://help.aliyun.com/document_detail/119643.html?spm=a2c4g.11186623.6.544.364a2d0ci3sAYx"}},{"infoName":"用户指南","infoContent":{"firstContentName":"服务流程","firstContentLink":"https://help.aliyun.com/document_detail/119687.html?spm=a2c4g.11186623.6.548.3cafa500YUcM2U","lastContentName":"使用手册","lastContentLink":"https://help.aliyun.com/document_detail/119688.html?spm=a2c4g.11186623.6.549.322f98d5dZsPtj"}},{"infoName":"产品推荐","infoContent":{"firstContentName":"数据湖分析","lastContentName":"云数据库MySQL","firstContentLink":"https://www.aliyun.com/product/datalakeanalytics","lastContentLink":"https://www.aliyun.com/product/rds/mysql"}}]}]}}

云数据库DBA专家服务

云数据库DBA专家服务 ApsaraDB专家服务组，全部来自阿里云DBA团队和数据库内核团队，多次参与历年双11的护航保障活动，为客户提供阿里原厂顶尖水准的数据库服务。

了解详情

管理控制台

在线咨询

参数嗅探（Parameter Sniffing）（2/2)

原文:参数嗅探（Parameter Sniffing）（2/2)在参数嗅探（Parameter Sniffing）（1/2)里，我介绍了SQL Server里参数嗅探的基本概念和背后的问题。如你所见，当缓存的计划被SQL Server盲目重用时，会带来严重的性能...

来自：阿里云 > 网站

阿里云SQL Server最佳实践：高CPU使用率问题排查

参数嗅探(Parameter Sniffing)统计信息(Statistics)TOP CPU查询(TOP SQL)一、缺失索引(Missing Indexes)为什么索引缺失会降低SQL Server的CPU使用率？真正排查出的高CPU使用率的第一大因素就是Missing Indexes，那么...

来自：阿里云 > 网站

< >

共有0页跳转至： GO

产品推荐: 云服务器商标 SSL证书短信服务块存储轻量应用服务器对象存储全站加速 DCDN

这些文档可能帮助您: 申请备案服务号网站域名准备与检查网站添加备案号FAQ 个人实名认证企业实名认证和个体工商户认证公安联网备案信息填写指南

PARAMETER SNIFFING讲解_相关内容

参数嗅探（Parameter Sniffing）（2/2)

阿里云SQL Server最佳实践：高CPU使用率问题排查

你可能感兴趣

热门推荐