Performance Effect of Number of Virtual Log Files in SQL Server

Overview

The transaction log files, records all the changes made to the SQL Server database as well as keeps the transactions. It is known to be the inevitable part of the SQL Server. These files are again divided into smaller virtual log files. If the number of virtual log files is more then, it is clear that the performance of transaction logs will get slow down. Here, in this session you will get to know about it in detail. Anyways, before moving into the effects, let’s have a check on what is ‘Virtual Log’ file. Continue reading “Performance Effect of Number of Virtual Log Files in SQL Server”

Methods for Tracking Login Password Changes in SQL Server

Tracing is a onetime procedure run through an act to find out the root whereas tracking is a continual process. To remain updated with the regularly made changes, tracking of an activity must be done. Similarly, on an SQL Server, one can track down the login password changes in SQL Server. However, SQL Server is not programmed to maintain a log of the changes in password taking place, by default. Continue reading “Methods for Tracking Login Password Changes in SQL Server”

Importance of SQL Server Backup History for a Database

Why SQL Server Backup History Important For A Database

What is the use with backup files? How will they make a way of help? Now, all the enterprise stores their information in the SQL Server database and it makes a way for backing up the data. Backup files are of great importance for any organization since when some problem strikes the backup files will help Continue reading “Importance of SQL Server Backup History for a Database”

Blog at WordPress.com.

Up ↑