SQLdiag-配置文件

生成的文件如下：SQLDIAG：收集PerfMon数据，对应PerfmonCollector元素WORK_SQLDIAG_SQL08R2_sp_trace：收集的跟踪数据，对应ProfilerCollector元素其他文件的说明见上一篇，在我本地收集5分钟性能监视器文件达到19Mb、跟踪数据文件为7Mb(没有做任何其他操作)。性能计数器数据，与收集计数器数量、轮询时间间隔有关。与收集时长是线性增长关系。跟踪数据，与添加的跟踪事件，系统繁忙程度有关。收集的大小可能不成比例地膨胀。建议在高峰时段短暂地运行SQLdiag约10-15分钟，来估计Profiler跟踪事件的生成率和耗费的磁盘空间。这使你能够在数据被改写之前，对将要捕获的活动的时间跨度形成一个粗略的近似。PerfMon文件并不像Profiler跟踪文件一样迅速地增大。Profiler跟踪收集到目前为止是SQLdiag中最消耗资源的数据收集组件。PerfmonCollector虽说收集PerfMon数据的开销相比其他数据收集器是最低的，但也不必要将所有性能计数据器都启用。本节将按照下面步骤测试：1>禁用EventlogCollector、BlockingCollector、ProfilerCollector、CustomDiagnostics元素收集器；PerfmonCollector、SqldiagCollector元素保持启用2>参照之前配置的数据收集器模板PerfmonLine启用/禁用PerfmonCollector元素下对应的计数器

