[Script of Oct 25th] Check SQL Server missing KB2277078 to prevent leak of security audit entries

  • Article

Script Download: CheckSQLInstanceVersionNumber.zip https://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-missing-ac29a3ed

This script will demo how to check SQL Server missing update KB2277078 to prevent leak of security audit entries in TokenAndPermUserStore.

When we create and enable a SQL Server audit on a computer that is running Microsoft SQL Server 2008 R2 or Microsoft SQL Server 2008, the TokenAndPermUserStore cache store continues to grow in size. Additionally, the size does not decrease even when we run the DBCC FREESYSTEMCACHE command, this issue occurs because a memory leak occurs when a SQL Server audit is enabled on an object. To fix it, for different versions, we should install the corresponding updates.

 

image image
image image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery