Månedsarkiv: september 2013

So you’ve been upgrading your Opsview installation from Community to Core? If you’re using the ‘check_vmware.pl’ script to monitor your vCenter or ESXi, you might experience some errors from the related service checks, as they no longer can connect to … Læs resten →

When you are creating SQL scripts you will sometimes need to create a temporary file. This can be done in 2 different ways in SQL Server. — The scope of this temporary table is only the SPID that created the … Læs resten →

— You can use sys.dm_db_index_operational_stats to — track how many attempts were made to escalate — to table locks (index_lock_promotion_attempt_count), — as well as how many times escalations actually — succeeded (index_lock_promotion_count). — The following query shows the top 5 … Læs resten →