Skip to content

Performance Tuning And Infra Automation

I love performance tuning and building automation

  • Home
  • About Me
  • All Articles
  • Contact Me
  • Home
  • Pretty Links
  • Privacy Policy
  • SQL Resources
  • facebook.com
  • twitter.com
  • t.me
  • instagram.com
  • youtube.com
Subscribe
Top Stories
StackOverflow2013 database on PostgreSQL
Get StackOverflow2013 Database for PostgreSQL & SQLServer
June 30, 2025
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
June 28, 2025
LogRotate Policy For PostgreSQL
April 25, 2025
Build CI/CD Github Action Pipeline for Ansible Playbook
Run Ansible Playbooks with Github Action
March 21, 2025
Server getting slow over time until restart
SQLServer Gradually Becomes Slow Until Reboot
November 14, 2024
SQLServer Alerts on Slack
Setup SQLServer Alerts with Open Source SQLMonitor
November 6, 2024
How to execute a sql query on multiple servers using PowerShell
Run SQL Query on Multiple Servers Using PowerShell – Serially
December 23, 2023
How to Use Credential Manager for Storing and Retrieving Passwords
How To Handle Passwords in PowerShell Automation
December 17, 2023
SQLMonitor - Open source tool to monitor SQLServers
Baseline SQLServer with SQLMonitor v1.6.0
December 10, 2023
Self Hosted Website Access from Internet
How to Access Home Lab Using Internet
September 8, 2023
Core Health Metrics for SQLServers on SQLMonitor
Proactive Monitoring of SQLServers using WaitStats
September 1, 2023
HIGH CPU on SQL Server with SOS_SCHEDULER_YIELD & PAGELATCH Waits
Live Troubleshooting High CPU on SQL Server – Part 3
December 31, 2022
Find SQL Server Issues with Open Source Monitoring Solution SQLMonitor
How To Find If SQLServer Needs More Memory?
December 26, 2022
Resource Utilization Trend by Login Program on SQLServer
Baseline SQLServer with SQLMonitor v1.3.0
December 23, 2022
Troubleshooting SQLServer Performance Issues using SQLMonitor
Troubleshooting High Stolen CPU Scenario On SQLServer
December 14, 2022
Troubleshooting SQL Server Issues Using Wait Stats
How to Monitor All SQLServers LIVE
December 8, 2022
SQLMonitor - DB File IO Stats
Troubleshooting SQL Server Storage IO
November 12, 2022
How to Write Prod Grade Code
Best Practices for Production Grade Code
November 8, 2022
Baseline SQLServer using SQLMonitor
Monitor SQLServer using SQLMonitor v1.1.0
October 18, 2022
Dynamic SQL To Query Remote Server Health
Get Core SQLServer Health Metrics using Dynamic SQL
October 11, 2022
Troubleshoot CPU Issue on SQL Server using SQLMonitor
Troubleshooting High CPU on SQL Server – Part 2
October 6, 2022
CPU Consumers on SQL Server using SQLMonitor
Live Troubleshooting High CPU on SQL Server – Part 1
October 3, 2022
Find server issues using Wait Stats
Troubleshooting SQL Server with High Memory Grants
September 30, 2022
Do your part of charity by jogging
How to Experience Miracle Morning?
September 28, 2022
Build SQL Server Lab Desktop
Desktop Build for SQL Server Lab
September 26, 2022
Msg 924, Level 14, State 1, Line 1
Error/Fix: Msg 924. Get Database Out of Single User Mode
September 23, 2022
SQLMonitor All Server Dashboard
SQL Server Live Health Check
September 17, 2022
Blocking Mail Notification Alet for SQL Server on-prem & cloud
Create Auto-Clearing Blocking Tree Alert on SQL Server
December 10, 2021
Hire Me - SQL Server Automations
Resume Writing & Interviewing Tips
December 3, 2021
SQL Server Lab Setup
SQL Server Lab 01 – MultiSubnet Availability Group with FCI
July 4, 2021
find-top-tempdb-space-consumers
Find TempDb Space Consumers in SQL Server
June 19, 2021
SQL Server on Linux Mint
SQL Server on Linux Mint
June 11, 2021
Baseline-Sql-Server-with-Open-Source-Tools
How to Baseline Microsoft SQL Server with Open Source Tools
September 19, 2020
Heavy-SqlServer-Workload-against-StackOverflow-database
Time conversion from local to UTC and vice-versa
September 6, 2020
Waits Stats Duration in [dd hh:mm:ss]
Get Time Duration in [DD hh:mm:ss] format
August 29, 2020
Heavy-SqlServer-Workload-against-StackOverflow-database
Create & Populate StackOverflow.dbo.PostTags table
August 22, 2020
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts
SQL SERVER – Blocking Tree – Identifying Blocking Chain Using sp_WhoIsActive
August 15, 2020
Install & Configuration PostgreSQL on CentOS 8 Linux
Install/Configure PostgreSQL on CentOS 8
August 8, 2020
PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider 'NuGet'
Error/Fix: PackageManagement\Install-PackageProvider : No match was found for the specified search criteria for the provider ‘NuGet’
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.
Error/Fix: Database cannot be upgraded because it is read-only or has read-only files
July 26, 2020
SQL Server - Index Maintenance for Replication Databases
SQL Server – Doing Index Maintenance when HADR solutions are in Place
February 22, 2020
Error - Cannot initialize the data source object of OLE DB provider "OraOLEDB.Oracle" for linked server. (.Net SqlClient Data Provider)
Error/Fix: Cannot initialize the data source object of OLE DB provider “OraOLEDB.Oracle” for linked server. (.Net SqlClient Data Provider)
February 20, 2020
ScriptOut-LinkedServers-With-Actual-Password
ScriptOut Linked Server with Actual Password
October 25, 2019
Useful-SqlServer-Scripts
Some useful Scripts
September 8, 2019
Long-Running-Jobs-Snapshot
Setup Long-Running Jobs Alert
September 7, 2019
Remove High VLF in SQL Server Log Files
Get Rid of High VLF Easily
March 14, 2019
Baseline SQL Server
March 5, 2019
How to Setup Blocking Alerts on SQL Server
August 18, 2018
Indexing Maintenance Solution for Replication
July 10, 2018
Error/Fix: There is insufficient system memory in resource pool ‘default’ to run this query.
July 7, 2018
Question/Answer – Should I filter the data in Sub Queries??
May 28, 2018
Should we check [context_switches] for SQL Server Query from Performance Point
May 27, 2018
Copy SQL and Batch Files from Source to Destination using PowerShell
May 2, 2018
OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names
April 24, 2018
Get-ProcessForDBA cmdlet in SQLDBATools Module
April 22, 2018
Starting SQL Server Database Administration Classes from May 2018
April 20, 2018
SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics
April 19, 2018
SQL Server – Get Database Backup History for Crash Recovery
April 18, 2018
Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
April 15, 2018
Script-SQLDatabaseRestore cmdlet in SQLDBATools Module
April 14, 2018
Setup Custom Log Shipping in SQL Server
April 7, 2018
[sp_HealthCheck] – Get SQL Server Health Details
March 31, 2018
What’s Running – Find All Details of Running Queries
March 30, 2018
Myth – Shrinking Log Files is OK
March 28, 2018
[usp_AnalyzeSpaceCapacity] – SQL Server Space Management Made Easy
March 24, 2018
First Responder Kit Power BI Dashboard
February 8, 2018
Procedures with RECOMPILE Option
January 7, 2018
How to Verify Given Access/Permissions to User/Login
November 8, 2017
SQL Server Database Administration (DBA) Classes in Noida
New SQL DBA Coaching Batch Starting from Nov 2017
September 12, 2017
Database Mail Profile using 2-Step Authenticated GMail Account in SQL Server 2016
Error/Fix: Database Mails using Gmail getting to Unsent Items
September 10, 2017
Common Myth: Loop is Always Faster than Cursor
July 22, 2017
Help on Apply-FirstResponderKit
Deploy SQL-Server-First-Responder-Kit with Powershell
July 19, 2017
Non-Trusted Foreign Keys
Non – Trusted Foreign Keys in SQL Server
July 17, 2017
Easy Trick to Debug Long TSQL Codes
May 6, 2017
Log all Activities using sp_WhoIsActive – 2
May 4, 2017
Create/Restrict Data Files – Automation
April 16, 2017
Analyzing Deadlock Issues
February 21, 2017
Error/Fix: The database owner SID recorded in the master database differs from the database owner SID recorded in database
January 28, 2017
Setup fresh/Scriptout Existing Mirroring on SQL Server
January 25, 2017
Error/Fix: SQL Server has encountered 26063 occurrence(s) of I/O requests taking longer than 15 seconds to complete
January 9, 2017
Optimize for TSQL Query Hint
Optimize for Value – TSQL Query Hint
January 3, 2017
Result Set of [sp_WhoIsActive]
Log all Activities using sp_WhoIsActive
December 28, 2016
A Curious Case of Orphan User
November 30, 2016
How do I verify if my login if set to Non-Expiry [SQL Server]?
November 28, 2016
Query Optimization 03 – Users statistics (individual user) [StackOverflow]
November 27, 2016
Error/Fix: The Extended Events session named “blocked_process” could not be found.
November 24, 2016
Query Optimization 02 – Questions and Answers per Month [StackOverflow]
November 21, 2016
Script to Analyze Mount Point Space & Generate Shrink File Statements
November 20, 2016
Query Optimization 01 – What is my accepted answer percentage rate [StackOverflow]
November 14, 2016
Why my query is slow?
November 12, 2016
SQL SERVER – Fix : Error : The request failed or the service did not respond in a timely fashion
November 3, 2016
Performance Tuning With Predicate Logic
October 15, 2016
Cast on variable Scale
Get Decimal Scale Based on Variable Value
October 9, 2016
SSMS Query Shortcuts
Query Shorcuts SQL Server SSMS – Get Max Data Length
September 30, 2016
Previev-Image-Relationship-Data-In-Easy-Way
Relationship data in Easy Way
September 27, 2016
StackOverflow2013 database on PostgreSQL
Posted inDatabase Administration PostgreSQL

