What is SQL Server database mirroring?
March 15, 2014SQL Server alerts in troubleshooting performance issues: How to create and use SQL Server alerts
March 15, 2014Before creating a SQL Server alert, make sure that Database Mail and SQL Server Agent properties are properly configured Read more »
SQL Server alerts in troubleshooting performance issues: SQL Server alerting basics
March 14, 2014Why is SQL Server alerting important?
To be aware of what’s going on with your system and how SQL Server performs, monitoring is necessary. However, just monitoring might not be enough. Being notified about a performance issue whenever a specific SQL Server counter meets a threshold value, or a specific event occurs, boosts monitoring usability. These notifications enable DBAs to be aware of every important system performance change as soon as it happens, and therefore they can act immediately to fix the issue and prevent further problems Read more »What is a SQL Server disaster recovery?
March 14, 2014What is a SQL Server failover clustering
March 14, 2014What is a failover cluster?
SQL Server failover clusters are made of group of servers that run cluster enabled applications in a special way to minimize downtime. A failover is a process that happens if one node crashes, or becomes unavailable and the other one takes over and restarts the application automatically without human intervention Read more »A database back up task via SQL Server Maintenance Plans
March 14, 2014SQL Server Maintenance Plans – benefits, features, and functionalities
March 14, 2014Troubleshooting SQL Server issues with sys.dm_os_performance_counters
March 13, 2014sys.dm_os_performance_counters
sys.dm_os_performance_counters is a system Dynamic Management View (DMV) that returns one row for each SQL Server performance counter. It’s useful for obtaining information about current performance counter values. These counter values are also shown in Windows Performance Monitor, besides other operating system counters Read more »Ways to use and execute SQL Server Integration Services packages
March 13, 2014A DBA guide to SQL Server performance troubleshooting – Part 2 – Monitoring utilities
March 13, 2014A DBA guide to SQL Server performance troubleshooting – Part 1 – Problems and performance metrics
March 13, 2014SQL Server network performance metrics – The most important metrics
March 13, 2014SQL Server performance tuning using Windows Performance Monitor
March 12, 2014Windows Performance Monitor basics
March 12, 2014Read more »
SQL Server disk performance metrics – Part 2 – other important disk performance measures
March 12, 2014SQL Server disk performance metrics – Part 1 – the most important disk performance metrics
March 12, 2014SQL Server processor performance metrics – Part 4 – processor metrics useful for deeper investigation and troubleshooting
March 12, 2014In the previous part of this series, we presented the processor metrics that indicate hardware component problems that can affect SQL Server performance
In this part, we will present processor metrics that are not necessary in every performance monitoring scenario, but are useful for deeper investigation and troubleshooting Read more »SQL Server processor performance metrics – Part 3 – measures that indicate hardware component problems
March 11, 2014SQL Server processor performance metrics – Part 2 – Processor: % User Time, Processor: % Privilege Time, total times and thread metrics
March 11, 2014In SQL server processor performance metrics – Part 1 – The most important cpu metrics, we described the Processor Queue Length and two most important processor time counters – Processor % Processor Time and Process % Processor time
In this part, we will continue describing important time processor counters Read more »SQL Server processor performance metrics – Part 1 – the most important CPU metrics
March 11, 2014SQL Server memory performance metrics – Part 6 – other memory metrics
March 10, 2014SQL Server memory performance metrics – Part 5 – understanding Lazy Writes, Free List Stalls/sec, and Memory Grants Pending
March 7, 2014In this part, we will continue with SQL Server memory performance metrics and present Lazy Writes, Free List Stalls/sec, and Memory Grants Pending Read more »
SQL Server memory performance metrics – Part 4 – Buffer Cache Hit Ratio and Page Life Expectancy
March 5, 2014In SQL Server performance metrics – part 3, we presented some of the SQL Server Buffer Manager metrics. As the SQL Server buffer pool manages data cache, it’s important to monitor various buffer pool metrics as they help identify and solve memory pressure issues
In this article, we will present 2 more Buffer Manager counters – Buffer Cache Hit Ratio and Page Life Expectancy.
Read more »