SQL Instances and Databases

Apr 29, 2010 at 5:25 AM

Followed the instructions to install the service and have opened the client to see 4 pyshical servers listed but can not see the 7 instances or the 20 databaases.

Any ideas on what I might be missing?

Thanks

Coordinator
Apr 29, 2010 at 8:12 AM
Yes,

it seems that there is an issue on getting some instance information. Can you provide me the exact error. To do so follow these steps:
1. Stop the service
2. Start a cmd box
3. Navigate to the folder where you have placed the sqlmonitoring tool
4. Start the monitoring with: sqlmonitoring.service.exe -debug

This wil show up errors that are not logged in the errorlog. One of them must be very quick and shows an error when connecting to the instance. As a result of an error when connecting or getting information from the instance(s) the other instances as well as the databases are not shown.

On the other hand it may also be a failure within the client. To check this start SQL Server Management Studio and navigate to the database. Get the data inside the SqlInstances or SqlDatabases table. If this table shows you all the information the problem lies in the client. I will check in the current database schema to see of there is a problem in the stored procedures.

Robert

2010/4/29 groveraus <notifications@codeplex.com>

From: groveraus

Followed the instructions to install the service and have opened the client to see 4 pyshical servers listed but can not see the 7 instances or the 20 databaases.

Any ideas on what I might be missing?

Thanks

Read the full discussion online.

To add a post to this discussion, reply to this email (sqlmonitoring@discussions.codeplex.com)

To start a new discussion for this project, email sqlmonitoring@discussions.codeplex.com

You are receiving this email because you subscribed to this discussion on CodePlex. You can unsubscribe or change your settings on codePlex.com.

Please note: Images and attachments will be removed from emails. Any posts to this discussion will also be available online at codeplex.com


Feb 4, 2013 at 2:02 PM
Edited Feb 4, 2013 at 2:03 PM
Hi Robert,

When I installed the service, I too got only the computer info and no instances and databases.
I was glad I found this thread, but unfortunatly no reply ...

I started the service in debug mode and captured the error:

SqlMonitoring.Service, build 2.0.2424.0
Starting from the commandline
20130204 15:52:25.92 Information ServiceCore.LoadSampledData Data retrieval
started...
Connecting to instance ..........................
20130204 15:52:26.94 Error ServiceCore.SqlCore System.FormatException:
Input string was not in a correct format.
at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffe
r& number, NumberFormatInfo info, Boolean parseDecimal)
at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo in
fo)
at SqlMonitoring.Service.Sql.Server.GetServerInformation()
at SqlMonitoring.Service.Sql.Server.get_Information()
at SqlMonitoring.Service.Sql.SqlCore.GetSampledData(DataTable sampledData, Da
taTable customCollector)
at SqlMonitoring.Service.ServiceCore.LoadSampledData()
20130204 15:52:26.95 Information ServiceCore.BulkCopyData Bulk inserting dat
a...
20130204 15:52:26.95 Information ServiceCore.BulkCopyData Copied SampleData:
2 rows
20130204 15:52:26.96 Information ServiceCore.ProcessAlerts Processed 0 Alert
(s).

Do you know what is wrong here?

Thanks in advance!

Andre