简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

求一款sqlserver 2008 性能检测工具

WBOY
Release： 2016-06-07 15:39:44
Original
1408 people have browsed it

SQL Server自带的Profiler 这个肯定是首选， 然后在开启以下几个监控 SET STATISTICSIOON //可以准确的看到SQL读取数据的次数 SETSHOWPLAN_ALL ON //显示[返回有关语句执行情况的详细信息，并估计语句对资源的需求] SETSTATISTICS Time ON //显示语句执行的

SQL Server自带的Profiler 这个肯定是首选，

然后在开启以下几个监控 

SET STATISTICS IO ON  //可以准确的看到SQL读取数据的次数

 

SET SHOWPLAN_ALL  ON  //显示[返回有关语句执行情况的详细信息，并估计语句对资源的需求]

SET STATISTICS Time ON   //显示语句执行的时间 包括CPU 语句的计算 等等 

还有DBCC 的语句可以直接看到所执行的SQL语句的各种信息，这个LZ找Google吧 

 

 

Related labels：
sql sqlserver tool performance Detection
source：php.cn
Previous article：MySQL的备份与还原 Next article：DataContext 连接SqlServer2008 出现40错误
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
The child window operates the parent window, but the output does not respond. The first two sentences are executable, but the last sentence cannot be implemented.
From 2024-04-19 15:37:47
0
1
1361
PHP arrays obtained from URL parameters do not behave as expected I have a URL parameter that contains the category ID and I want to treat it as an array li...
From 2024-04-06 22:09:02
0
1
1428
Move the content to the left by adding the Width property I have provided margins to the body. main {left margin: 200px; right margin: 200px; text a...
From 2024-04-06 22:01:35
0
3
816
What is the format of the variables in the return value? I am a new learner of php. I found a piece of code: if($x<time()){return[false,'error']...
From 2024-04-06 21:55:20
0
1
778
The page suddenly cannot pull css or bootstrap So I'm developing a page, I did part of it yesterday and it worked great, and today I cont...
From 2024-04-06 21:58:04
0
1
800
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！