sqlserver性能调优

《sqlserver性能调优》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、ContentsOverview1Lesson1:GatheringandEvaluatingCoreInformation3Lesson2:UsingPerformanceMonitor19Lesson3:UsingSQLProfiler35Lesson4:UsingIndexTuningWizard57Lesson5:UsingOtherSystemTools67Module2:Tools–ExploringtheConditionsMicrosoftConfidentialMicrosoftConfidentialOverviewAttheendofthis

2、module,youwillbeableto:nListthebasicsetofinformationtocollecttohelpnarrowdownandidentifytheproblem.nExploreandconfirmconditionsormessagespresentedoralreadyknown.nDescribePerformanceMonitorandhowtouseittotroubleshootperformanceissues.nAnalyzeaPerformanceMonitorlogtoidentifypotentialper

3、formancebottlenecks.nListDBCCcommandsrelevanttoperformancetroubleshootinganddescribehowtheyareused.nAnalyzeDBCCcommandoutputtoidentifypotentialperformancebottlenecks.nListTraceFlagsrelevanttoperformancetroubleshootinganddescribehowtheyareused.nAnalyzeTraceFlagsoutput,ifany,toidentifyp

4、otentialperformancebottlenecks.nListProfilerEventsandtheirrespectivedatacolumnsrelevanttoperformancetroubleshootinganddescribehowtheyareused.nChooseandlogthenecessaryeventstotroubleshootperformanceissues.nAnalyzeProfilerLogtoidentifypotentialperformancebottlenecks.nDescribetheIndexTun

5、ingWizard’sarchitecture.nListthecommandargumentsfortheITWizexecutable.nDiscussconsiderationswhenusingtheIndexTuningWizard.nListothertoolsandcommandsrelevanttoperformancetroubleshootingnDescribewhatinformationcanbecollectedusingTList,Pviewer,Pstat,andVmstat.MicrosoftConfidentialnAnalyz

6、einformationcollectedusingTList,Pviewer,Pstat,andVmstat.nExplainwhyscriptsareusedtocollectinformation.nDiscussexamplesofhowscriptscanbeused.nDescribetheuseofMicrosoft®SQLServer™Profilertoreplaytraceandsimulatestress.nDescribetheuseofOStresstooltosimulatestress.nListexternalloadsimulat

7、iontools.MicrosoftConfidentialLesson1:GatheringandEvaluatingCoreInformationWhatYouWillLearnAftercompletingthislesson,youwillbeableto:nListthebasicsetofinformationtocollecttohelpnarrowingdownandidentifytheproblem.nExploreandconfirmconditionsormessagespresentedoralreadyknown.Recommended

8、Readi