SQL Server -DBA Archives - NTSEQ:- A IT Infrastructure and Cyber Security Blogs

Identifying blocking and locking Currently executing Queries with Waits In SQL Server

This is one of my favorite script which I use most of the time in troubleshooting performance issues on production

Find SQL Text of recently executed queries in SQL Server

Finding SQL Text of recently executed queries in SQL Server we can find out SQL Text of recently executed queries

How to know memory usage in SQL Server?

We can find out memory usage of SQL Server by using below scripts. select total_physical_memory_kb/1024 AS total_physical_memory_mb, available_physical_memory_kb/1024 AS available_physical_memory_mb,

How to Add data file or log file in SQL Server?

We can add data and log file in SQL Server through below script. Add data file(.mdf) in SQL Server ALTER

SQL Server – Resolve Error 5030 to Rename Database

When we try to rename the database then getting error below Msg 5030, Level 16, State 2, Line 1 The

SQL SERVER – How to Identifying TempDB is growing abnormally in SQL SERVER

Recently I have observed that the size of the TempDB is growing rapidly then I tried to identify which queries

Difference Between Checkpoint And Lazy Writer

CHECKPOINT vs LAZY WRITER CHECKPOINT LAZY WRITER Check point runs in only transaction log file Lazy writer operates from buffer

Lazy writer in SQL Server

Lazy writer Lazy writer in SQL Server :- Lazy writer check each page header and verify whether all transactions in

Lock Granularity in SQL Server

Understanding Lock Granularity in SQL Server SQL Server Lock granularity describe which resource is locked by a single lock attempt.

How to check connections for a particular Database in SQL Server

Below Script provides the connections details for a particular Database in SQL Server. select spid,loginame,blocked,waittype,cpu,hostname,DB_NAME(dbid) AS DB_NAME ,status from sys.sysprocesses