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

sql-server

  • Home
  • sql-server
  • Page 6
Non-Trusted Foreign Keys
Posted inInternals Performance Tuning TSQL

Non – Trusted Foreign Keys in SQL Server

Today, I was working with one user to troubleshoot their query timeout issues. Analyzing wait stats on server, I found 'LCK_M_X' wait to be most prominent wait on server. This…
Posted by Ajay Dwivedi July 17, 2017
Easy Trick to Debug Long TSQL Codes
Posted inErrors TSQL

Easy Trick to Debug Long TSQL Codes

In my previous organization, working as Senior SQL Developer, I was often asked for help by fellow colleagues for identifying issues inside long and complex TSQL codes. Finding issues becomes…
Posted by Ajay Dwivedi May 6, 2017
Posted inPerformance Tuning

Log all Activities using sp_WhoIsActive – 2

Hi Friends, in my previous blog post Log all Activities using sp_WhoIsActive, I shared how easy it is to log all sql server sessions using sp_whoIsActive and SQL Server Agent…
Posted by Ajay Dwivedi May 4, 2017
Create/Restrict Data Files – Automation
Posted inTSQL

Create/Restrict Data Files – Automation

In my organization, as part of our strategy we keep Data files in 2 TB sized Mount Point Volumes named like 'Data','Data01','Data02' etc. on E:\ drive. Similary, for Log files…
Posted by Ajay Dwivedi April 16, 2017
Analyzing Deadlock Issues
Posted inErrors Performance Tuning

Analyzing Deadlock Issues

I often receive the question - what is the best way to find issues when client/user complaints of deadlock issues? Msg 1205, Level 13, State 51, Line 10 Transaction (Process…
Posted by Ajay Dwivedi February 21, 2017
Error/Fix: The database owner SID recorded in the master database differs from the database owner SID recorded in database
Posted inErrors

Error/Fix: The database owner SID recorded in the master database differs from the database owner SID recorded in database

Recently I received an incident for low disk space on mount point dedicated to system databases on development sql server. So I started checking SQL Server Error logs to find…
Posted by Ajay Dwivedi January 28, 2017
Setup fresh/Scriptout Existing Mirroring on SQL Server
Posted inDatabase Administration

Setup fresh/Scriptout Existing Mirroring on SQL Server

In my current organization, we have lot of servers where database mirroring is used as a disaster recovery option. Either we are setting up mirroring from scratch or dropping the…
Posted by Ajay Dwivedi January 25, 2017
Error/Fix: SQL Server has encountered 26063 occurrence(s) of I/O requests taking longer than 15 seconds to complete
Posted inErrors

Error/Fix: SQL Server has encountered 26063 occurrence(s) of I/O requests taking longer than 15 seconds to complete

Recently I received an incident for CheckDB job failure on one of our production server. Job history suggested that the job has been continuously failing for past 15 weeks. But,…
Posted by Ajay Dwivedi January 9, 2017
Optimize for TSQL Query Hint
Posted inPerformance Tuning TSQL

Optimize for Value – TSQL Query Hint

Today, I was working on an incident of slow running procedure. Procedure was running fine for most of the parameter values but, was getting stuck for few values. I could…
Posted by Ajay Dwivedi January 3, 2017
Result Set of [sp_WhoIsActive]
Posted inPerformance Tuning

Log all Activities using sp_WhoIsActive

It is not a new thing for a DBA to check what's running currently on server in order to figure out issues. My personal favorite tool for finding out current…
Posted by Ajay Dwivedi December 28, 2016

Posts pagination

Previous page 1 … 4 5 6 7 8 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
Copyright 2025 — Performance Tuning And Infra Automation. All rights reserved. Bloghash WordPress Theme
Scroll to Top