Skip to content

Instantly share code, notes, and snippets.

@potatoqualitee

potatoqualitee/mi.txt

Created July 14, 2018 09:41
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save potatoqualitee/f5e355ed1a4f26d9aef17dbc64eeb251 to your computer and use it in GitHub Desktop.
Save potatoqualitee/f5e355ed1a4f26d9aef17dbc64eeb251 to your computer and use it in GitHub Desktop.
Download ZIP
managed instance properties
Raw
mi.txt
AuditLevel : Failure
BackupDirectory : https://xyz.blob.core.windows.net/managedserverbac-GUID/
backup
BrowserServiceAccount :
BrowserStartMode : Disabled
BuildClrVersionString : v4.0.30319
BuildNumber : 700
ClusterName :
ClusterQuorumState : NotApplicable
ClusterQuorumType : NotApplicable
Collation : SQL_Latin1_General_CP1_CI_AS
CollationID : 872468488
ComparisonStyle : 196609
ComputerNamePhysicalNetBIOS :
DefaultFile : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\work\data\
DefaultLog : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\work\data\
Edition : SQL Azure
ErrorLogPath :
ErrorLogSizeKb : 102400
FilestreamLevel : Disabled
FilestreamShareName : FA3C3D8CF847
HadrManagerStatus : Failed
HostDistribution : Windows Server 2012 R2 Datacenter
HostPlatform : Windows
HostRelease : 6.3
HostServicePackLevel :
HostSku : 8
InstallDataDirectory : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\work
InstallSharedDirectory : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\SQL.Code.15.0.700.39-SDA3CL-e8936452.lk\sqlservr
InstanceName :
IsCaseSensitive : False
IsClustered : False
IsFullTextInstalled : True
IsHadrEnabled : False
IsPolyBaseInstalled : False
IsSingleUser : False
IsXTPSupported : True
Language : English (United States)
LoginMode : Mixed
MailProfile :
MasterDBLogPath : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\work\data
MasterDBPath : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\work\data
MaxPrecision : 38
NamedPipesEnabled : True
NetName :
NumberOfLogFiles : -1
OSVersion : 6.3 (9600)
PathSeparator : \
PerfMonMode : None
PhysicalMemory : 172032
PhysicalMemoryUsageInKB : 2634312
Platform : NT x64
Processors : 24
ProcessorUsage :
Product : Microsoft SQL Server
ProductLevel : CTP1.7
ResourceLastUpdateDateTime : 7/1/2018 6:05:23 PM
ResourceVersionString : 15.00.700
RootDirectory : C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\SQL.Code.15.0.700.39-SDA3CL-e8936452.lk\sqlservr
ServerType : Standalone
ServiceAccount :
ServiceInstanceId :
ServiceName :
ServiceStartMode : Auto
SqlCharSet : 1
SqlCharSetName : iso_1
SqlDomainGroup : BUILTIN\Administrators
SqlSortOrder : 52
SqlSortOrderName : nocase_iso
Status : Online
TapeLoadWaitTime : -1
TcpEnabled : True
VersionMajor : 15
VersionMinor : 0
VersionString : 12.0.2000.8
ExecutionManager : Microsoft.SqlServer.Management.Smo.ExecutionManager
Name : dbatoolsabc.xyz.database.windows.net
Version : 14.0.3015
EngineEdition : SqlManagedInstance
ResourceVersion : 15.0.700
BuildClrVersion : 4.0.30319
DefaultTextMode : True
Configuration : Microsoft.SqlServer.Management.Smo.Configuration
AffinityInfo : Microsoft.SqlServer.Management.Smo.AffinityInfo
ProxyAccount : [dbatoolsabc.xyz.database.windows.net]
Mail : [dbatoolsabc.xyz.database.windows.net]
Databases : {master, model, msdb, tempdb}
Endpoints : {DBM, Dedicated Admin Connection, TSQL Default TCP, TSQL Default VIA...}
Languages : {Arabic, British, čeština, Dansk...}
SystemMessages : {21, 101, 102, 103...}
UserDefinedMessages : {}
Credentials : {}
CryptographicProviders : {}
Logins : {##MS_PolicyEventProcessingLogin##, ##MS_PolicyTsqlExecutionLogin##, sa, sqladmin...}
Roles : {bulkadmin, dbcreator, DevOpsTenantMonitoringRORole, diskadmin...}
LinkedServers : {}
SystemDataTypes : {bigint, binary, bit, char...}
JobServer : [dbatoolsabc.xyz.database.windows.net]
ResourceGovernor : Microsoft.SqlServer.Management.Smo.ResourceGovernor
ServiceMasterKey : Microsoft.SqlServer.Management.Smo.ServiceMasterKey
SmartAdmin : Microsoft.SqlServer.Management.Smo.SmartAdmin
Settings : Microsoft.SqlServer.Management.Smo.Settings
Information : Microsoft.SqlServer.Management.Smo.Information
UserOptions : Microsoft.SqlServer.Management.Smo.UserOptions
BackupDevices : {}
FullTextService : [dbatoolsabc.xyz.database.windows.net]
ActiveDirectory :
Triggers : {}
Audits : {}
ServerAuditSpecifications : {}
AvailabilityGroups : {}
ConnectionContext : Data Source=dbatoolsabc.xyz.database.windows.net;User ID=myuser;Password=xyz;
MultipleActiveResultSets=False;Encrypt=False;TrustServerCertificate=False;Application
Name="dbatools PowerShell module - dbatools.io - custom connection"
Events : Microsoft.SqlServer.Management.Smo.ServerEvents
OleDbProviderSettings :
SupportedAvailabilityGroupClusterTypes : {External, None}
DefaultAvailabilityGroupClusterType : External
IsMemberOfWsfcCluster : False
IsConfigurationOnlyAvailabilityReplicaSupported : True
IsAvailabilityReplicaSeedingModeSupported : True
IsCrossPlatformAvailabilityGroupSupported : True
IsReadOnlyListWithLoadBalancingSupported : True
Urn : Server[@Name='dbatoolsabc.xyz.database.windows.net']
Properties : {Name=AuditLevel/Type=Microsoft.SqlServer.Management.Smo.AuditLevel/Writable=True/Value=Failure, Name=Back
upDirectory/Type=System.String/Writable=True/Value=https://wasdbc.blob.core.windows.net/man
abc-GUID/backup,
Name=BuildNumber/Type=System.Int32/Writable=False/Value=700, Name=DefaultFile/Type=System.String/Writable=
True/Value=C:\WFRoot\DB.3\Fabric\work\Applications\Worker.CL_App13\work\data\...}
DatabaseEngineType : Standalone
DatabaseEngineEdition : SqlManagedInstance
UserData :
State : Existing
IsDesignMode : False
DomainName : SMO
DomainInstanceName : dbatoolsabc.xyz.database.windows.net
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment