Trace Flags in SQL Server are used for either setting up a server characteristic or for switching off a server behavior. They help generate information about internal activities of the server, which primarily helps the developers of SQL server to troubleshoot their codes. Continue reading “Understanding Trace Flags in SQL Server & Its Implementation”
There are many scenarios SQL Server database becomes inaccessible because it is marked as Suspected. When the database is in suspected mode, user cannot access and cannot perform transaction on that data until it comes back to online mode. In addition, if the backup is not generated before database corruption, user cannot perform any action.
What is SQL Server Wait Type?
In SQL server, wait type is a time period for which the processes stays in the local buffer. Until the log record writing process is not completed, it remains in the log buffer. It provides a high-level information of the particular process or a query on which the user is working upon. Moreover Continue reading “Resolving SQL Server Transaction Log Waits”
Most of the users of SQL Server need to deal with several issues while working with the database including corruption related problems. One of the common issue is corruption of clustered index. The data becomes inaccessible to the user when this issue occurs in MS SQL Server. Inaccessibility of the database may be the worst situation for the users working on the database. Continue reading “Effortlessly Repair Clustered Index In SQL Server”
An Overview of AlwaysOn Availability Groups
An AlwaysOn Availability groups in SQL Server provides high availability for a set of user databases called availability databases that failover together. Each group supports a set of primary databases and multiple secondary databases. The availability database set is hosted by availability replica. Single primary replica hosts the primary databases and multiple secondary replica to host sets of multiple secondary databases. An availability replica provides redundancy only at the database level for set of databases one availability group.
SQL Server has this general event-handling system well known as Extended Events, which supports correlation of data from server. It also supports correlation of data from OS and database software applications where the output has to be directed to Event Tracing for Windows for acquiring correlation of event data. Continue reading “Extended Events in SQL Server – An Overview”
SQL Server has a categorized storage defined for all its data. Databases are stored and maintained as MDF and NDF files respectively, which denotes primary and secondary database each. On the other hand, there is a Transaction Log database file for every master database. The job of a transaction log file is to store all activities performed on the respective database as part of a record. In this article we will know how to view SQL Server transaction logs using fn_dblog() function and other mechanism. Continue reading “How to View SQL Server Transaction Log File”
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”
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”
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”