-
Migrate MongoDB To CosmosDB
Pre-requisites- Steps to perform backup and restore- Step-1: Connect to the source MongoDB server and take a data dump using the mongodump utility. mongodump \…
-
How to Monitor SQL Server Deadlocks with Extended Events
Extended Events were first introduced in SQL Server 2008, and therefore you will not face any problem implementing them in our environment. Extended Events is…
-
Worker appears to be non-yielding on Scheduler
The error message “Worker appears to be non-yielding on Scheduler” in SQL Server typically indicates a performance issue where a worker thread is stuck and…
-
About Us Clota
At CLOTA Technology, we provide innovative solutions in database technologies, web development, cloud maintenance, and software support to help businesses achieve their goals. Our services…
-
Resource Database
Resource Database having below properties: 1. Read only DB 2. Contains system objects 3. Does not contain any user objects 4. Physical name of the…
-
Counters for Monitoring SQL Server Performance
Below are the top few counters which we need to monitor to know SQL Server performance. On the basis of optimal values of the counters,…
-
Endpoint
Endpoint: An endpoint is a SQL Server object that enables SQL Server to communicate over the network. It encapsulates a transport protocol and a port…
-
Deadlock
Deadlock is a situation where two or more transactions wait for completion of each-other for resources but none of them completes. or Deadlock occur between…
-
SQL Server Browser
Start and Stop SQL Server Browser Service It’s possible to start/stop the service using SQL Server Configuration Manager or Services.msc. If we stop the SQL…
-
Database Indexes and Maintenance
SQL Server B-Tree Indexes Root Level Intermediate Level Leaf Level Index Column Selection DMV for analysing Index sys.dm_db_index_physical_stats(null,null,null,null,null) Clustered…
-
Orphaned user in Database
List of Orphan user in DB We can list out all the orphan users from a database using below query… USE <database_name> Exec sp_change_users_login @Action=’Report’; GO; Fix Orphan user…
-
Database
There are two types of database in SQL Server. 1. System Database2. User Databases System databases are default database which are mandatory to start SQL Engine services…