Top Support Solutions for SQL Server 2014

[Server Man]

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

• SQL Server Failover Cluster Installation
• Recommendations and Best Practices When Deploying SQL Server AlwaysOn Availability Groups in Microsoft Azure (IaaS)

Continue reading...