Månedsarkiv: september 2013

Upgraded from Opsview Community Edition to Core – trouble with check_vmware.pl?

Udgivet den 11. september 2013 af Kenneth Dornhoff

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 →

Udgivet i Opsview Monitoring | Tagget , , , , | Kommentarer lukket til Upgraded from Opsview Community Edition to Core – trouble with check_vmware.pl?

How to create a temporary table in SQL Server

Udgivet den 11. september 2013 af seo

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 →

Udgivet i SQL Server - scripts | Tagget , | Kommentarer lukket til How to create a temporary table in SQL Server

Track down escalation locks

Udgivet den 10. september 2013 af seo

— 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 →

Udgivet i SQL Server - scripts | Tagget , , | Kommentarer lukket til Track down escalation locks