NAV 4.0 SP1 SQL warning message

Business Central/NAV Technical Forum
1

Can anyone clarify what this message means?

==================================

From: smartmonitor@doitsmarter.com [mailto:smartmonitor@doitsmarter.com]

Sent: Monday, March 05, 2007 9:59 AM

To: Support

Subject: [-] : Critical : Expo Industries : exponav1.expo.local :

[Thresh] SQL Server Batch Requests - SQL Server on exponav1.expo.local

Serial : 158232

Status : [-]

Severity : Critical

Domain : Expo Industries

Device : exponav1.expo.local

Summary : Batch Requests/sec Exceeds 1000.0 reqs on SQL Server on exponav1.expo.local for 0 minutes Last Value : 2218.38 Time : 05 Mar 2007 09:56:14 AM

Public IP : 172.31.1.15

Private IP :

SNMP Index :

App Name: SQL Server on exponav1.expo.local App Desc :

Device Desc :

Domain Desc :

MP Name : Core Monitoring Policy

MP Desc :

PC Name : SQL Server Batch Requests

PC Desc : Batch requests that SQL Server receives/sec., emulates how busy your server’s CPUs are. Over 1000 batch requests per second indicates busy SQL Server and may mean CPU bottleneck. A relative number, with bigger hardware, SQL Server handles more batch requests/sec. With network bottlenecks, a 100Mbs NIC may handle 3000 batch requests/sec. You may need two or more NICs, or 1Gbs network card.

Rule Name : FN Customer Alerts

2

Hi TallMike,

I hate to appear patronising here, but I think is telling you in the message, that the Batch request (requests for SQL server to do something) are unusually large (the number of them)

I think its saying its concerned that your server is not up to the job and there may be a delay in dealing with all the requests.

Try adding a Trace counter to work out when this is occuring, and what the users were doing at the time, it may be a case of poorly structured code.

/TH