Category: SQL Tips and Tricks

0

Identify Database Bottlenecks with Performance Monitor Counters

443viewsPerformance monitor is a free tool provided by Microsoft windows and is very useful to analyse real time and historical performance information of your database servers and windows servers. So if you don’t have...

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...