<?xml version="1.0" encoding="UTF-16"?><DataCollectorSet> <Status>1</Status> <Duration>86100</Duration> <Description> </Description> <DescriptionUnresolved> </DescriptionUnresolved> <DisplayName> </DisplayName> <DisplayNameUnresolved> </DisplayNameUnresolved> <SchedulesEnabled>-1</SchedulesEnabled> <LatestOutputLocation>D:PerfmonDataCollector</LatestOutputLocation> <Name>PLAYER</Name> <OutputLocation>D:PerfmonDataCollector</OutputLocation> <RootPath>D:Perfmon</RootPath> <Segment>0</Segment> <SegmentMaxDuration>0</SegmentMaxDuration> <SegmentMaxSize>0</SegmentMaxSize> <SerialNumber>15</SerialNumber> <Server> </Server> <Subdirectory>DataCollector</Subdirectory> <SubdirectoryFormat>1</SubdirectoryFormat> <SubdirectoryFormatPattern> </SubdirectoryFormatPattern> <Task> </Task> <TaskRunAsSelf>0</TaskRunAsSelf> <TaskArguments> </TaskArguments> <TaskUserTextArguments> </TaskUserTextArguments> <UserAccount>SYSTEM</UserAccount> <Security>O:BAG:S-1-5-21-2109620463-1702659591-2666464273-513D:AI(A;;FA;;;SY)(A;;FA;;;BA)(A;;FR;;;LU)(A;;0x1301ff;;;S-1-5-80-2661322625-712705077-2999183737-3043590567-590698655)(A;ID;FA;;;SY)(A;ID;FA;;;BA)(A;ID;0x1200ab;;;LU)(A;ID;FR;;;AU)(A;ID;FR;;;LS)(A;ID;FR;;;NS)</Security> <StopOnCompletion>0</StopOnCompletion> <PerformanceCounterDataCollector> <DataCollectorType>0</DataCollectorType> <Name>DataCollector</Name> <FileName>PLAYER</FileName> <FileNameFormat>1</FileNameFormat> <FileNameFormatPattern>-yyyyMMdd</FileNameFormatPattern> <LogAppend>0</LogAppend> <LogCircular>0</LogCircular> <LogOverwrite>0</LogOverwrite> <LatestOutputLocation>D:PerfmonDataCollectorPLAYER-20151105.blg</LatestOutputLocation> <DataSourceName> </DataSourceName> <SampleInterval>30</SampleInterval> <SegmentMaxRecords>0</SegmentMaxRecords> <LogFileFormat>3</LogFileFormat> <Counter>MemoryAvailable MBytes</Counter> <Counter>MemoryCache Bytes</Counter> <Counter>MemoryCommit Limit</Counter> <Counter>MemoryCommitted Bytes</Counter> <Counter>MemoryFree System Page Table Entries</Counter> <Counter>MemoryPages Input/sec</Counter> <Counter>MemoryPages/sec</Counter> <Counter>MemorySystem Cache Resident Bytes</Counter> <Counter>MSSQL$PLAYER:Access MethodsFreeSpace Scans/sec</Counter> <Counter>MSSQL$PLAYER:Access MethodsFull Scans/sec</Counter> <Counter>MSSQL$PLAYER:Access MethodsTable Lock Escalations/sec</Counter> <Counter>MSSQL$PLAYER:Access MethodsWorktables Created/sec</Counter> <Counter>MSSQL$PLAYER:Access MethodsWorktables From Cache Ratio</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerBuffer cache hit ratio</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerCheckpoint pages/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerDatabase pages</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerFree list stalls/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerFree pages</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerLazy writes/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerPage life expectancy</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerPage lookups/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerPage reads/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerPage writes/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerReadahead pages/sec</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerStolen pages</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerTarget pages</Counter> <Counter>MSSQL$PLAYER:Buffer ManagerTotal pages</Counter> <Counter>MSSQL$PLAYER:Databases(_Total)Transactions/sec</Counter> <Counter>MSSQL$PLAYER:General StatisticsConnection Reset/sec</Counter> <Counter>MSSQL$PLAYER:General StatisticsLogins/sec</Counter> <Counter>MSSQL$PLAYER:General StatisticsLogouts/sec</Counter> <Counter>MSSQL$PLAYER:General StatisticsProcesses blocked</Counter> <Counter>MSSQL$PLAYER:General StatisticsUser Connections</Counter> <Counter>MSSQL$PLAYER:LatchesAverage Latch Wait Time (ms)</Counter> <Counter>MSSQL$PLAYER:LatchesLatch Waits/sec</Counter> <Counter>MSSQL$PLAYER:LatchesTotal Latch Wait Time (ms)</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Average Wait Time (ms)</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Lock Requests/sec</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Lock Timeouts (timeout > 0)/sec</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Lock Timeouts/sec</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Lock Wait Time (ms)</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Lock Waits/sec</Counter> <Counter>MSSQL$PLAYER:Locks(_Total)Number of Deadlocks/sec</Counter> <Counter>MSSQL$PLAYER:Memory ManagerGranted Workspace Memory (KB)</Counter> <Counter>MSSQL$PLAYER:Memory ManagerMaximum Workspace Memory (KB)</Counter> <Counter>MSSQL$PLAYER:Memory ManagerMemory Grants Outstanding</Counter> <Counter>MSSQL$PLAYER:Memory ManagerMemory Grants Pending</Counter> <Counter>MSSQL$PLAYER:Memory ManagerStolen Server Memory (KB)</Counter> <Counter>MSSQL$PLAYER:Memory ManagerTarget Server Memory (KB)</Counter> <Counter>MSSQL$PLAYER:Memory ManagerTotal Server Memory (KB)</Counter> <Counter>MSSQL$PLAYER:Plan Cache(_Total)Cache Hit Ratio</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsAuto-Param Attempts/sec</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsBatch Requests/sec</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsFailed Auto-Params/sec</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsSafe Auto-Params/sec</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsSQL Compilations/sec</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsSQL Re-Compilations/sec</Counter> <Counter>MSSQL$PLAYER:SQL StatisticsUnsafe Auto-Params/sec</Counter> <Counter>MSSQL$PLAYER:TransactionsLongest Transaction Running Time</Counter> <Counter>Network Interface(*)Bytes Sent/sec</Counter> <Counter>Paging File(_Total)\% Usage Peak</Counter> <Counter>Paging File(_Total)\% Usage</Counter> <Counter>PhysicalDisk(1 D:)\% Idle Time</Counter> <Counter>PhysicalDisk(1 D:)Avg. Disk Queue Length</Counter> <Counter>PhysicalDisk(1 D:)Avg. Disk sec/Read</Counter> <Counter>PhysicalDisk(1 D:)Avg. Disk sec/Transfer</Counter> <Counter>PhysicalDisk(1 D:)Avg. Disk sec/Write</Counter> <Counter>PhysicalDisk(1 D:)Disk Bytes/sec</Counter> <Counter>PhysicalDisk(1 D:)Disk Reads/sec</Counter> <Counter>PhysicalDisk(1 D:)Disk Writes/sec</Counter> <Counter>Process(sqlservr)\% Processor Time</Counter> <Counter>Process(sqlservr)Private Bytes</Counter> <Counter>Process(sqlservr)\% User Time</Counter> <Counter>Processor(_Total)\% Privileged Time</Counter> <Counter>Processor(_Total)\% Processor Time</Counter> <Counter>Processor(_Total)\% User Time</Counter> <Counter>SystemContext Switches/sec</Counter> <Counter>SystemProcessor Queue Length</Counter> <CounterDisplayName>MemoryAvailable MBytes</CounterDisplayName> <CounterDisplayName>MemoryCache Bytes</CounterDisplayName> <CounterDisplayName>MemoryCommit Limit</CounterDisplayName> <CounterDisplayName>MemoryCommitted Bytes</CounterDisplayName> <CounterDisplayName>MemoryFree System Page Table Entries</CounterDisplayName> <CounterDisplayName>MemoryPages Input/sec</CounterDisplayName> <CounterDisplayName>MemoryPages/sec</CounterDisplayName> <CounterDisplayName>MemorySystem Cache Resident Bytes</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Access MethodsFreeSpace Scans/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Access MethodsFull Scans/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Access MethodsTable Lock Escalations/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Access MethodsWorktables Created/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Access MethodsWorktables From Cache Ratio</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerBuffer cache hit ratio</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerCheckpoint pages/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerDatabase pages</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerFree list stalls/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerFree pages</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerLazy writes/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerPage life expectancy</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerPage lookups/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerPage reads/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerPage writes/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerReadahead pages/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerStolen pages</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerTarget pages</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Buffer ManagerTotal pages</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Databases(_Total)Transactions/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:General StatisticsConnection Reset/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:General StatisticsLogins/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:General StatisticsLogouts/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:General StatisticsProcesses blocked</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:General StatisticsUser Connections</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:LatchesAverage Latch Wait Time (ms)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:LatchesLatch Waits/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:LatchesTotal Latch Wait Time (ms)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Average Wait Time (ms)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Lock Requests/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Lock Timeouts (timeout > 0)/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Lock Timeouts/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Lock Wait Time (ms)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Lock Waits/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Locks(_Total)Number of Deadlocks/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerGranted Workspace Memory (KB)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerMaximum Workspace Memory (KB)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerMemory Grants Outstanding</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerMemory Grants Pending</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerStolen Server Memory (KB)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerTarget Server Memory (KB)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Memory ManagerTotal Server Memory (KB)</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:Plan Cache(_Total)Cache Hit Ratio</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsAuto-Param Attempts/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsBatch Requests/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsFailed Auto-Params/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsSafe Auto-Params/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsSQL Compilations/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsSQL Re-Compilations/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:SQL StatisticsUnsafe Auto-Params/sec</CounterDisplayName> <CounterDisplayName>MSSQL$PLAYER:TransactionsLongest Transaction Running Time</CounterDisplayName> <CounterDisplayName>Network Interface(*)Bytes Sent/sec</CounterDisplayName> <CounterDisplayName>Paging File(_Total)\% Usage Peak</CounterDisplayName> <CounterDisplayName>Paging File(_Total)\% Usage</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)\% Idle Time</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Avg. Disk Queue Length</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Avg. Disk sec/Read</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Avg. Disk sec/Transfer</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Avg. Disk sec/Write</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Disk Bytes/sec</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Disk Reads/sec</CounterDisplayName> <CounterDisplayName>PhysicalDisk(1 D:)Disk Writes/sec</CounterDisplayName> <CounterDisplayName>Process(sqlservr)\% Processor Time</CounterDisplayName> <CounterDisplayName>Process(sqlservr)Private Bytes</CounterDisplayName> <CounterDisplayName>Process(sqlservr)\% User Time</CounterDisplayName> <CounterDisplayName>Processor(_Total)\% Privileged Time</CounterDisplayName> <CounterDisplayName>Processor(_Total)\% Processor Time</CounterDisplayName> <CounterDisplayName>Processor(_Total)\% User Time</CounterDisplayName> <CounterDisplayName>SystemContext Switches/sec</CounterDisplayName> <CounterDisplayName>SystemProcessor Queue Length</CounterDisplayName> </PerformanceCounterDataCollector> <Schedule> <StartDate>5/20/2015</StartDate> <EndDate>11/14/2015</EndDate> <StartTime>9:30:00 AM</StartTime> <Days>127</Days> </Schedule> <DataManager> <Enabled>0</Enabled> <CheckBeforeRunning>0</CheckBeforeRunning> <MinFreeD 
小编还为您整理了以下内容，可能对您也有帮助：
Microsoft SQL Server Management Studio 18调试按钮哪去了?
这个比较坑爹,18.1版本测试也没有,还是回17.9吧,不知道18的版本什么时候能完善
18.0 (GA) 中已弃用和已删除的功能
已弃用/已删除的功能
T-SQL 调试程序
数据库关系图
SSMS 不再安装以下工具：
OSQL.EXE
DReplay.exe
SQLdiag.exe
SSBDiagnose.exe
bcp.exe
sqlcmd.exe
Configuration Manager 工具：
SQL Server 配置管理器和报表服务器配置管理器不再是 SSMS 安装程序的一部分。
DMF 标准策略
策略不再随 SSMS 安装。 它们将移动到 Git。 用户将能够参与并下载/安装它们，如果他们需要。
SSMS 命令行选项 - P 已删除
出于安全考虑，已删除命令行上指定明文密码的选项。
删除了生成脚本并发布到 Web 服务的功能
从 SSMS UI 中删除了此已弃用的功能。
在对象资源管理器中删除了“维护 > 旧版”节点。
无法再访问真正陈旧的“数据库维护计划”和“SQL Mail”节点。 新式“数据库邮件”和“维护计划”节点将继续按照常工作。
Microsoft SQL Server Management Studio 18调试按钮哪去了?
这个比较坑爹,18.1版本测试也没有,还是回17.9吧,不知道18的版本什么时候能完善
18.0 (GA) 中已弃用和已删除的功能
已弃用/已删除的功能
T-SQL 调试程序
数据库关系图
SSMS 不再安装以下工具：
OSQL.EXE
DReplay.exe
SQLdiag.exe
SSBDiagnose.exe
bcp.exe
sqlcmd.exe
Configuration Manager 工具：
SQL Server 配置管理器和报表服务器配置管理器不再是 SSMS 安装程序的一部分。
DMF 标准策略
策略不再随 SSMS 安装。 它们将移动到 Git。 用户将能够参与并下载/安装它们，如果他们需要。
SSMS 命令行选项 - P 已删除
出于安全考虑，已删除命令行上指定明文密码的选项。
删除了生成脚本并发布到 Web 服务的功能
从 SSMS UI 中删除了此已弃用的功能。
在对象资源管理器中删除了“维护 > 旧版”节点。
无法再访问真正陈旧的“数据库维护计划”和“SQL Mail”节点。 新式“数据库邮件”和“维护计划”节点将继续按照常工作。
数据库原理，麻烦帮忙解答下
1-5 CBAAB 6-10 BAADA
11-15 CCCAA
1.隔离服务
2.访问控制机制
3.防火墙
4.基于图形用户界面 (GUI) 的工具 和 命令行实用工具 dta.exe
5.CREATE TABLE ,CREATE VIEW, CREATE INDEX
6.DROP TABLE,ALTER TABLE