topic Re: Too many SQL queries for MSDE? in Server Management - Systems Insight Manager

Too many SQL queries for MSDE?

Pat Wilson — Wed, 03 Mar 2004 11:35:02 GMT

This is a frequent Application Event Log error:

Source: MSSQLSERVER
Category: (2)
Event ID: 17055

Description: "17052 :
This SQL Server has been optimized for 8 concurrent queries. This limit has been exceeded by 1 queries and performance may be adversely affected."

I am assuming this is because of MSDE? Anyone else experiencing this? I am currently monitoring 58 systems (a mix of Nt4, W2K, W2K3), and looking to expand next month by another 200 or so as we migrate/convert from IM5.5.

Re: Too many SQL queries for MSDE?

Rob Buxton — Wed, 03 Mar 2004 14:18:17 GMT

No, I've not seen the error and I thought there was a guide somewhere as regards at what number of Monitored Servers to move from MSDE to SQL Server but can't find it.

You might want to try the MS Site and see if there are any recommendations there. I don't know that there's many tuning options available for MSDE.

Re: Too many SQL queries for MSDE?

Pat Wilson — Wed, 03 Mar 2004 14:26:56 GMT

I have checked with my local MSSQL DBA's, and they tell me that this option is non-configurable with MSDE. During the HPSim install, one of the pages suggests that MSDE should be able to handle up to 500 monitored systems (see attached screen capture).

Is anyone else experiencing this? Is there something I can modify in HPSim?

Re: Too many SQL queries for MSDE?

Rob Buxton — Wed, 03 Mar 2004 14:49:04 GMT

And there's nothing obvious on the MS Site either.
We use MS SQL Server, we're only monitoring about 100 Servers but I got the okay to add the IM Database to our Corporate SQL Server. But I certainly don't see the problem here.
Do you have a lot of concurrent access to SIM?
Are there any additional regular tasks or have you increased the frequency or is this pretty much out of the box?

Re: Too many SQL queries for MSDE?

David Claypool — Wed, 03 Mar 2004 18:58:52 GMT

There is a "rule of thumb" that with MSDE we generally say "up to 500 devices and 5,000 events" and with SQL7/2000 it's "up to 5,000 devices and 50,000 events." This is not hard and fast and indicates typical loads and acceptable response times. Note that your error doesn't say it won't work, just that performance may be affected. We have users with more than 500 devices using MSDE, and users with less than 500 who swear by SQL. It's going to depend on how you want performance and how much activity is going on.