澳门金沙vip 2

澳门金沙vipAzure SQL Virtual Machine报Login failed for user ‘NT Service\SqlIaaSExtension’. Reason: Could not find a login matching the name provided

在一台位于HK的Azure
SQL Virtual
Machine上修改排序规则,重建系统数据库后,监控发现大量的登录失败告警生成,如下所示:

最近遇到一起关于”I/O is frozen on database xxx. No user action is
required. However, if I/O is not resumed promptly, you could cancel the
backup.”的案例。

 vRealize Automation
提供了一个安全门户,在该门户中,授权管理员、开发人员或业务用户可以请求新的
IT 服务并管理特定云和 IT 资源,同时确保业务策略合规性。IT
服务(包括基础架构、应用程序、桌面及许多其他服务)请求通过一个通用服务目录处理,以便提供一致的用户体验。

 

出现问题的时候,我去执行一个非常简单的SQL语句,执行时间非常长,检查没有阻塞。正常情况下,应该是几秒就OK。后面检查错误日志,发现有大量这类消息.而这个点,我们没有备份数据库的作业。后面搜索,了解了一下这个消息出现的原因:

通过使用 vRealize Automation
监控资源和容量使用情况,您可以加强成本控制。为了促进成本控制管理,您可以将
vRealize Business Advanced or Enterprise Edition与 vRealize Automation
实例集成,以便公开云和虚拟机资源的成本,帮助您更有效地管理容量、成本和效率。

    DESCRIPTION:  Login failed for
user ‘NT Service\SqlIaaSExtension’. Reason: Could not find a login
matching the name provided. [CLIENT: <local machine>]

 

下图为VRA的组件架构图:

 

澳门金沙vip 1

澳门金沙vip 2

 

 

 vRealize Automation Appliance 是包含 vRealize Automation
服务器的预配置虚拟设备。vRealize Automation 作为开放式虚拟机格式 (OVF)
模板提供。系统管理员可将该虚拟设备部署至现有的虚拟化基础架构中。该服务器包括
vRealize Automation Appliance
产品控制台,可为云服务的自助置备和管理、编写、管理以及管治提供单一门户。

从上述告警信息,我们得到下面一些信息:

参考网上资料,关于“I/O is frozen on database xxx. No user action is
required”的介绍如下:

vPostgres Database:

 

 

在部署虚拟设备的过程中,系统将在第一个 vRealize Automation Appliance
上自动创建 PostgreSQL 设备数据库。要创建高可用性环境,可以在另一个
vRealize Automation Appliance 上安装副本数据库。

   
1:这个账号是从本机登录SQL Server数据库。

This message is logged in the Error Log whenever any backup service
making use of SQL Server Virtual Device Interface (VDI) tries to backup
the database (with snapshot)/drive on which the database files reside.
Microsoft Backup (ntbackup.exe), Volume Shadow Copy (VSS), Data
Protection Manager (DPM) and third party tools like Symantec Business
Continuance Volume (BCV) are some of the application which cause this
message to logged in the SQL Server Error Log.

 IaaS服务器组建简介

   
2:这个Login不存在了。

What does these messages mean? Let me explain this with an example.
Suppose ntbackup.exe is configured to take the backup of D drive. This
drive has some data files related to few databases on SQL Server. Since
the data files are in use by SQL Server, if these files are copied as it
is the files in the backup will be inconsistent. To ensure that the
database files are consistent in the drive backup, this application
internally issues a BACKUP DATABASE [databasename] WITH SNAPSHOT
command against the database. When this command is issued, the I/O for
that database is frozen and the backup application is informed to
proceed with its operation. Until the BACKUP WITH SNAPSHOT command is
complete, the I/O for the database is frozen and the I/O is resumed once
it completes. The corresponding messages are logged in the SQL Server
Error Log.

Manager Service:

 

 

vRealize Automation 模型可促进与外部系统和数据库的集成。它们实施
Distributed Execution Manager (DEM) 使用的业务逻辑。