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…
![Should we check [context_switches] for SQL Server Query from Performance Point](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/05/Context-Switches.png?fit=1024%2C252&ssl=1)
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…
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…
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…
![[sp_HealthCheck] – Get SQL Server Health Details](https://i0.wp.com/ajaydwivedi.com/wp-content/uploads/2018/03/sp_HealthCheck.gif?fit=1024%2C500&ssl=1)
Posted inExecution Plan Health Check
[sp_HealthCheck] – Get SQL Server Health Details
Hi Friends, Ever wanted to check the heartbeat of SQL Server. It is a very…
Posted inExecution Plan Health Check Performance Tuning TSQL
What’s Running – Find All Details of Running Queries
I often see DBAs/developer struggling to find what's wrong with query. The first step in…
Posted inInternals
Myth – Shrinking Log Files is OK
Many times I have seen that DBAs feel like its OK to Shrink Log files…
Posted inPerformance Tuning
First Responder Kit Power BI Dashboard
Recently Brent Ozar team added yet another great feature of Power BI Dashboard on data…
Posted inExecution Plan Performance Tuning
Procedures with RECOMPILE Option
Hi Friends, I often work on Performance Issues, and I found that developers use RECOMPILE…
Posted inDatabase Administration
How to Verify Given Access/Permissions to User/Login
Hi Friends, I have seen DBAs to wait for user's confirmation for long after providing…