Articles Posted in the " SQL SERVER 2014 " Category

  • Fix High or Low VLF Count

    Fix High or Low VLF Count

    We started collecting a count of all VLF across the enterprise and yes there were few with high counts. I know there are no SET guidelines how many is too low or too high. After chatting with MVP Allen Kinsel (Blog|Twitter) and Kevin Conan (Twitter) I decided to fix using this threshold. You will be able adjust these threshold in my script to whatever you deem reasonable.

    ( (vlfcount > 50
    AND tLogSizeMB <= 8 * 1024)
    (vlfcount > 200
    AND tLogSizeMB BETWEEN 8 * 1024 + 1 AND 36 * 1024)

  • WMI issue with SQL Server 2014

    WMI issue with SQL Server 2014

    Issue: I installed sql2014 enterprise edition with cu3 in following machine.  Just as a disclaimer I have been running a sql2012 edition on the same  host without any issue with WMI counters.



    I could not see any wmi counters for sql2014.  I tried perfmon.exe and also querying:

    SELECT * FROM sys.dm_os_performance_counters
    SELECT * FROM sys.sysperfinfo

    Then I snipped through sql server error log and found this:

    Cannot query value ‘First Counter’ associated with registry key ‘HKLMSYSTEMCurrentControlSetServicesMSSQL$SQL2014Performance’. SQL Server performance counters are disabled.

    So I went to registry and added a new key with value 4090 under  HKEY_LOCAL_MACHINESYSTEMCurrentControlSetservicesMSSQL$SQL2014Performance


    Restarted sql …