darkturtle

링크 :http://rusanu.com/2016/04/01/understanding-sql-server-query-store/ https://www.brentozar.com/archive/2014/11/sql-server-query-store/ https://docs.microsoft.com/en-us/sql/relational-databases/performance/monitoring-performance-by-using-the-query-store?view=sql-server-2017https://docs.microsoft.com/en-us/sql/relational-databases/performance/best-practice-with-the-query-store?view=sql-server-20..

가. TOP 대기 이벤트 찾기 EXEC sp_BlitzFirst @SinceStartup = 1; 나. TOP 대기 이벤트 의미 찾기 다. TOP 대기 이벤트 유발 시키는 QUERY 찾기EXEC sp_BlitzCache @SortOrder = 'cpu'; >-. How to Get Support-. sp_Blitz: Overall Health Check-. Advanced sp_Blitz Parameters -. Writing sp_Blitz Output to a Table-. Skipping Checks or Databases-. sp_BlitzCache: Find the Most Resource-Intensive Queries-.Advanced sp_BlitzCache Parameters-.sp_Bl..

출처 : https://www.databasejournal.com/features/mssql/introduction-to-azure-sql-managed-instance.html 방법1) Iaas( Infrastructure-as-a-Service) 형태, Iaas Azure SQL Server 구성 방법2) Paas( Platform-as-a-Service) 형태. Paas 기반 Azure SQL - 패치 백업에 대해서 관리 필요 없음, 수직 확장 님 재해 복구 구성 용이 - 미지원 : Server Agent, Profile, Database Mail, DB 간 Query, Linked Server 이 부분은 AWS 도 유사함 -->http://darkturtle.tistory.com/category/..

AWS EC2 MS SQL VS AWS RDS MSSQL 링크 : http://www.sqlservercentral.com/articles/SQL+Server/170697/ AWS EC2(Elastic Compute Cloud) MS SQL AWS RDS MSSQL Content ECS2 is the AWS Version of a virtual machine in the cloud ( Iaas ) Paas , Daas(Database as a Service Highly Scalability ( Using this already confiugred image ) NO Access is allowed to the OS Easy Backups ( basically taking a backup of the en..

>Iaas 형태 든지, MS Azure 링크 : https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_SQLServer.html#SQLServer.Concepts.General.FeatureNonSupport Always On (2012 Enterprise Edition)Stretch databaseBacking up to Microsoft Azure Blob StorageBuffer pool extensionBULK INSERT and OPENROWSET(BULK...) featuresData Quality ServicesDatabase Log ShippingDatabase MailDistributed Queries (i.e., Linked Serv..