Category: SQL Server Monitoring

Preventative SQL Server Monitoring
Posted by Rob Risetto on March 23, 2015

This article (here) from LogicMonitor provides some interesting performance counters to review to isolate potential SQL Server performance issues. The performance counter charts are from the LogicMonitor monitoring tool, however, the same counters can be captured using your favourite performance counter capture tool.

Continue Reading

Is your SQL Server VM sluggish? Then Check out the VMWare CPU Ready {2ec0bbd3bfdf207d2f0779c26660c3798ccadae611e41b6dbc787103c4a85cdd}
Posted by Rob Risetto on March 10, 2015

On numerous occasions I’ve had customers complain about intermittent SQL Server performance only to find that the root cause was not the workload generated by the SQL Server VM but that the VMware environment was oversubscribed and was not providing sufficient CPU resources to the SQL Server when required.

Continue Reading

Wait Statistics and FileIO Delta Capture Utilities Updated
Posted by Rob Risetto on February 26, 2015

Reviewing the deltas of Wait Statistics and Database File IO gives you a better indication of what is happening now on your SQL Server now and are not skewed by the historical accumulated values.

Continue Reading