Skip to content

Update readme.md #46

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
Bob Ward (rgward) merged 1 commit into from
Sep 11, 2024
Merged

Update readme.md #46

Changes from all commits
Commits
Show all changes
1 commit
Select commit
File filter

Filter by extension

Filter by extension
Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
6 changes: 4 additions & 2 deletions cloudsqlworkshop/07_Deploy_Manage_Optimize_AzureSQLDB/readme.md
View file
Open in desktop
Original file line number Diff line number Diff line change
Expand Up @@ -164,6 +164,8 @@ In this section, you will connect Azure SQL Database and explore more about your

You can do this in SSMS in your current connection, by using the drop-down in the upper left-hand corner and selecting your database. When you do this notice in the bottom right-hand corner of SSMS the connection string changes to include the database name. **Change the context now for the next step**.

### Explore Azure SQL Database through T-SQL

1. Examine resource limits of your database

Try executing the following query:
Expand Down Expand Up @@ -256,9 +258,9 @@ In this section, you will connect Azure SQL Database and explore more about your

Even with a logical server, the SQL Server instance is managed by Microsoft and you cannot change instance level settings but that is a benefit of having a managed database service.

8. Use XEvent Profiler (XEProfiler) for Azure SQL Database
### Use Extended Events through SSMS

XEProfiler provides you simliar capabilities as you may have seen in the past with SQL Profiler. XEProfiler allows you to quickly see a live stream of extended events for common events like SQL queries. XEProfiler has been supported for SQL Server and Azure SQL Managed Instance and is now supported for Azure SQL Database.
XEvent Profiler (XEProfiler) provides you simliar capabilities as you may have seen in the past with SQL Profiler. XEProfiler allows you to quickly see a live stream of extended events for common events like SQL queries. XEProfiler has been supported for SQL Server and Azure SQL Managed Instance and is now supported for Azure SQL Database.

You can access XEProfiler in SSMS off the Object Explorer when connected to the logical server of an Azure SQL Database.

Expand Down