Event ID - 17424

Event Id17424
SourceMSSQLServer
DescriptionWarning: OPEN OBJECTS parameter may be too low.
Event InformationCAUSE:
In most cases this error occurs because you have changed the open objects configuration option to a value greater than its default value of 0. A non-zero value limits the number of database objects that can be open at one time on an instance of SQL Server. It is recommended that the open objects configuration option be set to 0.
In some circumstances this error could be seen when there is system-wide memory pressure.

RESOLUTION:
Log in to this instance of SQL Server as a system administrator and issue the following commands:

sp_configure open objects, 0
GO
reconfigure with override
GO

Restart the instance of SQL Server for the change to take effect.

If the open objects configuration option is already set to 0 and SQL Server has been restarted to make that setting take effect, you should use System Monitor to check for system-wide memory pressure.
Reference LinksMicrosoft product: SQL Server Version: 2000.80.760.0 Event Source: MSSQLServer Event ID: 17424

Catch threats immediately

We work side-by-side with you to rapidly detect cyberthreats
and thwart attacks before they cause damage.

See what we caught

Did this information help you to resolve the problem?

Yes: My problem was resolved.
No: The information was not helpful / Partially helpful.