DatabaseTableApplicationCreatedLinks
mastersysservers  14 déc. 14Joins Schema ColumnUsage Queries Writes Propagation Dependencies

1     create table sysservers(-- 0 Rows, Data: 0 B, Index: 0 B
2         srvid smallint not null,
3         srvstatus smallint not null,
4         srvname varchar(30) not null,
5         srvnetname varchar(255) not null,
6         srvclass smallint null,
7         srvsecmech varchar(30) null,
8         srvcost smallint null,
9         srvstatus2 uint null,
10        srvprincipal varchar(255) null
11    )
12    
13    
14    create unique clustered index csysservers on sysservers(-- 2 KB refcount: 60
15        srvid
16    )
17    create unique index ncsysservers on sysservers(-- 2 KB refcount: 65
18        srvname
19    )
20    
21    alter table sysservers lock datarows
22    
23    Grant Select on sysservers to public
24    
JOINS
From ColumnsTo TableTo ColumnsCntCstrStrength
[srvid]master..sysremotelogins[remoteserverid]14 Rev FK
[srvid]master..sysattributes[object_info1]5 Rev FK
[srvnetname]master..spt_values[name]2 Simple Join
[srvname]master..spt_values[name]2 Rev FK
[srvid]sybsystemdb..syscoordinations[participant]1 Rev FK

Estimated Index Usage
sysservers.ncsysservers unique(srvname)65
sysservers.csysservers unique clustered(srvid)60

ALIASES USED for master..sysservers
NO_ALIASssysservers
644121

SCHEMA

COLUMN USAGE
srvidsp_addexternlogin  sp_addobjectdef  sp_addremotelogin  sp_addserver  sp_checknames  sp_dropexternlogin  sp_dropremotelogin  sp_dropserver  sp_hadr_admin  sp_helpexternlogin  sp_helpremotelogin  sp_helpserver  sp_remoteoption  sp_serveroption 
srvstatussp_addserver  sp_hadr_admin  sp_helpserver  sp_serveroption 
srvnamesp_addexternlogin  sp_addobjectdef  sp_addremotelogin  sp_addserver  sp_autoconnect  sp_checknames  sp_checkreswords  sp_defaultloc  sp_downgrade  sp_dropexternlogin  sp_dropremotelogin  sp_dropserver  sp_dumpoptimize  sp_extengine  sp_hadr_admin  sp_hadr_status  sp_hadr_update  sp_hadrvrfyargs  sp_helpexternlogin  sp_helpremotelogin  sp_helpserver  sp_remoteoption  sp_serveroption  sp_volchanged 
srvnetnamesp_addserver  sp_checknames  sp_checkreswords  sp_downgrade  sp_dropserver  sp_dumpoptimize  sp_extengine  sp_hadr_admin  sp_helpserver  sp_serveroption  sp_volchanged 
srvclasssp_addexternlogin  sp_addobjectdef  sp_addremotelogin  sp_addserver  sp_dropexternlogin  sp_dropremotelogin  sp_dropserver  sp_extengine  sp_hadr_admin  sp_hadr_status  sp_hadr_update  sp_hadrvrfyargs  sp_helpserver  sp_serveroption 
srvsecmechsp_helpserver  sp_serveroption 
srvcostsp_addserver  sp_hadr_admin  sp_helpserver  sp_serveroption 
srvstatus2sp_addserver  sp_dropserver  sp_dumpoptimize  sp_hadr_admin  sp_helpserver  sp_serveroption 
srvprincipalsp_helpserver  sp_serveroption 

QUERIES
Joined With Links
master..spt_values sybsystemprocs..sp_checkreswords:382
sybsystemprocs..sp_checkreswords:394
sybsystemprocs..sp_checkreswords:386
sybsystemprocs..sp_checkreswords:398
master..sysremotelogins master..spt_values sybsystemprocs..sp_helpremotelogin:142
master..sysmessages master..sysremotelogins master..spt_values sybsystemprocs..sp_helpremotelogin:161
master..sysattributes master..syssrvroles sybsystemprocs..sp_helpexternlogin:160
master..sysattributes sybsystemprocs..sp_helpexternlogin:131
sybsystemprocs..sp_dropserver:354
sybsystemprocs..sp_dropserver:398
master..sysattributes master..syslogins sybsystemprocs..sp_helpexternlogin:117
master..sysremotelogins sybsystemprocs..sp_dropremotelogin:198
sybsystemprocs..sp_helpremotelogin:100
sybsystemprocs..sp_addremotelogin:299
sybsystemprocs..sp_helpremotelogin:46
sybsystemprocs..sp_addremotelogin:324
sybsystemprocs..sp_dropserver:338
sybsystemprocs..sp_remoteoption:357
sybsystemprocs..sp_remoteoption:197
sybsystemprocs..sp_addremotelogin:370
sybsystemprocs..sp_remoteoption:382
sybsystemprocs..sp_dropserver:377
sybsystemprocs..sp_addremotelogin:228
sybsystemdb..syscoordinations sybsystemprocs..sp_dropserver:321

COLUMN WRITES detailed
ColumnWritten From
srvid    sysattributes.object   syslogins.suid   sysattributes.int_value   sysservers.srvid   spt_values.number   sysdatabases.dbid   sp_optbitmap.@?   sp_setsuspect_threshold.@dbname   sp_dbrecovery_order.@rec_order   sp_hadr_admin.@?   sp_config_dump.@notify   sp_addserver.@?   sp_config_dump.@retry   sp_maplogin.@?   sp_setsuspect_threshold.@?   sp_config_dump.@init   sp_memlog.@?   sp_shmdumpconfig.@value   sp_shmdumpconfig.@maxdumps   sp_displaylevel.@loginame   sp_setsuspect_error.@errornum   sp_addexternlogin.@loginame   sp_dbrecovery_order.@?   sp_version.@?   sp_modifylogin.@?   sp_multdb_bind.@?   sp_shmdumpconfig_config.@?   sp_config_dump.@backup_srv_name   sp_addlogin.@minpwdlen   sp_downgrade_dump_config.@?   sp_config_dump.@stripe_dir   sp_helpsort.@?   sp_config_dump.@num_stripes   sp_hadr_update.@genno   sp_setsuspect_granularity.@?   sp_rjs_register.@host_port   sp_shmdumpconfig.@?   sp_addlogin.@maxfailedlogins   sp_config_dump.@compression   sp_config_dump.@verify   sp_unbindexeclass.@?   sp_displaylevel.@?   sp_config_dump.@blocksize   sp_gen_login_id.@?   sp_config_dump.@?   sp_multdb_creategroup.@?   sp_setsuspect_granularity.@dbname   sp_dbrecovery_order.@dbname   sp_fix_dtm_ha_roles.@?   sp_bindexeclass.@?   sp_addlogin.@passwdexp   sp_config_dump.@ext_api   sp_config_dump.@retaindays   sp_addexternlogin.@?   sp_optgoal.@?   sp_modifylogin.@value  
srvstatus    sysservers.srvstatus   spt_values.number   sp_hadr_admin.@?   sp_helpsort.@?  
srvname    sp_hadr_update.@?   sp_addserver.@lname   sp_hadr_admin.@?   sp_hadr_admin.@arg1  
srvnetname    sp_hadr_update.@?   sp_addserver.@lname   sp_addserver.@pname   sp_hadr_admin.@arg2   sp_hadr_admin.@arg1  
srvclass    spt_values.number   sp_addserver.@?   sp_helpsort.@?   sp_hadr_admin.@?  
srvsecmech    sp_serveroption.@optvalue  
srvcost    sp_serveroption.@optvalue   sp_addserver.@?   sp_serveroption.@?   sp_hadr_admin.@?  
srvstatus2    syslogins.suid   sysservers.srvstatus2   spt_values.number   sp_serveroption.@?   sp_helpsort.@?   sp_hadr_admin.@?   sp_addserver.@?   sp_gen_login_id.@?  
srvprincipal    sp_serveroption.@optvalue  

