Top Support Solutions for SQL 2012
This is a collection of the top Microsoft Support solutions for the most common issues experienced when using Microsoft SQL Server 2012. Note that some content that applies to earlier versions of SQL Server is listed, because it can be also helpful with SQL Server 2012 issues.
1. Solutions related to setup and configuration:
- Recommended updates for high performance
- SQL Server Performance troubleshooting : Approach and Tools
- CSS SQL blog posts
- SQL Server I/O Basics, Chapter 2
- Recommendations and guidelines for the "max degree of parallelism" configuration option in SQL Server
- Deadlock troubleshooting
- Data engine forum
- Karthick PK's technical blog
- Free Tools for the DBA: PAL Tool
2. Solutions related to AlwaysOn Availability Group resource unexpected failures:
- Recommendations and Best Practices When Deploying SQL Server AlwaysOn Availability Groups in Microsoft Azure (IaaS)
- Connection Timeouts in Multi-subnet Availability Group
- Create Listener Fails with Message 'The WSFC cluster could not bring the Network Name resource online'
3. Solutions related to cluster failover:
- Troubleshooting SQL Server failover clusters
- Failover Cluster Troubleshooting
- High availability forum
4. Solutions related to backup or restore:
5. Solutions related to crashes and exceptions:
6. Solutions related to Cluster - Setup or upgrade:
- Windows Installer starts repeatedly after you install SQL Server 2012 SP1
- How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
- How to use SQL Server in Windows and Windows Server environments
- Where to find information about the latest SQL Server builds
- MSDN forum
7. Solutions related to configuration – SharePoint configuration:
- Troubleshooting an SSRS Installation in SharePoint Mode
- Reporting Services SharePoint Integration Troubleshooting
- Troubleshoot a Reporting Services Installation
- RS Forums
8. Solutions related to stand-alone setup or upgrade:
- Windows Installer starts repeatedly after you install SQL Server 2012 SP1
- How to restore the missing Windows Installer cache files and resolve problems that occur during a SQL Server update
- How to use SQL Server in Windows and Windows Server environments
- Where to find information about the latest SQL Server builds
- MSDN forum
9. Solutions related to performance-specific query:
- Curah for query perf
- Recommended updates for high performance
- Query performance
- Statistics
- SQL Server Performance troubleshooting : Approach and Tools
- Data engine forum
10. Solutions related to AlwaysOn Availability Group resource performance issue:
- Monitor Performance for AlwaysOn Availability Groups
- Home of the Microsoft SQL Server AlwaysOn Support Team
- Technet forums - SQL Server High Availability and Disaster Recovery