Setting up ASP.NET session state with SQL In memory OLTP and AlwaysOn database

Hello all,   Recently I had worked on a requirement of achieving high availability for asp.net sessions. This blog post focuses on using SQL Server as the session state mode and use In-memory OLTP and AlwaysOn technology as the storage option for session data and achieve high availability. In memory OLTP ensures increased performance and…

0

SQL database engine service startup failure: Troubleshooting Checklist

Hi all, In this article, we are covering the common scenarios of SQL Service startup failures and troubleshooting approach to resolve these issues:   1.  For standalone instance of SQL, always use SQL Server configuration manager to start the SQL database Engine service. For Clustered instance of SQL, always use Fail over Cluster manager tool…

0

Operating System Best Practice Configurations for SQL Server

Hi all, In this article, we are covering few important Operating System (Windows) best practice configurations for SQL Server. SQL Server is an user mode application runs on Windows Operating system and hence these configuration settings are important for SQL Server performance.   1. Partition the Disk volumes hosting SQL databases (Data and log) with…

2

SSIS Package Data flow Execution Slowness Troubleshooting

Hi all,   In this blog, we are covering “SQL SSIS package data flow execution slowness” troubleshooting guidelines. The approach mentioned in the blog can be used for reference while troubleshooting SSIS package data load performance issues.   Consider a simple SSIS data flow task, which is selecting the data from the OLE DB source…

0

Isolating SQL Performance Issues due to slow Disk IO subsystem

Hello all, In this blog, we are covering few checklists to identify and isolate disk IO subsystem bottlenecks causing SQL performance issues. The checklist can be used as reference while troubleshooting SQL Performance issues because of slow Disk IO subsystem.   Below screenshot summarizes the approach to troubleshooting Slow disk IO issues:   Checklist for troubleshooting:…

0

Database File movement in SQL AlwaysOn Availability group: A walk-through

Hello all,   In this blog, we are covering the scenario of moving the database files of AlwaysOn Availability Group (AG) enabled database to another location on all replicas with minimum downtime. To demonstrate database file movement, using Windows 2012 R2 cluster with AlwaysOn configured on SQL 2016 instance. This walk-through provides an example of…

2

Migrating SAP ASE database to Microsoft SQL Server using SSMA

Hi all, This blog covers the process of migrating SAP ASE databases to Microsoft SQL Server using SQL Server Migration Assistant (SSMA) tool.   Sybase SAP Adaptive Server Enterprise (ASE) database can be migrated to Microsoft SQL Server 2008/2008 R2/2012/2014/2016/SQL Server 2017/Azure SQL database on Windows/Linux using Microsoft SQL Server Migration Assistant (SSMA) for SAP…

0

Migrating On premise SQL database to Azure SQL database using DMA v3.2

Hi all, This blog covers the steps to migrate the On premise SQL Server database to Azure SQL database using Database Migration Assistant v3.2 (DMA) tool.   Data Migration Assistant (DMA) tool provides 2 options: Assessment: To asses the on premise database and check for any compatibility issues while upgrading to target database platform. Migration: Actual migration of the schema and…

0

Setting up SQL Server R service (In Database) and R Server(Standalone)

Hello all, Recently, I had worked on a requirement to install R services during the SQL 2016 installation. In this blog, I am covering the steps followed to install and configure R services (In database). Also, I have included steps to install R server (standalone) shared feature as part of SQL installation.   Please note that this blog is applicable to SQL…

4