sql performance monitor

• Performance issues
• Performance Tuning
• SQL Server
• SQL Server Admin
• SQL Server Administration

Adding Data Collectors on SQL Server 2008/2008 R2/2012/2014/2016

Adding SQL Server Data Collectors to SQL Server is very important for Troublshooting issues and Root cause analysis of many…

• Connectivity Issues
• SQL Server Admin
• SQL Server Administration

Active Connections to SQL Server Database 2008, 2005 by Application or User

To Check Active Connections to SQL Server Database grouped by User Below query is very helpful in finding the Total…

• SQL Server
• SQL Server Admin
• SQL Server Administration
• Transaction Log
• Transaction Log Shipping

How to check Log shipping status in SQL Server 2008

How to check Log shipping status in SQL Server 2008: SQL server recovery model has to be Full recovery mode…

Important Perfmon Counters %Processor and Disk monitoring counters

Monitoring  SQL Server Performance is one of important task for a DBA using Performance Microsoft Management Console (MMC) snap-in.  Performance…