Late Night with System Center Management

It’s 3:30 a.m. and your trusty mobile phone on your nightstand buzzes a hideous, nasty, telltale racket. You pick up the smartphone and squint in the darkness at the glowing message that informs you that one of the e-mail servers at work is down. As you’re about to dismiss the nasty-gram in your still-half-asleep daze (who would need e-mail at 3:30 in the morning?), you bolt up wide-eyed! You suddenly realize the server that’s down serves critical e-mail services for a team three time zones east of you. And, at 6:30 a.m. their time, a downed server spells near-immediate and definitely impending doom as the workforce at that facility is about to start their shift.

Read more

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