Clota Blog

Category: DBA Worries Continued

  • 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, we can identify performance of SQL Server… They are…  1.  SQLServer: Buffer Manager: Buffer Cache hit ratio  2.  SQLServer: Buffer Manager: Page life expectancy  3.  SQLServer: SQL Statistics: Batch Requests/Sec…

  • SQL Server Services

    Below are the SQL Server services which might come after SQL installation based on your selection… •       SQL Server • SQL Server Agent • Other SQL Services • SQL Server Browser • SQL Server Full Text Search • SQL Server Integration Services   • SQL Server Reporting Services  • SQL Server Analysis Services

  • SQL Server 2016 SP2 CU12 Upgrade Issue.

    Few days back my patching team was doing security upgrade on one of customer production server. After their patching SQL Server has not came up. That was the issue. Earlier SQL Server patch level: SQL Server 2016 Standard Edition with SP2 with CU11Current SQL Server patch level: SQL Server 2016 Standard Edition with SP2 with CU12…

  • Managing Database Transaction Log File

    Hey guys, In this blog I am going to explain you about “How to manage Database Transaction Log File” This is the very common task which any DBA does regularly. Reason behind doing Transaction-Log file shrink… 1. Some time because of low disk space on T-log disk.2. Log-backup job issue. Sometime what happen because of log backup…

  • 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…

  • Pages in Database

    Boot Page Every DB has only one boot page. Boot page stores DB configuration information. It can find in page # 9 of the first DB data file. Bulk Changed Map (BCM) Page BCM page keep track of the extends which has modified by bulked-logged operations. Log backup thread reads this page and get the extends…

  • Wait Types in SQL Server

  • SQL Agent Jobs running multiple times out of schedule

         This was interesting issue which I faced in one of my production environment. Customer complained their all SSIS jobs are running multiple times at a schedule. But in job history, it was showing all well. We found, all the scheduled Backup maintenance jobs also triggering two times at a schedule. We tried below…

  • SQL Server Memory Architecture

    There are four major components of SQL memory architecture… 1. Memory Broker2. Memory Object3. Memory Clerk4. Memory Node In short, BOCN. (For remember it “Boy Of Cartoon-Network”) 1. Memory Broker Purpose of Memory Broker is to provide a centralized mechanism to distribute/control memory the allocation made by each component in SQL Server. Note: Memory brokers do…