微软内部资料-SQL性能优化1

4星(超过85%的资源)
所需积分/C币:26 2009-11-27 08:55:47 1.94MB APPLICATION/MSWORD
261
收藏 收藏
举报

Contents Overview 1 Lesson 1: Gathering and Evaluating Core Information 3 Lesson 2: Using Performance Monitor 19 Lesson 3: Using SQL Profiler 35 Lesson 4: Using Index Tuning Wizard 57 Lesson 5: Using Other System Tools 67 Module 2: Tools – Exploring the Conditions Overview At the end of this module, you will be able to:  List the basic set of information to collect to help narrow down and identify the problem.  Explore and confirm conditions or messages presented or already known.  Describe Performance Monitor and how to use it to troubleshoot performance issues.  Analyze a Performance Monitor log to identify potential performance bottlenecks.  List DBCC commands relevant to performance troubleshooting and describe how they are used.  Analyze DBCC command output to identify potential performance bottlenecks.  List Trace Flags relevant to performance troubleshooting and describe how they are used.  Analyze Trace Flags output, if any, to identify potential performance bottlenecks.  List Profiler Events and their respective data columns relevant to performance troubleshooting and describe how they are used.  Choose and log the necessary events to troubleshoot performance issues.  Analyze Profiler Log to identify potential performance bottlenecks.  Describe the Index Tuning Wizard’s architecture.  List the command arguments for the ITWiz executable.  Discuss considerations when using the Index Tuning Wizard.  List other tools and commands relevant to performance troubleshooting  Describe what information can be collected using TList, Pviewer, Pstat, and Vmstat.  Analyze information collected using TList, Pviewer, Pstat, and Vmstat.  Explain why scripts are used to collect information.  Discuss examples of how scripts can be used.  Describe the use of Microsoft® SQL Server™ Profiler to replay trace and simulate stress.  Describe the use of OStress tool to simulate stress.  List external load simulation tools. Lesson 1: Gathering a

...展开详情
立即下载
限时抽奖 低至0.43元/次
身份认证后 购VIP低至7折
一个资源只可评论一次,评论内容不能少于5个字
Ms.Pea 虽然是微软认证培训机构的自制教材,但版本太老了(2000),外加不完全,还要付费下载也是挺坑的了
2020-04-17
回复
wlf_xa 介绍的比较细,需要耐心的读,还是有很多收获的
2014-07-20
回复
lixivip3 是重复的。。是3.。。
2012-07-03
回复
您会向同学/朋友/同事推荐我们的CSDN下载吗?
谢谢参与!您的真实评价是我们改进的动力~
关注 私信
上传资源赚钱or赚积分
最新推荐
微软内部资料-SQL性能优化1 26积分/C币 立即下载
1/0