如何对SQL Server查询进行基准测试? [英] How to benchmark a SQL Server Query?

问题描述

我想了解基准测试SQL Server查询的标准方法，最好是我想了解SQL Server随附的工具，而不是第三方工具.

I'd like to know the standard way to benchmark a SQL Sever Query, preferably I'd like to know about the tools that come with SQL Server rather than 3rd Party tools.

推荐答案

将showplan_text设置为on 将显示执行计划(以图形方式使用 CTRL + K (sql 2000)或 CTRL + M (sql 2005 +)

set showplan_text on will show you the execution plan (to see it graphically use CTRL + K (sql 2000) or CTRL + M (sql 2005 +)

将统计信息IO设置为打开 将为您显示阅读内容

set statistics IO on will show you the reads

开启统计时间 将为您显示经过的时间

set statistics time on will show you the elapsed time

这篇关于如何对SQL Server查询进行基准测试?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！