Logger for performance testing

About the Logger Logging is an integral part of performance testing. The following method of logging performance testing, (done) using coded UI test or selenium test using Visual Studio will help in getting better insights into The response time for a transaction The response time for a complete scenario Finding out average response time 90th…

0

Re-initialization with Log Sequence Numbering (LSN) for SQL Server Failover and Failback.

Log Squence Numbering (LSN) : Every record in the SQL Server transaction log is uniquely identified by a log sequence number (LSN). LSNs are ordered such that if LSN2 is greater than LSN1, the change described by the log record referred to by LSN2 occurred after the change described by the log record LSN. The following are the pre-requisites…

0

Setting up Always On Availability group on SQL Server 2012

Note: User is expected to have basic knowledge of Always On Availability groups. Pre-requisites :- Setting up Windows Server Failover Cluster (WSFC) Installation of Windows Server edition (2008 R2 or higher), SQL Server 2012, Windows Cluster + KB for quorum voting configuration, SQL Light Speed and DFS. The primary and the secondaries on the primary…

0

SQL Server Replication

Replicating a database  In order to create replication for a database, create a new publication as shown in the figure. Create publication on the publisher server. Create subscription on either subscriber (in case of pull based subscription) or on the publisher ( in case of push based subscription).     Here SERVER1 can be distributor…

0

Log shipping for SQL Server

The steps describe how to perform log shipping using GUI. 1. Assume machine on which log shipping is performed as primary.     PRIMARY = //MACHINE-NAME/ (or) //IP-ADDRESS/     PRIMARY = SECONDARY but it can also be different. 2. Create a database => AdventureWorks on PRIMARY    use AdventureWorks    create table employee ( name varchar(20),…

1