sqlserver健康检查报告模板全友家居有限公司
sqlserver数据库
配置及性能检查报告
作者: 杜琦
创建日期: 2015年10月20日
最后修改日期:
1. 文档控制
修改记录
日期
作者
版本
修改记录
2015-10-20
V1.0
分发者
公司
北京移动
...
全友家居有限公司
sqlserver数据库
配置及性能检查报告
作者: 杜琦
创建日期: 2015年10月20日
最后修改日期:
1. 文档控制
修改记录
日期
作者
版本
修改记录
2015-10-20
V1.0
分发者
公司
北京移动
审阅记录
姓名
职位
相关文档
2. 目录
1. 文档控制 ii
修改记录 ii
分发者 ii
审阅记录 ii
相关文档 ii
2. 目录 iii
3. 检查
4
概要 4
建议 4
4. 介绍 4
目标 4
检查方法 5
检查范围 5
5. 操作系统 5
系统版本 5
用户安全 6
系统性能 6
进程 6
文件系统 7
网络状态 8
系统日志 9
服务启动状态 10
系统的定时作业 10
病毒库更新 10
6. 数据库配置 11
数据库基本信息 11
数据库字符集 11
操作系统参数 12
数据库参数 12
数据库启动时间 14
数据库用户 14
数据库数据文件 15
事务日志 16
数据库进程 17
数据库完整性 18
数据库备份及维护计划 21
数据库服务及组件 21
数据库中运行的job 21
7. 数据库性能 23
数据库服务 23
数据库进程占用系统资源情况 23
3. 检查总结
概要
此次数据库检查包括以下内容:
主机相关配置:CPU、内存
操作系统配置:版本,补丁,病毒库
操作系统性能
数据库配置
文件系统可用空间
数据库版本
数据库参数
运行日志和跟踪文件
数据库备份
日志文件
数据文件
数据库的组件,补丁
数据库各组件运行状态
资源占用情况
数据库性能
建议
以下是本次检查发现的一些主要问题和建议的总结。
No.
问题描述
建议
建议解决时间
1
采用数据库镜像技术,备份了生产库,但系统库没有备份。登陆实例的用户信息和相关的一些代理设置没有备份。
备份系统库
近期
2
3
检查方面
评价/发现情况
主机配置
主机配置基本合理,满足当前系统的需要。
操作系统性能
内存正常,CPU资源正常。
数据库配置
数据库配置很好
数据库性能
数据库性能较好
4. 介绍
目标
数据库配置/性能检查是用来:
l 评价数据库当前配置及性能情况
l 分析数据库应用瓶颈和资源竞争情况
l 指出存在的问题,提出解决建议
检查方法
本次数据库性能检查的工具是:
l 操作系统工具和命令检查操作系统。
l SQL命令检查数据库配置,SQL命令在sqlserver工具查询分析器中运行。
检查范围
本报告提供的检查和建议主要针对以下方面:
1. 主机配置
2. 操作系统性能
3. 数据库配置
4. 数据库性能
本报告的提供的检查和建议不涉及:
l 具体的性能调整
l 应用程序的具体细节
5. 操作系统
这个部分详细阐述了系统的主要结构。winmsd.exe,systeminfo
系统版本
用户安全
正常
正常。
系统性能
监控系统性能是否有不稳定的情况发生。从16:30直到巡检结束19:20cpu与内存的最高峰。
正常。
文件系统
正常
网络状态
没有丢包,正常。
系统日志
日志查看,可以查看服务器的各种服务的运行是否报错,系统的运行是否报错,针对单独的错误,我们可以看是否存在问题,系统日志存在打印机驱动报错(可以忽略),系统日志正常。
查看应用程序日志,看是否有关键业务,及关键系统报错,如果是一些无关的应用报错可以忽略,应用程序在2015/10/22 10:10:35存在报错。Event ID:1479:The mirroring connection to "TCP://132.78.208.147:5022" has timed out for database "VDesktop6000" after 10 seconds without a response. Check the service and network connections.之后没有报错,应该问题处理完成。应用程序日志正常。
正常
服务启动状态
查看服务器的服务启动状态,确认服务器基本服务和应用服务已经启动。
正常。
系统的定时作业
没有任务计划在执行。
正常。
病毒库更新
无
正常。
6. 数据库配置
实例中生产库XenDesktop数据库配置了到147的镜像备份库,如果生产库发生问题可以使用镜像库进行切换恢复。
数据库基本信息
数据库的当前版本
select @@version
Microsoft SQL Server 2008 R2 (RTM) - 10.50.1600.1 (X64) Apr 2 2010 15:48:46 Copyright (c) Microsoft Corporation Standard Edition (64-bit) on Windows NT 6.1
(Build 7601:Service Pack 1 ) (Hypervisor)
数据库实例
select @@servername
BPMDB01
数据库字符集
sp_helpsort/数据库属性里面查看
Chinese-PRC, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive
操作系统参数
exec master..xp_msver
数据库参数
数据库启动参数
exec sp_configure/SELECT * FROM sys.configurations;
allow updates 0 1 0 0
backup compression default 0 1 0 0
clr enabled 0 1 0 0
cross db ownership chaining 0 1 0 0
default language 0 9999 0 0
filestream access level 0 2 0 0
max text repl size (B) -1 2147483647 65536 65536
nested triggers 0 1 1 1
remote access 0 1 1 1
remote admin connections 0 1 0 0
remote login timeout (s) 0 2147483647 20 20
remote proc trans 0 1 0 0
remote query timeout (s) 0 2147483647 600 600
server trigger recursion 0 1 1 1
show advanced options 0 1 0 0
user options 0 32767 0 0
正常
数据库启动时间
查看数据库运行时间
select convert(varchar(30),login_time,120) from master..sysprocesses where spid=1
2015-10-07 13:01:58
正常。
数据库用户
数据库用户的登录信息
exec sp_helplogins
生产数据库用户权限
应该使用的是sa用户作为生产用户。
正常。
数据库数据文件
系统文件系统
正常
数据库大小
exec sp_spaceused
master 2025.69 MB 2.86 MB
数据库状态
exec sp_helpdb
master 5.25 MB sa 1 Apr 8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=661, Collation=Chinese_PRC_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics 100
model 3.00 MB sa 3 Apr 8 2003 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=661, Collation=Chinese_PRC_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics 100
msdb 17.81 MB sa 4 Apr 2 2010 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=661, Collation=Chinese_PRC_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 100
tempdb 9.25 MB sa 2 Jan 4 2014 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=661, Collation=Chinese_PRC_CI_AS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics 100
XenDesktop 2025.69 MB sa 6 Apr 2 2013 Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=FULL, Version=661, Collation=Latin1_General_CI_AS_KS, SQLSortOrder=0, IsAutoCreateStatistics, IsAutoUpdateStatistics, IsFullTextEnabled 100
正常
事务日志
记录数据库操作信息,对于基于时间点恢复操作非常重要。
日志文件大小
dbcc sqlperf(logspace)
master 1.242188 55.66038 0
tempdb 1.242188 43.39622 0
model 0.7421875 50.52632 0
msdb 3.054688 36.70077 0
XenDesktop 2001.43 6.198499 0
数据文件及日志文件管理
数据文件管理采用自动增长的方式,无最大限制,自动增长比例是1m. 日志文件管理采用自动增长的方式,每次增长200M,最大值是d盘的空间。
正常
数据库进程
活动进程
exec sp_who 'active'
1 0 background sa
2 0 background sa
3 0 background sa
4 0 background sa
5 0 background sa
6 0 background sa
7 0 background sa
8 0 sleeping sa
9 0 background sa
10 0 background sa
11 0 background sa
12 0 background sa
13 0 sleeping sa
14 0 sleeping sa
15 0 sleeping sa
16 0 background sa
17 0 background sa
17 1 background sa
17 2 background sa
18 0 sleeping sa
19 0 background sa
20 0 background sa
21 0 background sa
22 0 sleeping sa
23 0 sleeping sa
24 0 background sa
25 0 sleeping sa
26 0 background sa
28 0 sleeping sa
30 0 background sa
31 0 sleeping sa
35 0 background sa
36 0 background sa
60 0 runnable BJ-ITA2DB BJXNH2DB02 0 VDesktop6000Bak SELECT 024 0 sleeping sa 0 master TASK MANAGER 0
25 0 background sa 0 master BRKR TASK 0
26 0 sleeping sa 0 master TASK MANAGER 0
27 0 sleeping sa 0 master TASK MANAGER 0
29 0 background sa 0 master BRKR TASK 0
30 0 sleeping sa 0 master TASK MANAGER 0
32 0 background sa 0 NULL DB MIRROR 0
33 0 sleeping sa 0 master TASK MANAGER 0
127 0 runnable sa BJXNH2DB010 VDesktop6000Bak SELECT
锁资源使用情况
exec sp_lock
51 6 0 0 DB S GRANT
52 6 0 0 DB S GRANT
53 6 0 0 DB S GRANT
54 6 0 0 DB S GRANT
55 6 0 0 DB S GRANT
56 6 0 0 DB S GRANT
59 6 0 0 DB S GRANT
60 6 0 0 DB S GRANT
60 1 1131151075 0 TAB IS GRANT
61 6 0 0 DB S GRANT
62 6 0 0 DB S GRANT
63 6 0 0 DB S GRANT
64 6 0 0 DB S GRANT
65 6 0 0 DB S GRANT
66 6 0 0 DB S GRANT
67 6 0 0 DB S GRANT
68 6 0 0 DB S GRANT
71 6 0 0 DB S GRANT
73 6 0 0 DB S GRANT
74 6 0 0 DB S GRANT
86 4 0 0 DB S GRANT
105 4 0 0 DB S GRANT
正常
建议:无。
数据库完整性
检查数据库中所有的对象分配和机构完整性是否存在错误,如果有报错需要及时排查处理
dbcc checkdb
dbcc checkdb
DBCC results for 'XenDesktop'.
Service Broker Msg 9675, State 1: Message Types analyzed: 14.
Service Broker Msg 9676, State 1: Service Contracts analyzed: 6.
Service Broker Msg 9667, State 1: Services analyzed: 3.
Service Broker Msg 9668, State 1: Service Queues analyzed: 3.
Service Broker Msg 9669, State 1: Conversation Endpoints analyzed: 0.
Service Broker Msg 9674, State 1: Conversation Groups analyzed: 0.
Service Broker Msg 9670, State 1: Remote Service Bindings analyzed: 0.
Service Broker Msg 9605, State 1: Conversation Priorities analyzed: 0.
DBCC results for 'sys.sysrscols'.
There are 1861 rows in 17 pages for object "sys.sysrscols".
DBCC results for 'sys.sysrowsets'.
There are 381 rows in 4 pages for object "sys.sysrowsets".
DBCC results for 'sys.sysallocunits'.
There are 454 rows in 5 pages for object "sys.sysallocunits".
DBCC results for 'sys.sysfiles1'.
There are 2 rows in 1 pages for object "sys.sysfiles1".
DBCC results for 'sys.syspriorities'.
There are 0 rows in 0 pages for object "sys.syspriorities".
DBCC results for 'sys.sysfgfrag'.
There are 2 rows in 1 pages for object "sys.sysfgfrag".
DBCC results for 'sys.sysphfg'.
There are 1 rows in 1 pages for object "sys.sysphfg".
DBCC results for 'sys.sysprufiles'.
There are 2 rows in 1 pages for object "sys.sysprufiles".
DBCC results for 'sys.sysftinds'.
There are 0 rows in 0 pages for object "sys.sysftinds".
DBCC results for 'sys.sysowners'.
There are 24 rows in 1 pages for object "sys.sysowners".
DBCC results for 'sys.sysprivs'.
There are 843 rows in 5 pages for object "sys.sysprivs".
DBCC results for 'sys.sysschobjs'.
There are 1760 rows in 31 pages for object "sys.sysschobjs".
DBCC results for 'sys.syscolpars'.
There are 3630 rows in 63 pages for object "sys.syscolpars".
DBCC results for 'sys.sysnsobjs'.
There are 1 rows in 1 pages for object "sys.sysnsobjs".
DBCC results for 'sys.syscerts'.
There are 0 rows in 0 pages for object "sys.syscerts".
DBCC results for 'sys.sysxprops'.
There are 0 rows in 0 pages for object "sys.sysxprops".
DBCC results for 'sys.sysscalartypes'.
There are 296 rows in 3 pages for object "sys.sysscalartypes".
DBCC results for 'sys.systypedsubobjs'.
There are 0 rows in 0 pages for object "sys.systypedsubobjs".
DBCC results for 'sys.sysidxstats'.
There are 590 rows in 12 pages for object "sys.sysidxstats".
DBCC results for 'sys.sysiscols'.
There are 840 rows in 6 pages for object "sys.sysiscols".
DBCC results for 'sys.sysbinobjs'.
There are 23 rows in 1 pages for object "sys.sysbinobjs".
DBCC results for 'sys.sysaudacts'.
There are 0 rows in 0 pages for object "sys.sysaudacts".
DBCC results for 'sys.sysobjvalues'.
There are 1826 rows in 410 pages for object "sys.sysobjvalues".
DBCC results for 'sys.sysclsobjs'.
There are 23 rows in 1 pages for object "sys.sysclsobjs".
DBCC results for 'sys.sysrowsetrefs'.
There are 0 rows in 0 pages for object "sys.sysrowsetrefs".
DBCC results for 'sys.sysremsvcbinds'.
There are 0 rows in 0 pages for object "sys.sysremsvcbinds".
DBCC results for 'sys.sysxmitqueue'.
There are 0 rows in 0 pages for object "sys.sysxmitqueue".
DBCC results for 'sys.sysrts'.
There are 1 rows in 1 pages for object "sys.sysrts".
DBCC results for 'sys.sysconvgroup'.
There are 0 rows in 0 pages for object "sys.sysconvgroup".
DBCC results for 'sys.sysdesend'.
There are 0 rows in 0 pages for object "sys.sysdesend".
DBCC results for 'sys.sysdercv'.
There are 0 rows in 0 pages for object "sys.sysdercv".
DBCC results for 'sys.syssingleobjrefs'.
There are 565 rows in 4 pages for object "sys.syssingleobjrefs".
DBCC results for 'sys.sysmultiobjrefs'.
There are 5944 rows in 40 pages for object "sys.sysmultiobjrefs".
DBCC results for 'sys.sysguidrefs'.
There are 0 rows in 0 pages for object "sys.sysguidrefs".
DBCC results for 'sys.syscompfragments'.
There are 0 rows in 0 pages for object "sys.syscompfragments".
DBCC results for 'sys.sysftstops'.
There are 0 rows in 0 pages for object "sys.sysftstops".
DBCC results for 'sys.sysqnames'.
There are 97 rows in 1 pages for object "sys.sysqnames".
DBCC results for 'sys.sysxmlcomponent'.
There are 99 rows in 1 pages for object "sys.sysxmlcomponent".
DBCC results for 'sys.sysxmlfacet'.
There are 112 rows in 1 pages for object "sys.sysxmlfacet".
DBCC results for 'sys.sysxmlplacement'.
There are 18 rows in 1 pages for object "sys.sysxmlplacement".
DBCC results for 'sys.sysobjkeycrypts'.
There are 0 rows in 0 pages for object "sys.sysobjkeycrypts".
DBCC results for 'sys.sysasymkeys'.
There are 0 rows in 0 pages for object "sys.sysasymkeys".
DBCC results for 'sys.syssqlguides'.
There are 0 rows in 0 pages for object "sys.syssqlguides".
DBCC results for 'sys.sysbinsubobjs'.
There are 3 rows in 1 pages for object "sys.sysbinsubobjs".
DBCC results for 'sys.syssoftobjrefs'.
There are 3304 rows in 56 pages for object "sys.syssoftobjrefs".
DBCC results for 'HostingUnitServiceSchema.HypervisorConnectionAddress'.
There are 0 rows in 0 pages for object "HostingUnitServiceSchema.HypervisorConnectionAddress".
DBCC results for 'ConfigurationSchema.SchemaFeatures'.
There are 1 rows in 1 pages for object "ConfigurationSchema.SchemaFeatures".
DBCC results for 'ConfigurationSchema.UpdatePackages'.
There are 0 rows in 0 pages for object "ConfigurationSchema.UpdatePackages".
DBCC results for 'chb_Config.EPAccountFilterEntries'.
There are 0 rows in 0 pages for object "chb_Config.EPAccountFilterEntries".
DBCC results for 'HostingUnitServiceSchema.HypervisorConnectionMetadata'.
There are 0 rows in 0 pages for object "HostingUnitServiceSchema.HypervisorConnectionMetadata".
DBCC results for 'chb_State.HypervisorAlerts'.
There are 0 rows in 0 pages for object "chb_State.HypervisorAlerts".
DBCC results for 'ConfigurationSchema.SchemaChangeScripts'.
There are 0 rows in 0 pages for object "ConfigurationSchema.SchemaChangeScripts".
DBCC results for 'chb_Config.BrowserNames'.
There are 994 rows in 15 pages for object "chb_Config.BrowserNames".
DBCC results for 'HostingUnitServiceSchema.HostingUnit'.
There are 0 rows in 0 pages for object "HostingUnitServiceSchema.HostingUnit".
DBCC results for 'chb_Config.ASPAccountFilterEntries'.
There are 600 rows in 2 pages for object "chb_Config.ASPAccountFilterEntries".
DBCC results for 'ConfigurationSchema.Workflow'.
There are 0 rows in 0 pages for object "ConfigurationSchema.Workflow".
DBCC results for 'MachinePersonalitySchema.VMInfo'.
There are 0 rows in 0 pages for object "MachinePersonalitySchema.VMInfo".
DBCC results for 'chb_State.LaunchContexts'.
There are 242 rows in 20 pages for object "chb_State.LaunchContexts".
DBCC results for 'ConfigurationSchema.WorkflowMetadata'.
There are 0 rows in 0 pages for object "ConfigurationSchema.WorkflowMetadata".
DBCC results for 'HostingUnitServiceSchema.HostingUnitMetadata'.
There are 0 rows in 0 pages for object "HostingUnitServiceSchema.HostingUnitMetadata".
DBCC results for 'chb_Config.WorkerIndex'.
There are 1148 rows in 9 pages for object "chb_Config.WorkerIndex".
DBCC results for 'ADIdentitySchema.IdentityPool'.
There are 0 rows in 0 pages for object "ADIdentitySchema.IdentityPool".
DBCC results for 'MachinePersonalitySchema.VMInfoPendingDiskDeletes'.
There are 0 rows in 0 pages for object "MachinePersonalitySchema.VMInfoPendingDiskDeletes".
DBCC results for 'DesktopUpdateManagerSchema.ProvisioningScheme'.
There are 0 rows in 0 pages for object "DesktopUpdateManagerSchema.ProvisioningScheme".
DBCC results for 'ConfigurationSchema.WorkflowContext'.
There are 0 rows in 0 pages for object "ConfigurationSchema.WorkflowContext".
DBCC results for 'chb_Config.Admins'.
There are 2 rows in 1 pages for object "chb_Config.Admins".
DBCC results for 'chb_State.ConnectionLog'.
There are 15321 rows in 105 pages for object "chb_State.ConnectionLog".
DBCC results for 'chb_Config.Workers'.
There are 995 rows in 7 pages for object "chb_Config.Workers".
DBCC results for 'ADIdentitySchema.Identity'.
There are 0 rows in 0 pages for object "ADIdentitySchema.Identity".
DBCC results for 'HostingUnitServiceSchema.HostingUnitStorage'.
There are 0 rows in 0 pages for object "HostingUnitServiceSchema.HostingUnitStorage".
DBCC results for 'DesktopUpdateManagerSchema.ProvisioningSchemeMetadata'.
There are 0 rows in 0 pages for object "DesktopUpdateManagerSchema.ProvisioningSchemeMetadata".
DBCC results for 'ADIdentitySchema.IdentityCollection'.
There are 0 rows in 0 pages for object "ADIdentitySchema.IdentityCollection".
DBCC results for 'ConfigurationSchema.ConfigServiceLocation'.
There are 1 rows in 1 pages for object "ConfigurationSchema.ConfigServiceLocation".
DBCC results for 'chb_Config.AdminRoles'.
There are 4 rows in 1 pages for object "chb_Config.AdminRoles".
DBCC results for 'HostingUnitServiceSchema.HostingUnitSnapshotCreationProgress'.
There are 0 rows in 0 pages for object "HostingUnitServiceSchema.HostingUnitSnapshotCreationProgress".
DBCC results for 'ConfigurationSchema.Services'.
There are 2 rows in 1 pages for object "ConfigurationSchema.Services".
DBCC results for 'DesktopUpdateManagerSchema.ProvisioningSchemeVMImageHistory'.
There are 0 rows in 0 pages for object "DesktopUpdateManagerSchema.ProvisioningSchemeVMImageHistory".
DBCC results for 'ADIdentitySchema.DomainControllerInfo'.
There are 0 rows in 0 pages for object "ADIdentitySchema.DomainControllerInfo".
DBCC results for 'chb_Config.AdminOperations'.
There are 165 rows in 2 pages for object "chb_Config.AdminOperations".
DBCC results for 'DesktopUpdateManagerSchema.ProvisioningSchemeVMImageLocation'.
There are 0 rows in 0 pages for object "DesktopUpdateManagerSchema.ProvisioningSchemeVMImageLocation".
DBCC results for 'chb_Config.Desktops'.
There are 995 rows in 6 pages for object "chb_Config.Desktops".
DBCC results for 'DesktopUpdateManagerSchema.ProvisioningSchemeControllerAddress'.
There are 0 rows in 0 pages for object "DesktopUpdateManagerSchema.ProvisioningSchemeControllerAddress".
DBCC results for 'chb_Config.AdminRoleOperations'.
There are 204 rows in 1 pages for object "chb_Config.AdminRoleOperations".
DBCC results for 'DesktopUpdateManagerSchema.ProvisionedVirtualMachine'.
There are 0 rows in 0 pages for object "DesktopUpdateManagerSchema.ProvisionedVirtualMachine".
DBCC results for 'chb_Config.AdminScopeRoleGrants'.
There are 0 rows in 0 pages for object "chb_Config.AdminScopeRoleGrants".
DBCC results for 'chb_State.Controllers'.
There are 2 rows in 1 pages for object "chb_State.Controllers".
DBCC results for 'chb_State.SiteServices'.
There are 10 rows in 1 pages for object "chb_State.SiteServices".
DBCC results for 'ConfigurationSchema.GlobalMetadata'.
There are 0 rows in 0 pages for object "ConfigurationSchema.GlobalMetadata".
DBCC results for 'chb_Config.SummaryStateLookup'.
There are 30 rows in 1 pages for object "chb_Config.SummaryStateLookup".
DBCC results for 'ConfigurationSchema.ServiceGroup'.
There are 7 rows in 1 pages for object "ConfigurationSchema.ServiceGroup".
DBCC results for 'chb_State.WorkerNames'.
There are 1148 rows in 21 pages for object "chb_State.WorkerNames".
DBCC results for 'chb_Config.DesktopTags'.
There are 0 rows in 1 pages for object "chb_Config.DesktopTags".
DBCC results for 'ConfigurationSchema.ServiceGroupMetadata'.
There are 0 rows in 0 pages for object "ConfigurationSchema.ServiceGroupMetadata".
DBCC results for 'chb_State.RegisteredServiceHandlers'.
There are 22 rows in 1 pages for object "chb_State.RegisteredServiceHandlers".
DBCC results for 'chb_State.AccountNames'.
There are 1051 rows in 27 pages for object "chb_State.AccountNames".
DBCC results for 'chb_Config.WorkerAccountAssignments'.
There are 994 rows in 3 pages for object "chb_Config.WorkerAccountAssignments".
DBCC results for 'ConfigurationSchema.ServiceInstance'.
There are 13 rows in 1 pages for object "ConfigurationSchema.ServiceInstance".
DBCC results for 'chb_State.WorkerRegistrations'.
There are 575 rows in 53 pages for object "chb_State.WorkerRegistrations".
DBCC results for 'ConfigurationSchema.ServiceInstanceMetadata'.
There are 0 rows in 0 pages for object "ConfigurationSchema.ServiceInstanceMetadata".
DBCC results for 'chb_Config.ApplicationFolders'.
There are 1 rows in 1 pages for object "chb_Config.ApplicationFolders".
DBCC results for 'chb_State.WorkerServiceEndpoints'.
There are 575 rows in 156 pages for object "chb_State.WorkerServiceEndpoints".
DBCC results for 'chb_State.PowerManagementActions'.
There are 0 rows in 0 pages for object "chb_State.PowerManagementActions".
DBCC results for 'chb_Config.Applications'.
There are 0 rows in 0 pages for object "chb_Config.Applications".
DBCC results for 'chb_State.PowerPolicyActions'.
There are 0 rows in 0 pages for object "chb_State.PowerPolicyActions".
DBCC results for 'chb_Config.HypervisorConnections'.
There are 0 rows in 0 pages for object "chb_Config.HypervisorConnections".
DBCC results for 'chb_State.Workers'.
There are 995 rows in 33 pages for object "chb_State.Workers".
DBCC results for 'chb_Config.ApplicationTags'.
There are 0 rows in 0 pages for object "chb_Config.ApplicationTags".
DBCC results for 'chb_Config.Icons'.
There are 2 rows in 1 pages for object "chb_Config.Icons".
DBCC results for 'chb_Config.Catalogs'.
There are 2 rows in 1 pages for object "chb_Config.Catalogs".
DBCC results for 'chb_Config.ImportedFTAs'.
There are 0 rows in 0 pages for object "chb_Config.ImportedFTAs".
DBCC results for 'chb_Config.Site'.
There are 1 rows in 1 pages for object "chb_Config.Site".
DBCC results for 'chb_Config.ConfiguredFTAs'.
There are 0 rows in 0 pages for object "chb_Config.ConfiguredFTAs".
DBCC results for 'chb_Config.DumSchemes'.
There are 0 rows in 0 pages for object "chb_Config.DumSchemes".
本文档为【sqlserver健康检查报告模板】,请使用软件OFFICE或WPS软件打开。作品中的文字与图均可以修改和编辑,
图片更改请在作品中右键图片并更换,文字修改请直接点击文字进行修改,也可以新增和删除文档中的内容。
[版权声明] 本站所有资料为用户分享产生,若发现您的权利被侵害,请联系客服邮件isharekefu@iask.cn,我们尽快处理。
本作品所展示的图片、画像、字体、音乐的版权可能需版权方额外授权,请谨慎使用。
网站提供的党政主题相关内容(国旗、国徽、党徽..)目的在于配合国家政策宣传,仅限个人学习分享使用,禁止用于任何广告和商用目的。