Category Archives: Uncategorized

SQL Server – What to collect for troubleshooting root cause of a problem

when we have unexpected behavior from SQL Server impacting SQL availability, it will be crucial to understand if we want to restore the service ASAP or troubleshoot to find the root cause. When we switch from troubleshooting to service restoration … Continue reading

Posted in Uncategorized | Tagged , , , , | Leave a comment

MSSQL Server – Monitors I recommend to run once a month

Though most of our monitors are configured to run from same tool at same interval, it is work to evaluate how frequently we run them based on its a few factors. in this post I list a few monitors/ checks … Continue reading

Posted in SQL, SQL Server, Uncategorized | Tagged , , , | Leave a comment

How to run a command using System credentials

PsExec can be downloaded from https://docs.microsoft.com/en-us/sysinternals/downloads/psexec and execute with -sid parameters!   Why do we need this? When a script is scheduled using Scheduled tasks and configured to run as System same credentials will be used. This process is to … Continue reading

Posted in Script, Uncategorized | Leave a comment

Resolved – Setup Doesnot Start For Sql Upgrade/Patch – 0x80004005

Installing SQL Service Pach or Hotfix does nothing; In general all the install logs will be available at Setup Bootstrap (Example: C:\Program Files\Microsoft SQL Server\140\Setup Bootstrap\Log ), however you will not be able to see any additional infomration. Before moving … Continue reading

Posted in SQL, SQL Error, SQL Server, Uncategorized | Tagged , , , , | Leave a comment

Python 101 – may be 100.01 :)

  While investigating a problem related to Python programs with open transactions I end up experimenting with Python today! It took a few hours to install Python, required libraries, execute first program and complete my actual investigation related to pyodbc … Continue reading

Posted in Powershell, Python, Uncategorized | Tagged , | Leave a comment

Maximum capacity specifications for SQL Server/ Azure DB/ Automation

Ever wonder what are the Maximum capacity specifications for SQL Server? Here you go: https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15 SQL Server Limits: https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-ver15   Azure Service and subscription limits: https://docs.microsoft.com/en-us/azure/azure-resource-manager/management/azure-subscription-service-limits      

Posted in Productivity, SQL, SQL Server, Uncategorized | Tagged , | Leave a comment

SQL – AlwaysOn Availability Group synchronization delay troubleshooting

I learned detailed step by step performance metrics and xevents that can be used to troubleshoot  AlwaysOn Availability Group synchronization delay.   https://docs.microsoft.com/en-us/archive/blogs/sql_server_team/troubleshooting-high-hadr_sync_commit-wait-type-with-always-on-availability-groups   Some network configuration that can be updated to address network challenges: https://docs.microsoft.com/en-us/windows-server/networking/technologies/network-subsystem/net-sub-performance-tuning-nics    

Posted in Performance, Referene, SQL, SQL Server, Uncategorized | Tagged , , , | Leave a comment

Very Large Database in SQL Server – How is it different

Following are a few considerations while managing a very large database on Microsoft SQL Server. I am not recommencing any configuration as different configurations are good fit for different workloads and business requirements but these are the items that can … Continue reading

Posted in Performance, SQL, SQL Error, Uncategorized | Tagged , , , | Leave a comment

MSSQLSERVER Error Catalog

https://docs.microsoft.com/en-us/sql/relational-databases/errors-events/database-engine-events-and-errors?view=sql-server-ver15

Posted in SQL, SQL Server, Uncategorized | Tagged , , , , , | Leave a comment

SOLUTION – Write-EventLog : The source name X does not exist on computer “localhost”

While attempting to create a new event log using write-eventlog cmdlet you may hit this error if the Source is not already registered. New-EventLog can be used to add anew source, following is the example

Posted in Uncategorized | Leave a comment