How to check Deadlocks in SQL Server

What is a SQL Server deadlock?What is a SQL Server deadlock? A deadlock in SQL Server occurs when 2 processes/sessions are competing for exclusive access to data in the tables but is unable to obtain exclusive access to it because the other process/session is preventing it. This results in a situation where neither process can…

SQL Server Database Mail Configuration Step by Step

What is SQL Server Health Check? Why is it important?

What is SQL Server Health Check? Why is it important? A SQL Server health check looks at all aspects of your SQL Server environment in terms of best practices in the areas of Performance, Configuration, Security, Disaster Recovery and the ability of your environment to scale to projected future loads. With a SQL Server Health…

Database File Free space and checking Database Growth Trends

Database File Free space and checking Database Growth Trends is one of the important tasks for a DBA for Pre-Sizing the Database to avoid the Autogrowths plus to have a idea of Space Requirements on the SQL Server etc. Below Query can be really helpful for store this information into a Central location and monitor…

Moving system databases in SQL Server 2008/2005

Moving system databases in SQL Server 2008, 2005 To move all the system and user databases from “C:Program FilesMicrosoft SQL ServerMSSQL10.MSSQLSERVERMSSQLDATA” folder to “C:System databases” location. We can use below query to check current location of system databases: Select name, physical_name from sys.master_files 1.Moving Tempdb database: We need to use the Alter database command to…

When do we use SQL Server Database in Restricted User Mode?

When performing some maintenance tasks, particularly in recovery situations, it is essential to limit access to databases by general users by restricting the user access. Restricted access mode can be employed to limit connections to high-level users only. ALTER DATABASE Command The ALTER DATABASE command allows a database administrator to modify SQL Server databases and…