MS SQL: “tablediff ” Utility

tablediff.exe utility features: MAIN funtion: Comparison between two tables from SQL Server instance. Row by row fast comparision. **Perform column level comparison.** Easily generate change script between production and development SQL server instances. Log result can be captured as output file or database table. Directory Path: tablediff.exe is available on SQL Server instance at “<DriveLetter>:\Program…

NTP – setting via gpedit

Using the NTP Pool on Windows to Keep Your Clock Set This approach requires GPEDIT.MSC, it will work on any windows machine that has GPEDIT.MSC, that also has windows time service installed. >Launch gpedit (start/run/”gpedit.msc”) >open to the following node, Computer Configuration/administrative templates/System/Windows time service/Time providers >double click “Configure Windows NTP Client” >choose the “enable”…

CA SD: New incident > open date/time

Issue: CA SD: New incident > open date/time is different from current time and date Resolution: *Checked SD and DB servers date and time is current *Checked the SVR TIMEZONE (set on another country) rectified.. Issue is fixed. >> Make sure your Servers are in the right time zone and date/time  

Haunting the Ghost inside the SQL shell

What: The CPU counrte hitting the ceiling level of 100% …flat…. hanging.. When: Time when your applications, site, service becomes intermittent, timing out or stops responding completely Why: The Ghost_counter inside MS SQL increasing rapidly Who:  values of the ghost_record_count and version_ghost_record_count columns Where: View and monitor it here >> (run this script) SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'<DatabaseName>’), OBJECT_ID(N'<TableName>’), NULL,…

CPU 100%

An application stops responding, experiences low performance, or experiences high privileged CPU usage if many large I/O operations are performed in Windows 7 or Windows Server 2008 R2 Symptopms:   Consider the following scenario: You have a computer that is running Windows 7 or Windows Server 2008 R2. The computer has many logical processors. You…