Category: SQL Server

One method to troubleshoot SQL Server Deadlocks is to use the SQL Profiler. In SQL Profiler, in a new trace, select the Events Selection tab and expand Locks: Select the Deadlock graph: Run the code that causes a deadlock. In profiler, you will now see a line for the Deadlock graph. Selecting it will show the graph with the process that succeeded and did not succeed: Hovering over the graph … Continue reading SQL Server Deadlock Troubleshooting with SQL Profiler

There are a few ways to troubleshoot errors from deadlocks in SQL Server. One of these ways is to use tracing. First, turn on tracing using the command (a Database Console Command): DBCC TRACEON (1222, -1) You should see: Now, wait for a deadlock in SQL Server to occur. Once it occurs, you can run the following command to read the error log: exec sp_readerrorlog Scroll to look for the … Continue reading SQL Server Deadlock Troubleshooting with TRACEON

In this post we will take a look at how deadlocks occur in SQL Server. Deadlocks are when two or more tasks are trying to lock the same resource. For example, if you have a stored procedure that locks a table, and another stored procedure is also trying to access that table, you may end up with a permanent deadlock situation. SQL Server has a process that detects if there … Continue reading SQL Server Deadlocks

In Azure, there is a SQL Server 2016 virtual machine to get you up and running quickly. To install it, go to portal.azure.com and select Databases->SQL Server 2016 SP1 Enterprise on Windows Server 2016: Enter the basic information: Choose the VM size: Choose settings: SQL Server Settings: Confirm the summary: Connect to the VM: An RDP session will open. You will see SQL 2016 installed:

The AdventureWorks sample databases that had been used for a long time for SQL Server have been replaced with the SQL Server 2016 version. This new database contains many new features. To install the database, go to: https://github.com/Microsoft/sql-server-samples/releases/tag/wide-world-importers-v1.0 We will restore a local database and local data warehouse. Database is installed: Restore the data warehouse, place the file in a directory run the command replacing the source directory below: RESTORE FILELISTONLY FROM DISK … Continue reading Install SQL 2016 Sample Databases

To install SQL Server 2016 go through the following steps. Download SQL Server and run the executable. In this case we will install SQL Server 2016. Select the components to install:    

Microsoft provides sample SQL Server databases called AdventureWorks. You can download the files from the CodePlex website for your relevant SQL Server version here – http://msftdbprodsamples.codeplex.com/.  You can then attach the databases to your SQL Server instance. To do this, copy the files to a location on the SQL Server and run the following command: CREATE DATABASE [AdventureWorks2012] ON (FILENAME = N’C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\AdventureWorks2012_Data.mdf’) FOR ATTACH_REBUILD_LOG GO CREATE DATABASE [AdventureWorksDW2012] ON (FILENAME … Continue reading Installing Microsoft SQL Server AdventureWorks Sample Data

To install SQL 2005, go through the following steps. Select Install->Server Components: You may get this message here. This install is on a Windows 2008 R2 server. Select Run Program. We will install service packs later. Select Next: Select Next: Select Next: Select Next: Confirm your registration keys and select Next: Select the components you want to install: Select Advanced and ensure Client Components is checked for Management Tools: Select … Continue reading SQL 2005 Install