SQL warning on NAV 4.0 SP1 SQL 2003

TallMikey
Member Posts: 40
Can anyone shed some light on what the following warning has to do with?
==========================
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
==========================
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
0
Comments
-
This seems like some kind of performance warning.
Are the users on your system experiencing performance issues?0 -
[Topic moved from Navision forum to SQL General forum]Regards,Alain Krikilion
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!0 -
I'd probably try to find this one on a SQL Server forum. Check out the public MSFT newsgroup on news.microsoft.com, there are some pretty nice people on there.0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions