Monitor unlimited number of servers
Filter log events
Create email and web-based reports

Direct access to Microsoft articles
Customized keywords for major search engines
Access to premium content

Event ID: 17055 Source: MSSQLServer

Source
Level
Description
17122: initdata: Warning: Could not set working set size to <size> KB
Comments
 
This may be caused by an incorrect SQL configuration (misconfigured working set). As pe Microsoft, use the set working set size option to reserve physical memory space for Microsoft SQL Server that is equal to the server memory setting. The server memory setting is configured automatically by SQL Server based on work load and available resources. It will vary dynamically between min server memory and max server memory. Setting set working set size means Microsoft Windows NT does not swap out SQL Server pages even if they can be used more readily by another process when SQL Server is idle.

Do not set set working set size if you are allowing SQL Server to use memory dynamically. Before setting set working set size to 1, set both min server memory and max server memory to the same value, the amount of memory you want SQL Server to use.

Set working set size is an advanced option. If you are using the sp_configure system stored procedure to change the setting, you can change set working set size only when show advanced options is set to 1. The setting takes effect after stopping and restarting the server.

Windows Event Log Analysis Splunk App

Build a great reporting interface using Splunk, one of the leaders in the Security Information and Event Management (SIEM) field, linking the collected Windows events to www.eventid.net.

Read more...

 

Cisco ASA Log Analyzer Splunk App

Obtain enhanced visibility into Cisco ASA firewall logs using the free Firegen for Cisco ASA Splunk App. Take advantage of dashboards built to optimize the threat analysis process.

Read more...