Blog Archives

SQL Server 2016 new features & common performance issue of Tempdb Contention

Tempdb the “shared resource” or the “scratch pad” or even the “waste bin” as described by many names in SQL Server has of course a lot many important things to do but by very nature of any shared resource there

Tagged with: , ,
Posted in log, sql, SQL Server, Uncategorized

SCOM custom event based rule to monitor Reboot, unexpected shutdowns and BSOD crashes

Ok the requirements are simple. We want to find out whenever a system is shutdown or rebooted. Both Planned / User driven and unplanned (BSOD crashes / power cuts) Pretty basic. Its amazing that it doesn’t come with a Microsoft

Tagged with: , , , , ,
Posted in log, Monitoring, SCOM, windows