Get StackOverflow2013 Database for PostgreSQL & SQLServer

Download StackOverflow2013 database for PostgreSQL & SQLServer to compare performance. We can figure out which if faster between PostgreSQL & SQLServer.
Continue Reading
Posted by Ajay Dwivedi June 30, 2025
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Posted inErrors TSQL

Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer

Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Continue Reading
Posted by Ajay Dwivedi June 28, 2025
Posted inLinux PostgreSQL

LogRotate Policy For PostgreSQL

Learn how to create a log rotation policy for postgresql logs based on size
Continue Reading
Posted by Ajay Dwivedi April 25, 2025
Build CI/CD Github Action Pipeline for Ansible Playbook
Posted inAnsible DevOps

Run Ansible Playbooks with Github Action

Build CI/CD Github Action Pipeline for running Ansible Playbook
Continue Reading
Posted by Ajay Dwivedi March 21, 2025
Server getting slow over time until restart
Posted inBaseline-SQL-Server Performance Tuning SQLMonitor

SQLServer Gradually Becomes Slow Until Reboot

How to resolve issue where SQLServer gets slow over time until reboot
Continue Reading
Posted by Ajay Dwivedi November 14, 2024
SQLServer Alerts on Slack
Posted inBaseline-SQL-Server SQLMonitor

