Category Archives: SQL Server

SQL Server 2012 comes up with new workload option in DTA (Database Tuning Advisor). In addition, on existing options File or Table, Microsoft gives option to fetch workload from plan cache of SQL Server. In this case, the DTA will select the top 1,000 events from the plan cache based on total elapsed time of … Continue reading →

Steps to remove node from failover cluster for SQL Server 2008 onwards :- Note :- a) Same process will be used to remove node from failover cluster b) Same process will be used when you left with only one node, this will clear cluster group as well c) Old process of uninstallation from Add and … Continue reading →

Issue: MSDB database log file is getting full very rapidly and became very huge. Currently, T-Log file is of 5GB whereas Data file is only 1GB for MSDB on server. Findings: We found system owned open transaction in MSDB which is causing issue. Transaction information for database ‘msdb’. Oldest active transaction: SPID (server process ID): … Continue reading →

ERROR : Error Message 1 : Executed as user: Domain\UserName. SSIS error. Component name: DFT – Upload collection snapshot, Code: -1071636372, Subcomponent: RFS – Read Current Upload Data [1], Description: String too long. The adapter read a string that was 50331648 bytes long, and expected a string no longer than 129 bytes, at offset 12901. … Continue reading →