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…
//
-
-
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 …
//
-
High VLF Count in Database Log File
High VLF count can create a performance problem in huge OLTP SQL Server system. Every 10 GB of T-Log file, VLF count should not more than 50 VLFs. For example, if Database transaction log file size is 50 GB then as per recommendation, lets calculate optimum value for this much size of log file… First…
//
-
Contained Database
First introduced in SQL 2012 and its supported now. What it is Contained databases have no dependencies on server-level metadata and settings. User can access a Contained Database without authenticated a login at DB instance level. This helps to isolate the database from database engine and make it possible to easily move the DB from…
//