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…

3

SQL High CPU troubleshooting checklist

Hello all, In this blog, I am covering the scenario of an approach to troubleshoot “SQL Server consuming High CPU” and few checklist points which will help in isolating/troubleshooting. Below screenshot summarizes an approach to isolate SQL high CPU issues: CHECKLIST POINTS: 1. From Windows task manager check the overall CPU utilization. Collect the details of…

0

Troubleshoot SQL Query Performance Issues Using QUERY STORE

Hello all, Query Store is a very powerful SQL engine feature available in SQL 2016 designed to deliver insight into query performance (query text, query plan, runtime stats) by keeping track of different plans and execution statistics for the queries executed on the server. This blog covers the steps to troubleshoot/monitor the SQL Server queries using…

0

SQL Connectivity troubleshooting checklist

Hello all, During daily operations with SQL Instances, DBA/Application teams frequently encounter SQL Connectivity issues while connecting from the applications. In this  blog, I am covering few checklist steps to troubleshoot SQL Connectivity issues. When a client connects to SQL Server, it goes through authentication and authorization stages. If the connectivity issue is because of…

0

Migrate SQL database from On-Prem to Azure using SQL Database Migration Wizard tool

Hello all, In this blog, I am covering the scenario of migrating the SQL Server database from On premise environment to SQL Azure Virtual machine.   There are multiple ways to migrate the application database hosted in On premise to Azure Virtual machine. Few to mention are: Use the Deploy a SQL Server Database to…

0

Migrating database from AlwaysOn AG to another with JoinOnly option

Hi all,  In this blog, I am covering a scenario of migrating a SQL database from one AlwaysOn Availability Group (AG) to a new AG. I was involved in such requirement and the goal was to migrate the database which was in terabytes size to another AG without having to apply the Full back up…

0

Enabling client side SSL encryption to SQL Server

Hello all, In this blog, I am covering the scenario of enabling SSL encryption on the client while connecting to SQL Server.   SSL encryption with SQL server can be achieved by enabling Server side encryption or client side encryption. Server side encryption requires, enabling Force encryption= True on SQL Server which will enable encryption…

0

Troubleshooting IIS request performance slowness issues using FREB tracing

Hello all, In this blog, I would like to cover the scenario of troubleshooting web application page execution slowness issue using Freb logs.   FREB (Failed Requests Tracing) is one of the feature available to troubleshoot IIS issues. It does request based tracing, and produces a log file (in .xml format) that shows events and…

2