Performance Tuning And Infra Automation

Baseline-SQL-Server Errors SQL Alerts

Find TempDb Space Consumers in SQL Server

Troubleshoot SQL Server tempdb database space issue and find out what sessions are consuming tempdb space.

Ajay Dwivedi June 19, 2021

Linux

SQL Server on Linux Mint

Why Linux? To start with, I think everyone agrees that Linux is core skills, and no doubt every IT professional should be familiar with it. Almost all enterprise software solutions…

Ajay Dwivedi June 11, 2021

Baseline-Sql-Server-with-Open-Source-Tools

Baseline-SQL-Server Performance Tuning SQL Alerts

How to Baseline Microsoft SQL Server with Open Source Tools

Are you tired of not knowing what is usual workload of your server? Do you want to know what is speed of your server? If you are a developer or…

Ajay Dwivedi September 19, 2020

Heavy-SqlServer-Workload-against-StackOverflow-database

Baseline-SQL-Server TSQL

Time conversion from local to UTC and vice-versa

Recently I have been working on setting up baselining for my SQL Server lab environment. As part of baselining, I capture all the required Perfmon counters both at SQL Server…

Ajay Dwivedi September 6, 2020

Baseline-SQL-Server TSQL

Get Time Duration in [DD hh:mm:ss] format

As DBA, there are various scenarios where I display duration in results. More often, for visual effects, I like to convert the same duration into [DD hh:mm:ss] format. For example,…

Ajay Dwivedi August 29, 2020

TSQL

Create & Populate StackOverflow.dbo.PostTags table

As a DBA & instructor, very often I like to generate heavy workload on my SQL Server instances to re-produce scenarios like 100% CPU, zero PLE, high IO, etc. For…

Ajay Dwivedi August 22, 2020

SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts

Health Check TSQL

SQL SERVER – Blocking Tree – Identifying Blocking Chain Using sp_WhoIsActive

As a DBA, I often receive user requests to check server slowness. Quite often, slowness is directly linked with active blocking on the server. I find many scripts on internet…

Ajay Dwivedi August 15, 2020

Install & Configuration PostgreSQL on CentOS 8 Linux

Linux PostgreSQL

Install/Configure PostgreSQL on CentOS 8

In my current organization, we have lot of postgres databases running on linux. So thought to learn the same by building my own CentOS 8 vm on VirtualBox. Below are…

Ajay Dwivedi August 8, 2020

$PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider 'NuGet'$

Powershell

Error/Fix: PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider ‘NuGet’

Yesterday I was trying to install dbatools powershell module in one virtual machine that I created for online SQL Class. [crayon-69470cf3e6b06712671820/] Resolution:- In order to solve this issue permanently, I…

Ajay Dwivedi August 1, 2020

Msg 3415, Level 16, State 5, Line 3 Database ‘StackOverflow2010’ cannot be upgraded because it is read-only, has read-only files or the user does not have permissions to modify some of the files. Make the database or files writeable, and rerun recovery.

Errors

Error/Fix: Database cannot be upgraded because it is read-only or has read-only files

Yesterday during my online SQL Server class, I was trying to attach 10 GB size version of StackOverflow database that I used previosly with another instance. When I executed below…

Ajay Dwivedi July 26, 2020