Category Archives: Monitoring

Example of Deadlock | SQL Server Deadlock Script

IS there a way I can stimulate a deadlock in SQL Server, so that I can use that as an example of deadlock Let’s take an example, where we will result / cause a dead lock to SQL Serve? To stimulate the Deadlock, let’s create two tables which we are going to use as an [...]

What Performance counters will you use to set up SQL Server baseline ?

What Performance counters will you use to set up SQL Server baseline ? Setting up SQL Server baseline is primary objective for every DBA. This baseline will be key during troubleshooting performance issues. A DBA should setup up a server base by using the following performance counters. S. No Counter Name Description 1 Memory\Available Bytes [...]

Can I use Profiler on SQL Server Express Edition ?

NO, SQL Server profiler is not supported on Express Edition. Recently, I came across with an incident, where one of my customer, wanted me to monitor SQL Statement on a Express Edition.  (Note: A Server, which has SQL Server Express edition installed, doesn’t host the profiler tool). So we have four workarounds available to run [...]

How to Monitor Database Mirroring, SQL Server?

SQL Server Mirroring can be monitored SQL Server Management Studio or via TSQL Queries Monitor LOG Shipping status Using SSMS Database Mirroring Monitor is a graphical user interface tool that enables system administrators to view and update status and to configure warning thresholds on several key performance metrics. How to Access Database Mirroring Monitor ? [...]

How to Monitor SQL Server Log Shipping?

LOG Shipping can be monitored SQL Server Management Studio or via TSQL Queries Prior to Monitor, let’s take a quick look a Log Shipping Scenario which we wanted to monitor Primary Server Details SQL Server Name .\SQL1 Database Name TEST_LOG_Shipping Secondary Server Details, where we are shipping Logs SQL Server Name .\SQL2 Database Name TEST_LOG_Shipping [...]