Maximum number of Services or DB's

[bmottlaw]

Is there a max # of services or more specifically a max number of discoverable MSSQL databases?
I've got multiple DB servers and two of them have over 125 db's yet the console only recognizes 99 and is unable to connect to valid DB's when I attempt to add them manually.

Thanks in advance for anyone's assistance,
BJ Mott

[cwitt_hyperic]

This is a reproducable bug. I opened a ticket through which progress can be tracked:

http://jira.hyperic.com/browse/SIGAR-41

I've been told that this should be pretty easy to fix. Thanks.

[dougm_hyperic]

At first glance I thought this was something we'd be fixing in
sigar's Pdh class.. but it turns out this looks like an MS issue.
Chip created 125 database instances in addition to the 6 example
databases. I looked with perfmon.exe and it only lists the 6
defaults + DB_test1..DB_test93 == 99 total. So if the data isn't
visible to perfmon.exe, we can't access it either. This was on
Windows 2000 Server with SQLServer 2000, what versions are you
running BJ?

On Feb 2, 2007, at 4:30 PM, Chip Witt wrote:

> This is a reproducable bug. I opened a ticket through which
> progress can be tracked:
>
> http://jira.hyperic.com/browse/SIGAR-41
>
> I've been told that this should be pretty easy to fix. Thanks.
>

[cwitt_hyperic]

I found a supporting MS KB article that confirms this is a known limitation for the performance counters in Windows System Monitor. See here:

http://support.microsoft.com/kb/330088

The only workaround seems to be in creating a separate named instance for databases beyond the first 99, since each named instance has its own performance object in the list of objects.