In my last post, we talked about How to Troubleshoot and Fix Webservice Timeout Issues.Today, we will talk about another issue “unable to install SQL Server”. Solution 1: Install the patch Try applying the SP3/SP4 patches for the operating system. If already applied, try again. First, uninstall SQL Server, then delete the “Microsoft SQL Server” folder […]
Category: Database
Timeout Expired is a common error in SQL Server. The image below shows an error screenshot with the message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The detailed error description in the log is as follows: [SqlException (0x80131904): Timeout expired. The timeout period elapsed […]
Backgroud Today, I installed a Windows system on a virtual machine to set up an Oracle server. There were many issues from installation to usage, and resolving these problems took a lot of time and research. During the installation process, I encountered ORA-00922 and ORA-28000 errors. These errors occurred because the password setup was too […]
During the process of database development and data management, encountering issues with connecting to the database is a common and frustrating problem. In the former articles, we have talken about SQL Server connection issue. Today, we will discuss the solutions for connecting to an Oracle database. Reasons for Unable to Connect to Oracle Database Issue […]
Oracle Database is the most popular enterprise-level database, so understanding its troubleshooting solutions is important. Today, let's learn what to do if Oracle Database is unable to write data. 1. Oracle Fails to Start or Database Cannot Start If the database fails to start, the first step is to check if the system tables are […]
Issue background When accessing the database via MySQL Shell, I encounter MySQL Error 1045 (28000): Access denied for user ‘root’@’::1′ (using password: YES). Let’s take a closer look at what this issue entails. The test environment here is MySQL 8.0.35. Let’s first take a look at an error case: $ mysqlsh -h localhost -P 7306 […]
In SQL Server, if we want to check the start time of the SQL Server instance, what methods and techniques can we use? Below are some summarized methods for checking the start time of the SQL Server instance. Method 1. Check SQL Server instance start time with sys.dm_server_services By checking the system dynamic management view sys.dm_server_services, […]
Problem Discription Today, I noticed that the CPU usage of a monitored SQL Server database instance was abnormal. There was a significant discrepancy between the system’s CPU utilization (O/S CPU Utilization) and the database instance’s CPU utilization (Instance CPU Utilization). Upon logging into the server for inspection, I found that the Database Mail Engine process […]
Problem Description During SQL Server installation, it prompts that the WMI service cannot start. How to fix SQL Server can’t start the WMI service? 1. Create a new txt file, copy the following code into it: @echo on cd /d c:\temp if not exist %windir%\system32\wbem goto TryInstall cd /d %windir%\system32\wbem net stop winmgmt winmgmt /kill […]
How can we quickly delete data from large tables in SQL Server? Before answering this question, we must clarify the context and specific needs, as different scenarios require different approaches. Scenario 1: Deleting All Data from the Entire Table If the goal is to clear or delete all data from an entire table, this scenario […]