Category: Database Administration

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

0

SQL Server Wait Types – Trace and Tune Database Performance Issues

356viewsIt is a big challenge for database administrators to trace performance issues, tune and maintain database server effectively. I receive many queries regarding database performance issues, some issues come after migration, some issues are...