Category: SQL Troubleshooting

0

Troubleshooting Database Slowness and Blocking with sp_who, sp_who2 and sp_WhoIsActive

489viewsWhen users are reporting slowness in applications then as a database administrator what is your first step, you will try to find some blocking from current active processes. Most of the DBA’s first step is...

0

SQL Server 2014 Upgrade Advisor Prerequisites, Download and Installation

What is SQL Server Upgrade Advisor? Microsoft has provided a free tool to analyse existing SQL Server Instance, database, its components, features and configurations and generates a report where you can analyse required changes to upgrade from...