Clota Blog

Category: Installation and Configuration

  • 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 Server browser services then we will not connect through named instance at SSMS by manually. Now see if we stop the browser services then we will not connect with named…

  • 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 and user DB get created by SQL user for application use. System Databases Master Records all the system-level information for an instance of SQL Server. MsdbUsed by SQL Server Agent for…

  • SQL Server Architecture

    We can put SQL Server architecture in 3 main categories…     1. Protocol Layer    2. Storage Layer    3. OS Layer  1. Protocol Layer      Connection Protocol      Query Processing 2. Storage Layer     Lock Manager     Transaction Manager     File Manager      Buffer Manager  3. OS Layer    Scheduler Manager    Memory Manager    Resource…

  • Common DBCC Trace Flags and their uses…

    Currently enabled globally trace flags… DBCC TRACESTATUS(-1);    1117 – Grow All Files in a File Group Equally 1118 – Full Extents Only 1204 – Focused on the nodes involved in the deadlock. Each node has a dedicated section, and the final section describes the deadlock victim. 1208 – Prints the host name and program name supplied by the client.…

  • SQL Server Database Transaction Log Truncation

    Transaction Log Truncation    If log records were never deleted from the transaction log, it would eventually fill all the disk space that is available to the physical log files. Log truncation automatically frees space in the logical log for reuse by the transaction log. Except when delayed for some reason, log truncation occurs automatically…

  • SQL Server Installation Type on a Server

    There are basically two types of installation in SQL Server… In Stand alone Installation again there are two different ways… SQL Server Services Configuration Manager Tool view for different installation…

  • Basic Tools in SQL Server

    Basic Tools in SQL Server

  • Cluster node was removed from the active failover cluster membership

    Below was the cluster setup where the issue came… Error messages which logged in Cluster error log… Cluster node ‘ABCD-xyz05’ was removed from the active failover cluster membership. The Cluster service on this node may have stopped. This could also be due to the node having lost communication with other active nodes in the failover cluster.…

  • SQL Server Security Check List

     Data is very crucial aspect of any organization or entity. Loosing, stole or destroy no one want and most of time can not effort. Below are the points which we need to consider if we are considering for Database security… 1. Physical Security2. OS Level Security3. SQL Instance Level Security4. Login Security 1. Physical Security …