Deepak Bhardwaj

IT Consultant of almost 10 years of experience with various business vertical in IT Infrastructure Service, methods, processes, strategic technology infrastructure planning, and developing cost effective solutions to meet customer business requirements.

Author's posts

SQL SERVER – None of the IP addresses configured for the availability group listener can be hosted by the server Either configure a public cluster network. Error: 19456

Requirement: Add a node to availability alwayson group. It’s an multi-subnet and the node is a DR node on a different subnet. It is a three node cluster two in same data center (US East) and third node is in DR (US Central). Node A – 172.28.76.12 Node B – 172.28.76.13 Node 3 – 172.29.77.14 …

Continue reading

Create a AWS Lambda Function to Stop and Start RDS Instance

I am getting request from friends to stop the Relational Database Service (RDS) instance after peak workload times. I am going to use AWS Lambda functions to stop the RDS instance. You can use the same steps to stop other supported types of instances, like MySQL, PostgreSQL, SQL Server or MariaDB. Below mention steps to …

Continue reading

Amazon Web Services – Overview of AWS

Introduction about AWS Amazon Web Services (AWS) began in 2006 offering IT infrastructure services to businesses in the form of web services. Currently it is commonly known as cloud computing. With the cloud services, Business Entities no longer need to plan for and procure servers and other IT infrastructure in advance, whereas they can instantly …

Continue reading

[Warning] IP address ‘X.X.X.X’ could not be resolved: Name or service not known

In one of  RDS instance getting  warning messages in the error log file. “[Warning] IP address ‘X.X.X.X’ could not be resolved: Name or service not known” I have checked and DNS lookup is working fine. In RDS hope you all aware about the concept of Security Groups where we white list the IP address so that they …

Continue reading

Microsoft SQL Server 2016 Cluster installation

Step by Step installation of SQL Server 2016 cluster. SQL Server 2016 Cluster is similar to SQL Server 2008R2 but in SQL Server 2016 you can configure the TEMPDB during installation.   Please download the PDF version. SQL Server 2016 Cluster.   Enjoy the SQL cluster Installation in case any issue you can reach me …

Continue reading

Important Points before backing up the SQL Server Databases

Important Points before backing up the SQL Server Databases. Backing up SQL Server databases is one of the important job to protect the data. Consider the below points while planning and backing up the databases. 1. One of the important step is the Backup plan. Most of the DBA only consider the user database backup …

Continue reading

Windows server 2012 failover cluster Error:There are currently no logon servers available to service the logon request

Getting below Error while building windows 2012 failover cluster. ……………………………………………………………………………………………………………………………………………………….. Checking for account information for the computer object in the ‘UserAccountControl’ flag for CN=SQLDBCLU,CN=Computers,DC=abc,DC=co,DC=in. Set password on SQLDBCLU. There are currently no logon servers available to service the logon request. Unable to successfully cleanup. An error occurred while creating the cluster and the nodes will …

Continue reading

InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks.

Today one of my friend reported error message in one of his MySQL 5.6.35 Community Version. InnoDB: WARNING: over 67 percent of the buffer pool is occupied by lock heaps or the adaptive hash index! Check that your transactions do not set too many row locks. InnoDB: Your buffer pool size is 127 MB. Maybe you should …

Continue reading

[Warning] IP address ‘10.10.10.10’ could not be resolved: Name or service not known

Getting Warning Messages in MYSQL.log file. [Warning] IP address ‘XX.XX.XX.XXcould not be resolved: Name or service not known. Now question is why this warning message captured in MYSQL log file. First we have to check the IP address or domain is internal or external. If the Users are not authorised users than we have to …

Continue reading

SQL Server Agent service failed to come Online on the Active Node in a 2 Node Fail-over cluster.

SQL Server Agent service failed to come Online on the Active Node in a 2 Node Fail-over cluster. Error Messages in the Event-logs. [sqagtres] OnlineThread: ResUtilsStartResourceService failed (status 435) [sqagtres] StartResourceService: Failed to start SQLSERVERAGENT service. CurrentState: 1 [sqagtres] OnlineThread: Error 435 bringing resource online. To understand the problem, we have to check the AgentError …

Continue reading

WP2Social Auto Publish Powered By : XYZScripts.com