DATA PROPAGATION detailed
ColumnWritten To
srvidsysattributes.object   °.object_info1   °.object_info3   °.char_value   sysremotelogins.remoteserverid   sysservers.srvid   sysattributes.object_info1   °.object_info3   °.int_value   °.char_value  
sp_dropdevice_rset_001.device sp_checknames_rset_006.remoteserverid sp_checknames_rset_007.srvid sp_checknames_rset_008.srvid sp_dbrecovery_order_rset_001.Database Name °.Database id sp_displayroles_rset_001.Role Name sp_displayroles_rset_002.Role Name °.Grantee sp_displayroles_rset_003.Role Name
sp_displayroles_rset_004.Role Name sp_dropdevice_rset_001.device sp_forceonline_object_rset_001.Object °.status sp_forceonline_object_rset_002.Object °.status sp_forceonline_page_rset_001.status sp_forceonline_page_rset_002.status sp_listsuspect_object_rset_001.Object °.Access
sp_listsuspect_page_rset_001.Object °.Access sp_makesuspect_obj_rset_001.Obj °.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_002.Obj
°.Indid °.LogType °.PageType °.ErrType °.Delay °.TotalNum sp_makesuspect_obj_rset_003.Obj °.Indid °.LogType °.PageType
°.ErrType °.Delay °.TotalNum sp_memlog_rset_001.dumps_per_file sp_passwordpolicy_rset_001.message sp_passwordpolicy_rset_002.value sp_passwordpolicy_rset_003.value sp_passwordpolicy_rset_004.Policy_option sp_rjs_retrieve_rset_001.host_name sp_setsuspect_granularity_rset_001.Online mode
sp_ssladmin_rset_001.certificate_path sp_ssladmin_rset_002.Cipher Suite Name °.Preference
srvnamesp_checknames_rset_006.remoteusername sp_checknames_rset_007.srvname sp_checkreswords_rset_002.Table
srvnetnamesp_checkreswords_rset_001.Owner
srvstatussysservers.srvstatus  
srvstatus2sysservers.srvstatus2  

DEPENDENCIES
READERS AND WRITERS
read by proc sybsystemprocs..sp_remoteoption  
read by proc sybsystemprocs..sp_downgrade  
read by proc sybsystemprocs..sp_autoconnect  
read by proc sybsystemprocs..sp_helpremotelogin  
read by proc sybsystemprocs..sp_checknames  
read by proc sybsystemprocs..sp_addremotelogin  
read by proc sybsystemprocs..sp_extengine  
read by proc sybsystemprocs..sp_hadrvrfyargs  
   called by proc sybsystemprocs..sp_hadr_admin  
      called by proc sybsystemprocs..sp_hadr_update  
read by proc sybsystemprocs..sp_checkreswords  
read by proc sybsystemprocs..sp_helpserver  
read_written by proc sybsystemprocs..sp_hadr_admin  
read_written by proc sybsystemprocs..sp_addserver  
read by proc sybsystemprocs..sp_addexternlogin  
read by proc sybsystemprocs..sp_volchanged  
read by proc sybsystemprocs..sp_helpexternlogin  
read by proc sybsystemprocs..sp_dropremotelogin  
read by proc sybsystemprocs..sp_addobjectdef  
   called by proc sybsystemprocs..sp_addtabledef  
read by proc sybsystemprocs..sp_defaultloc  
read by proc sybsystemprocs..sp_dropexternlogin  
read by proc sybsystemprocs..sp_hadr_status  
read_written by proc sybsystemprocs..sp_hadr_update  
read_written by proc sybsystemprocs..sp_dropserver  
   called by proc sybsystemprocs..sp_hadr_admin  
read by proc sybsystemprocs..sp_dumpoptimize  
read_written by proc sybsystemprocs..sp_serveroption