配置Xevent以存储在Azure存储上 [英] Configure Xevent to store on Azure Storage

问题描述

大家好.我将测试将扩展事件保存在Azure存储帐户中.我从网站上搜索，这涉及很多步骤.

Hi All. I am going to test to save extended event on the azure storage account. I search from the website and that's involve number of steps.

我也有我的azure数据库存储帐户.但是不知道如何配置它.当我配置它时，启动事件时会出错.

I also have my azure db, storage account. But don't know how to config it . While I config it, there is error when starting the event.

我想知道我创建证书的步骤是否错误.

I am wondering if my steps creating the credential is wrong.

创建数据库分段凭证[https://myazurestorage10.blob.core.windows.net/extendedevent]
WITH IDENTITY ='Shared Access Signature'，SECRET ='sv = 2017-07-29& sr = c& si = mypolicy& sig =％2FB18QKic3XZvzTdK％2Bt6Yuc6apgotfHfvloljc9riMUI％3D'

CREATE DATABASE SCOPED CREDENTIAL [https://myazurestorage10.blob.core.windows.net/extendedevent]
WITH IDENTITY='Shared Access Signature', SECRET='sv=2017-07-29&sr=c&si=mypolicy&sig=%2FB18QKic3XZvzTdK%2Bt6Yuc6apgotfHfvloljc9riMUI%3D'

然后我从sys.credentials中签入SELECT *. ，什么都没有.

and I check in SELECT * from sys.credentials  , there is nothing.

推荐答案

Hello,

您创建了错误的在存储帐户中，将存储帐户创建为常规"类型.而不是类型"Blob".

希望这会有所帮助.

Hope this helps.

问候

Regards,

Alberto Morillo
SQLCoffee.com

Alberto Morillo
SQLCoffee.com

这篇关于配置Xevent以存储在Azure存储上的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！