Top Support Solutions for SQL 2014
This is a collection of the top Microsoft Support solutions for the most common issues experienced when using Microsoft SQL Server 2014 (updated quarterly). Note that some content that applies to earlier versions of SQL Server is listed, because it can be also helpful with SQL Server 2014 issues.
1. Solutions related to setup and configuration:
- Planning a SQL Server Installation
- SQL Server 2014 Release Notes
- Where to find information about the latest SQL Server builds
- Setup and upgrade forum
2. Solutions related to failure or error during installation:
- View and Read SQL Server Setup Log Files
- SQL Server 2014 Release Notes
- Repair a Failed SQL Server 2014 Installation
- Planning a SQL Server Installation
- Where to find information about the latest SQL Server builds
- Setup and upgrade forum
3. Solutions related to an issue or error when using AlwaysOn:
- Recommendations and Best Practices When Deploying SQL Server AlwaysOn Availability Groups in Microsoft Azure (IaaS)
- Tutorial: Listener Configuration for AlwaysOn Availability Groups
- Create Listener Fails with Message 'The WSFC cluster could not bring the Network Name resource online'
4. Solutions related to database query is slow or unresponsive:
- Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads
- Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
- Tips to design your queries for best performance
- Statistics
- Query Performance
- SQL Server Performance troubleshooting : Approach and Tools
- Statistics Used by the Query Optimizer in Microsoft SQL Server 2008
- Data engine forum
- Monitor and Tune for Performance
- Tips, Tricks, and Advice from the SQL Server Query Processing Team
- Craig Freedman's SQL Server Blog
- Karthick PK's technical blog covering topics such as SQLServer troubleshooting, technologies and security+D25
5. Solutions related to can’t connect to a SQL Server:
- Kerberos configuration manager
- Troubleshooting connection issues
- Data access forum
- "General Network error," "Communication link failure," or "A transport-level error" message when an application connects to SQL Server
- FIX: Errors when a client application sends an attention signal to SQL Server 2008 or SQL Server 2008 R2
6. Solutions related to general performance:
- Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator
- Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads
- Tips to design your queries for best performance
- Statistics
- Query Performance
- SQL Server Performance troubleshooting : Approach and Tools
- Data engine forum
7. Solutions related to database server is slow or unresponsive:
- Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 used with high-performance workloads
- 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 covering topics such as SQLServer troubleshooting, technologies and security+D25
- Free Tools for the DBA: PAL Tool
- SQL Server Perfmon Counters of Interest