SQL Server Diagnostics Preview MSSQL Tiger Team. Today, Microsoft is releasing the SQL Server DiagnosticsPreview extension within SQL Server Management Studio and Developer APIs to empower SQL Server customers to achieve more through a variety of offerings to self resolve SQL Server issues. What this offers to our customers Analyze Dumps Customers using this extension will be able to debug and self resolve memory dump issues from their SQL Server instances and receive recommended Knowledge Base KB articles from Microsoft, which may be applicable for the fix. The memory dumps are stored in a secured and compliant manner as governed by the Microsoft Privacy Policy. SQLServer2012_0007_0010.PNG' alt='Download Microsoft Sql Server 2008 R2 System Clr Types For 2012' title='Download Microsoft Sql Server 2008 R2 System Clr Types For 2012' />For example, Joe, a DBA from Contoso, Ltd., finds that SQL Server has generated a memory dump while running a workload, and he would like to debug the issue. Using this feature, John can upload the dump and receive recommended KB articles from Microsoft, which can help him fix the issue. FAQ Q. What version of SQL Server is supported Answer SQL Server 2. Download Microsoft Sql Server 2008 R2 System Clr Types For 2012' title='Download Microsoft Sql Server 2008 R2 System Clr Types For 2012' />SQL Server 2. R2, SQL Server 2. SQL Server 2. 01. SQL Server 2. 01. Q. What version of SQL Server Management Studio SSMS is supported Answer Microsoft SQL Server Management Studio SSMS 2. SQL Server Management Studio 1. If you dont have SSMS installed, please install it from SQL Server Management Studio. Q. Which process dumps can be uploaded for analysisAnswer The dumps we are analyzing are for SQL Server process sqlservr. Lg Flash Tool V1.8. Q. What type of dumps are supported Answer We support mini dumps, filtered dumps and full dumps. Download Microsoft Sql Server 2008 R2 System Clr Types For 2012' title='Download Microsoft Sql Server 2008 R2 System Clr Types For 2012' />The dumps can be of the following types. Q. What are the scenarios in which the dump may have been generatedAnswer The dumps could have been generated for exceptions, hangs, non yielding scheduler and manual. Q. What SQL Server platforms are supported Answer We support SQL Server on premise and SQL Server running on VMs. Q. What is maximum size of the dumpsAnswer The maximum size of the dumps can be up to 1. GB. If the file size is more than 8 GB we recommend to use LZ4 compression to compress the file before the upload. Q. How is the recommendation determined Answer The memory dump is analyzed for the root cause like exceptions, assertion or non yielding schedulers and it is matched with any publicly available fixes for the issue in the form of KB articles. View Recommendations Customers will be able to keep their SQL Server instances up to date by easily reviewing the recommendations for their SQL Server instances. Customers can filter by product version or by feature area e. Always On, BackupRestore, Column Store, etc. Cumulative Updates CU and the underlying hotfixes addressed in the CU. To continue with the previous example, Contoso, Ltd. SQL Server 2. 01. Joe wants to understand the fixes pertaining to every feature area before he applies the latest CU. Using this feature, he can view all the fixes that are part of the CU across the different SQL Server feature areas. In the future, Joe also wants to receive proactive recommendations, including bug fixes, assessment and migration to latest SQL versions, from Microsoft. FAQ Q. What are the recommendations when I click on View Recommendations Answer We provide the information on the Latest Cumulative Updates for all supported SQL Server versions  SQL Server 2. R2, SQL Server 2. SQL Server 2. 01. SQL Server 2. 01. Developer APIs Developers who want to discover and learn about our APIs can view our developer portal and then use our APIs in their custom applications. Developers can log and discuss issues and even submit their applications to the application gallery. For example, Contoso, Ltd. SQL Server generates memory dumps. Using our developer APIs, Joe can now extend the monitoring system to call our APIs to pick up the memory dump, create and send custom alerts, including recommended Knowledge Base KB articles applicable to the fix, to his extended team. Note This extension requires Microsoft SQL Server Management Studio SSMS 2. If you do not have the latest Microsoft SQL Server Management Studio SSMS installed, please install it from here. If you would like to assess database migration to SQL Server from Microsoft Access, DB2, My. SQL, Oracle and Sybase please reference this article. To migrate existing on premises SQL Server, Oracle, and My. SQL databases to Azure, whether your target database is Azure SQL Database, Azure SQL Database Managed Instance, or Microsoft SQL Server in an Azure virtual machine, learn more about the Azure Database Migration Service. Learn how to uninstall stubborn SQL Server components from your system. The Microsoft SQL Server 2012 Feature Pack is a collection of standalone packages which provide additional value for Microsoft SQL Server 2012. For an opportunity to participate in a limited preview of this service, please submit a nomination.