Ten Performance Monitor Counters to Analyze SQL Server Memory Pressure

Many experts agree that memory is the most important resource with regard to SQL Server performance. There are hundreds of performance counters, and therefore, it can be complex to figure out just what to monitor. Here are some suggestions in understanding whether memory pressure might be the performance problem with your SQL Server. You can use Performance Monitor to collect this data. You can also obtain the SQL Server specific counters using the Dynamic Management View (DMV) that is built into SQL Server. The DMV is an excellent and lightweight option for performance monitoring. You can use this syntax.

Read more

Securing our Next Generation Networks and Data Centers

No matter which IT conference I attend, I always look forward to hearing Cisco Systems Senior Vice President Chris Young speak on security, if he happens to be on the agenda. I’ve heard the former RSA VP and VMware exec speak at past Cisco Live! and RSA conferences and have never been disappointed. Cisco Live! 2013 in Orlando was no different.

Young started off by sharing what he’s heard time and time again from Cisco customers across the globe. From mobility to BYOD to cloud, most businesses are struggling with diverse IT issues. But how to maintain security and compliance as the IT landscape is constantly changing comes up most. He said staying ahead of the IT security threat landscape – or at least trying to keep up with it is essential. The key is to also handle all the complexities created when we try to manage the combination of those two things.

Read more