In SQL Server, we may sometimes need to check which machine has established a connection and how many connections are being made. In today's article, we will discuss how to view such parameters. For situations like this, you can use the query below. SELECT DB_NAME(database_id) as [DB] , login_name , nt_domain , nt_user_name , status

Database Tutorials

10.12.2024

Check Database ALERT LOG Output - Database Tutorials

In today's article, we will be learning how to Check ALERT LOG Output in Database. We can query the errors encountered in the database directly without accessing the ALERT LOG file on the server as shown below. The following query will retrieve entries from the alert log file containing "ORA-", "shutdown", and "Checkpoint not complete".

Database Tutorials

16.12.2024

SQL Server Statistics Update - Database Tutorials

In today's article, we will be discussing the importance of seeing when SQL Server Statistics were last updated for the system. Statistics have a significant performance benefit in database systems. Queries draw their own path (execution plan) by looking at the statistics collected while they are running, and with the help of these paths, queries

Database Tutorials

17.12.2024

Statistics Collection Job Remaining Active In The Database - Database Tutorials

Sessions belonging to database statistics collection jobs can sometimes remain active. In this article, we will discuss how to identify and terminate these sessions. 1. "v$session" is queried from both nodes to find the remaining active sessions. SELECT SID, SERIAL#, USERNAME, STATUS, PROCESS FROM V$SESSION WHERE MODULE LIKE '%DBMS%'; NOTE: Sometimes this query may not

home›Database Tutorials

Database Tutorials

Software

How To See Active Connections In SQL Server - Database Tutorials

Check Database ALERT LOG Output - Database Tutorials

SQL Server Statistics Update - Database Tutorials

Statistics Collection Job Remaining Active In The Database - Database Tutorials

home
›
Database Tutorials