SQL-Articles

Tag: troubleshoot

  • Enable \ Disable Trace flags in SQL Server

    Trace flags are required for temporary purpose to analyze server level characteristics or behaviors during a course of action. It helps the DBA \ developers to troubleshoot the server. I’m not going deep into trace flag as this article I’m going to cover how to enable or disable trace flag for an instance of SQL…

  • How Much Memory is Needed Taken for My Database Backup

    In this article I will try and cover the concepts in understanding the amount of memory or buffers required for completing a database backup. I would be using a couple of trace flags to get that detail and further discuss two of the parameters MAXTRANSFERSIZE and BUFFERCOUNT in the BACKUP DATABASE TSQL syntax which will…

  • Measure SQL Server Replication Latency

    This script can be used to measure Latency in your Replication Subsystem. This script does not use TRACER TOKENS and there would be no negative impact to the system’s performance.

  • DotNet 3.5 on Windows 7 to Install SQL Server 2008

    This is a quick post to install or enable .Net 3.5 on windows 7. Last couple of weeks Im seeing more questions on installing SQL Server 2008 in windows 7 and the users are unable to install SQL Server 2008 pre-requisite (.Net 3.5 ). To Install SQL Server 2008, windows installer 4.5 & .Net 3.5…