Lesson Learned #224:Hands-On-Labs: Checking the performance with Perf Collector Analyzer
One of the main problem that we have when we are working with multiple databases in an Elastic Databases Pool or Azure SQL Managed Instace (that are running on same SQL Instance) is how to consolidate all the information in a single place. For example, if we use Query Data Store we need to review one by one the database finding the performance problem. Trying to resolve these insights we would like to suggest to use PerfCollector and PerfCollector Analyzer to allows you to capture and query the information collected for all the databases that you have in an Elastic Database Pool and SQL Managed Instance and even, all the databases associated in an Azure SQL Server or On-Premises.Lesson Learned #223:Hands-On-Labs: How to improve a bulk insert process
We used to have cases where our customers reported that they need more throughput using a bulk insert process for their database located on Azure SQL Database, Azure SQL Managed Instance or On-Premises. In this video below we going to provide us some insights about how to improve this throughput.