Setup SQLServer Alerts with Open Source SQLMonitor

Setup SQLServer monitoring and alerting using open source tool SQLMonitor. Send slack alert notifications.
Continue Reading
Posted by Ajay Dwivedi November 6, 2024
Question/Answer – Should I filter the data in Sub Queries??
Posted inExecution Plan Performance Tuning TSQL

Question/Answer – Should I filter the data in Sub Queries??

Recently a good friend of mine asked me question whether is there any performance benefit in filtering the data out in subqueries, and then joining them. Well, answer is NO.…
Posted by Ajay Dwivedi May 28, 2018
Should we check [context_switches] for SQL Server Query from Performance Point
Posted inPerformance Tuning TSQL

Should we check [context_switches] for SQL Server Query from Performance Point

Hi Friends. If you are wondering if we should check [context_switches] counter for SQL Server Queries while performance tuning, then here is the official verdict from Paul Randal. Thanks Friends!…
Posted by Ajay Dwivedi May 27, 2018
Copy SQL and Batch Files from Source to Destination using PowerShell
Posted inPowershell

Copy SQL and Batch Files from Source to Destination using PowerShell

Recently as part of Server Migration, I had to move nested folders and files from Source server to Destination. This task becomes hard when directory has child folders and files…
Posted by Ajay Dwivedi May 2, 2018
OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names
Posted inDatabase Administration

OlaHallengren Maintenance Solution – DatabaseBackup – Configurable Backup Directory folder names

If you are a DBA then you understand the importance of having robust Database Maintenance Solution. Like everybody in SQL Server Community, Ola Hallengren's Maintenance Solution is my favorite. Two…
Posted by Ajay Dwivedi April 24, 2018
Get-ProcessForDBA cmdlet in SQLDBATools Module
Posted inPowershell

Get-ProcessForDBA cmdlet in SQLDBATools Module

Troubleshooting high memory utilization on servers involves finding out processes which are consuming RAM. But default methods like Task Manager, or Get-Process cmdlet of PowerShell are difficult to read and…
Posted by Ajay Dwivedi April 22, 2018
Starting SQL Server Database Administration Classes from May 2018
Posted inTSQL

Starting SQL Server Database Administration Classes from May 2018

Hi Friends, I have finally decided to go with another batch for SQL Server Database Administration from May 2018. This would be 4-month course for 5 days per week with…
Posted by Ajay Dwivedi April 20, 2018
SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics
Posted inHealth Check TSQL

SQL Server – Stop Agent Job After Threshold Time and Log the Query Metrics

Being a DBA, I know the pain of a long running job creating performance issues for other jobs and user sessions. For my current organization, I have created below TSQL…
Posted by Ajay Dwivedi April 19, 2018
SQL Server – Get Database Backup History for Crash Recovery
Posted inTSQL

SQL Server – Get Database Backup History for Crash Recovery

It is not easy to find out right backups for restore activity when people are watching you during database crash situation. So I have created below TSQL script that would…
Posted by Ajay Dwivedi April 18, 2018
Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation
Posted inErrors TSQL

Error/Fix: Cannot resolve the collation conflict between “Latin1_General_CI_AS” and “SQL_Latin1_General_CP1_CI_AS” in the equal to operation

Recently I was working on a SQL query in my inventory database, and was greeted with below error message:- Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the…
Posted by Ajay Dwivedi April 15, 2018
Script-SQLDatabaseRestore cmdlet in SQLDBATools Module
Posted inTSQL

Script-SQLDatabaseRestore cmdlet in SQLDBATools Module

Restoring multiple databases can be painful especially when each of them have multiple database file(s). Four years back, I wrote TSQL script that would accept database backup path, and result…
Posted by Ajay Dwivedi April 14, 2018

Posts pagination

Previous page 1 … 4 5 6 7 8 … 10 Next page
Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 100 other subscribers
See what other community members think about SQLMonitor.
Recent Posts
  • Get StackOverflow2013 Database for PostgreSQL & SQLServer
  • Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
  • LogRotate Policy For PostgreSQL
  • Run Ansible Playbooks with Github Action
  • SQLServer Gradually Becomes Slow Until Reboot
Facebook With Ajay Dwivedi
Facebook With Ajay Dwivedi

CATEGORIES

  • Ansible 1
  • Baseline-SQL-Server 22
  • Database Administration 11
  • DevOps 1
  • Errors 15
  • Execution Plan 8
  • Growth & Development 2
  • Health Check 8
  • Internals 3
  • Linux 4
  • Performance Tuning 35
  • PostgreSQL 3
  • Powershell 8
  • SQL Alerts 5
  • SQLMonitor 17
  • TSQL 41
You May Have Missed
StackOverflow2013 database on PostgreSQL
Posted inDatabase Administration PostgreSQL

Get StackOverflow2013 Database for PostgreSQL & SQLServer

Posted by Ajay Dwivedi June 30, 2025
Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer
Posted inErrors TSQL

Error/Fix: Cannot Insert Duplicate Key for UPSERT Code in SQLServer

Posted by Ajay Dwivedi June 28, 2025
Posted inLinux PostgreSQL

LogRotate Policy For PostgreSQL

Posted by Ajay Dwivedi April 25, 2025
Build CI/CD Github Action Pipeline for Ansible Playbook
Posted inAnsible DevOps

Run Ansible Playbooks with Github Action

Posted by Ajay Dwivedi March 21, 2025
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloghash WordPress Theme
Scroll to Top