Top Support Solutions for SQL Server 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).
1. Solutions related to High Availability - 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 ...
- Create Listener Fails with Message 'The WSFC cluster could not bring the Network Name resource online'
2. Solutions related to Performance - Database query is slow or unresponsive
- Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads
- Optimizing Your Query Plans with the SQL Server 2014 ...
- Tips to design your queries for best performance - Curah!
- About Statistics and Query Optimizer
- How to analyze Query Performance
- SQL Server Performance troubleshooting : Approach and Tools - Curah!
- Statistics Used by the Query Optimizer in Microsoft SQL Server 2008
- 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 Blog
3. Solutions related to general Setup and Configuration or 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
- MSDN forums - SQL Server Setup &Upgrade
4. Solutions related to Connectivity - Cannot connect to a SQL Server
- Kerberos Configuration Manager for SQL Server is available
- Troubleshooting connectivity issues to SQL Server - Curah!
- "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
5. Solutions related to an Issue or error when using failover clustering